0

I created a user in phpMyAdmin and I only want to allow query, insert and update operations, and in my php file I am trying to connect to the MySQL database but always get the error Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'me'@'localhost' (using password: YES), even though I entered the parameter to the mysqli constructor correctly. I read that I should tick the GRANT checkbox for the user however that didn't fix it. What am I missing here? Knowing that if I try it using root and no password I can connect successfully.

  • Can you post the output of the following, censoring any data that you wouldn't want on the web? select User, Host, Password from mysql.user where User = "[THE USERNAME]" and select User, Db, Host from mysql.db where User = "[THE USERNAME]" – Charles Addis Mar 10 '17 at 21:32
  • The first query returned balsam % *E265936FB20A66C5498CCD3F2002B95CC0E4E561 and the second query returned balsam balsam %. The username and database name are the same. – hakuna matata Mar 11 '17 at 20:07
  • Please do not post the encrypted passwords.. I asked you to edit it. – Charles Addis Mar 12 '17 at 4:14
0

In a comment, I asked you to run the following queries to diagnose your issue:

select User, Host, Password
from mysql.user
where User = "[The Username]";

select User, Db, Host
from mysql.db
where User = "[The Username]"

Your answer suggests the user you created is balsam. This makes your issue very obvious -- you're attempting to connect to MySQL as user me, please use the correct username balsam.

Also, to make sure you're using the correct password you can run the following command:

select PASSWORD("[INSERT PASSWORD HERE]"), Password
from mysql.user
where user = 'balsam';

If running the previous commands yields the same value for both columns, you're using the correct password. If they aren't the same you'll need to either reset the password or delete the user grants and recreate the user account.

Make sure you're using the correct username, and not "me" as you posted in your question.

  • I ran the query for the passwords and I inserted the password for the user balsam, but the result was different passwords. – hakuna matata Mar 13 '17 at 18:03
  • After seeing the passwords are different, I ran an update statement changing the password of the user balsam to what I want it, and in my php application I am using balsam instead of me, but still I get the same error – hakuna matata Mar 13 '17 at 18:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.