Linux安Mariadb(centos7)

centos7装mysql总是报错，改用mariadb

yum install -y mariadb-server
systemctl start mariadb.service

没有初始密码

use mysql;
UPDATE mysql.user SET password = PASSWORD('123123') WHERE user = 'root';

修改root权限和密码，这样就可以远程访问了

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123123';
FLUSH PRIVILEGES;

启动

systemctl start mariadb