修改MariaDB(Mysql)数据库密码

mysql数据库安装完成后，mysql默认root用户没有密码

1.修改密码

数据库安装目录：/user/local/mysql

[root@AY13052612210820701aZ bin]/user/local/mysql/bin/mysql mysql -u root

MariaDB [mysql]> UPDATE user SET Password=PASSWORD('newpwd') WHERE User='root';

MariaDB [mysql]>FLUSH PRIVILEGES;

MariaDB [mysql]>exit;

密码修改完成后重新登录

[root@AY13052612210820701aZ bin]/user/local/mysql/bin/mysql mysql -u root -p

注意：要带上p参数，需要密码登录，否则提示错误 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Enter password:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 74
Server version: 5.5.31-MariaDB-log Source distribution

Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [mysql]> 

成功登录