登录:
mysql -u root -p
显示数据库:
show databases;
使用数据库:
use confluence;
设置数据库隔离模式:
set global transaction isolation level read committed;
Host is not allowed to connect to this MySQL server 解决方法
ERROR 1130: Host '11.206.2.6' is not allowed to connect to this MySQL server
mysql> use mysql;
mysql> update user set host = '%' where user = 'root';
mysql> FLUSH PRIVILEGES;