mariadb记录

1、安装

yum install mariadb-server mariadb.x86_64

根据需求看要不要安装dev相关包

2、密码设置

默认安装好之后是没有设置密码的

mysql

use mysql

update user set password=password("123456")where user='root';

----123456就是设置的新密码

exit

3、远程登录

mysql -u root -p

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

FLUSH PRIVILEGES;

quit

systemctl restart mariadb.service