MairaDB初始化配置

run as root，非sudo

mysql_secure_installation

打开远程访问：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;
flush privileges;

创建admin账户：

insert into mysql.user(Host,User,Password) values("localhost","admin",password("admin"));
flush privileges;

远程连接Error 10060

iptables -A INPUT -p tcp --dport 3306 -j ACCEPT

创建admin用户

use mysql;
CREATE USER admin IDENTIFIED BY '<password>';

授予访问数据库权限

grant all privileges on <db_name>.<table_name> to 'admin'@'localhost' identified by '<password>';
可用*表示所有DB或表

或者一键创建并授权

GRANT USAGE ON *.* TO 'admin'@'localhost' IDENTIFIED BY '<password>' WITH  GRANT OPTION;      #admin仅可在本机访问
GRANT USAGE ON *.* TO 'admin'@'192.168.1.%' IDENTIFIED BY '<password>' WITH  GRANT OPTION;  #192.168.1.*网段的admin可访问本机

最后刷新Privileges

FLUSH PRIVILEGES;