Mysql – #1045 – Access denied for user ‘root’@’localhost’ (using password: YES) MAMP MySQL access denied

mampMySQLmysql-error-1045phpmyadminWordpress

I'm trying to copy a live WordPress site to my local server. I went to import the database from the live site through MAMP, and I received an error message when trying to connect to phpMyAdmin:

#1045 – Access denied for user 'root'@'localhost' (using password: YES)

I have a couple local WP installations running already, and I'm able to access them through the localhost:8888/sitename path just fine.

I haven't changed any passwords or messed around with any configurations in phpMyAdmin. In fact, it was all working fine just yesterday. I had to re-boot my computer because it froze on me this morning, and that's when the issues began.

I even went into the config.inc.php file in Applications/MAMP/phpMyAdmin, and the usernames and passwords match what I had originally. (It definitely wasn't 'YES')

I'm stumped at this point. Could anyone help?

Best Answer

Can you try resetting the MySQL server password using this guide. Then put the new password in the PHPMyAdmin config?

using password: YES Means that you attempted to login using a password, not that the password used is 'YES' Its referring to the different options for logins like certificates etc.

Related Solutions

Mysql – How to get a list of user accounts using the command line in MySQL

Use this query:

SELECT User FROM mysql.user;

Which will output a table like this:

+-------+
| User  |
+-------+
| root  |
+-------+
| user2 |
+-------+

As Matthew Scharley points out in the comments on this answer, you can group by the User column if you'd only like to see unique usernames.

Mysql – Access denied for user ‘root@localhost’ (using password:NO)

for this kind of error; you just have to set new password to the root user as an admin. follow the steps as follows:

[root ~]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:NO)

Stop the service/daemon of mysql running

[root ~]# service mysql stop   
mysql stop/waiting

Start mysql without any privileges using the following option; This option is used to boot up and do not use the privilege system of MySQL.
```
[root ~]# mysqld_safe --skip-grant-tables &
```

At this moment, the terminal will seem to halt. Let that be, and use new terminal for next steps.

enter the mysql command prompt
```
[root ~]# mysql -u root
mysql> 
```

Fix the permission setting of the root user ;

mysql> use mysql;
Database changed
mysql> select * from  user;
Empty set (0.00 sec)
mysql> truncate table user;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> grant all privileges on *.* to root@localhost identified by 'YourNewPassword' with grant option;
Query OK, 0 rows affected (0.01 sec)

*if you don`t want any password or rather an empty password

    mysql> grant all privileges on *.* to root@localhost identified by '' with grant option;
    Query OK, 0 rows affected (0.01 sec)*
    mysql> flush privileges;
    Query OK, 0 rows affected (0.00 sec)

Confirm the results:

    mysql> select host, user from user;
+-----------+------+
| host      | user |
+-----------+------+
| localhost | root |
+-----------+------+
1 row in set (0.00 sec)

Exit the shell and restart mysql in normal mode.

mysql> quit;
[root ~]# kill -KILL [PID of mysqld_safe]
[root ~]# kill -KILL [PID of mysqld]
[root ~]# service mysql start

Now you can successfully login as root user with the password you set
```
 [root ~]# mysql -u root -pYourNewPassword 
 mysql> 
```

Best Answer

Related Solutions

Mysql – How to get a list of user accounts using the command line in MySQL

Mysql – Access denied for user ‘root@localhost’ (using password:NO)

Related Topic