yum 安装MariaDB

yum 安装MariaDB

yum install -y mysql mysql-server mysql-devel 

yum install -y mariadb-server

安装完成后，启动服务

systemctl start mysql.service

mysqladmin -uroot password "123456"

授权远程登录

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

flush privileges;

查看修改后的用户信息

mysql>select host,user,password from user;

如果密码设置错了，用下面的方法修改；

修改密码；

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

mysql> update user set password = 'admin' where user = '%'

mysql登录修改密码

mysql> use mysql;
mysql> update user set password=password("123456") where user="root";
mysql> flush privileges;
mysql> quit