ERROR 1045 (28000): Access denied for user
Mysqladmin local login error ERROR 1045 (28000): the solution of Access denied for user 'root'@'localhost' is as follows:
Mysqladmin-u root password xxxx
# 1. Stop the mysql database
/ etc/init.d/mysql stop
# 2. Execute the following command
Mysqld_safe-user=mysql-skip-grant-tables-skip-networking &
# 3. Log in to the mysql database using root
Mysql-u root mysql
# 4. Update root password
Mysql > UPDATE user SET Password=PASSWORD ('mysql') where USER='root'
Mysql > grant all on *. * to root@'%' identified by "mysql"
# 5. Refresh permissions
Mysql > FLUSH PRIVILEGES
# 6. Exit mysql
Mysql > quit
# 7. Restart mysql
/ etc/init.d/mysql restart
# 8. Log back in to mysql using the root user
Mysql-uroot-p
Enter password:
The operation log is as follows:
[root@mysqldb1 ~] # / etc/init.d/mysql stop
Shutting down MySQL.. [OK]
[root@mysqldb1 ~] #
[root@mysqldb1] # mysqld_safe-- user=mysql-- skip-grant-tables-- skip-networking &
[1] 7384
[root@mysqldb1 ~] # 160606 15:23:44 mysqld_safe Logging to'/ var/lib/mysql/mysqldb1.err'.
160606 15:23:44 mysqld_safe Starting mysqld daemon with databases from / var/lib/mysql
[root@mysqldb1 ~] # mysql-u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with-A
Welcome to the MySQL monitor. Commands end with; or\ g.
Your MySQL connection id is 1
Server version: 5.6.31 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
Affiliates. Other names may be trademarks of their respective
Owners.
Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.
Mysql > UPDATE user SET Password=PASSWORD ('xxxxx') where USER='root'
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0
Mysql > grant all on *. * to root@'%' identified by "xxxxxx"
Query OK, 0 rows affected (0.00 sec)
Mysql > FLUSH PRIVILEGES
Query OK, 0 rows affected (0.00 sec)
Mysql > quit
Bye
[root@mysqldb1 ~] # / etc/init.d/mysql restart
Shutting down MySQL..160606 15:25:46 mysqld_safe mysqld from pid file / var/lib/mysql/mysqldb1.pid ended
[OK]
Starting MySQL. [OK]
[1] + Done mysqld_safe-user=mysql-skip-grant-tables-skip-networking
[root@mysqldb1] # mysql-uroot-p
Enter password:
Welcome to the MySQL monitor. Commands end with; or\ g.
Your MySQL connection id is 1
Server version: 5.6.31
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
Affiliates. Other names may be trademarks of their respective
Owners.
Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.
Mysql >
Mysql >
