Mysql 问题汇总

[root@node ~]# systemctl stop mariadb.service
[root@node ~]# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

[root@node ~]# mysql_secure_installation 依次设定密码等等初始化设定即可

root@nginx:~# mysqladmin -u root -pcentos password "redhat"  
或者在数据库中修改
MariaDB [mysql]> UPDATE user SET PASSWORD=PASSWORD(‘redhat‘) where USER=‘root‘;
MariaDB [mysql]> FLUSH PRIVILEGES;
MariaDB [mysql]> QUIT