当在命令提示符下执行该命令时，报下列错误
[root@clvn]# mysqladmin -u root password "sorry"
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
解决办法：
[root@clvn]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 110
Server version: 5.5.31-MariaDB-log MariaDB Server
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 [(none)]> set password for 'root'@'localhost' =password('');
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)
问题解决
- 39 localhost password 错误 Access39 localhost password access 39 localhost password错误 localhost password access denied localhost password密码access 39 sqlexception localhost password 39 localhost password密码 39 password access denied 39 localhost access denied localhost password方法access 39乌龙password access