Get the App
SLTechnology News&Howtos  ›  Database  › 

ERROR 1045 (28000): Access denied for user

Shulou Source: shulou.com Published: 2022-06-01 07:02:03 11月16日 Update

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 >

Tags: Data database login command password scheme log permissions user solution update login Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Tech Info Microsoft Redmi Apple Linux