linux回炉第二十二天

# 跳过密码验证，慎用
[mysqld]
skip-grant-tables

select host,user,authentication_string from mysql.user;
create user wang@'11.0.1.%' identified by '123456';
create database testdb;
grant all on testdb.* to wang@'11.0.1.%';
show grants for wang@'11.0.1.%'\G

yum install php httpd
systemctl start httpd

vim /var/www/html/index.html
test

vim /var/www/html/index.php
<?php
phpinfo();
?>

vim /etc/my.cnf
default_authentication_plugin=mysql_native_password   #增加

systemctl restart mysqld

select @@default_authentication_plugin;
create user wordpress@'11.0.1.%' identified by '123456';
create database wordpress;
grant all on wordpress.* to wordpress@'11.0.1.%';

tar xf wordpress-5.8-zh_CN.tar.gz
mv wordpress/* /var/www/html/
chown -R apache.apache /var/www/html
systemctl restart httpd

yum install -y php-mysqlnd php-json

	MyISAM	InnoDB
索引	不支持	支持
外键	不支持	支持
缓存	不支持	支持
行锁	不支持	支持
MVCC<br />多版本并发访问控制	不支持	支持
事务	不支持	支持

show variables like 'default_authentication%';
show variables like 'storage_engines%';
select @@default_authentication_plugin;
select @@max_connections;

show variables like 'max_connections%';
set global max_connections=1000;

select @@sql_mode;

show status like '%engines%';