Cannot connect: Access denied for user 'username'@'localhost' (using password: YES)

Asked Mar 02 '20 at 16:20

Active Mar 02 '20 at 18:43

Viewed 19 times

I ran following sql, but still receive access denied error:

GRANT ALL PRIVILEGES TO username@'localhost' IDENTIFIED BY '12345';
FLUSH PRIVILEGES;

Code used to connect is:

<?php

  $dbhost = 'localhost';
  $dbuser = 'username';
  $pass = '12345';
  $dbname = 'dbname';

  $dsn = mysqli_connect($dbhost, $dbuser, $pass, $dbname);

edited Mar 02 '20 at 18:43

Dharman

30,962
25
85
135

asked Mar 02 '20 at 16:20

merkg

Did you run it with dbname being currently selected database? I mean ```use dbname;``` prior grant – Maxim Sagaydachny Mar 02 '20 at 16:25
Yes, I ran the grant command after 'use dbname;' – merkg Mar 02 '20 at 17:10
I can access the database using the same credentials from the windows command line and from the phpmyadmin login screen; but, php script returns error. – merkg Mar 03 '20 at 14:11
I solved my problem by adding port 3308: i.e. '$dbhost='localhost:3308';; – merkg Mar 03 '20 at 14:21

Cannot connect: Access denied for user 'username'@'localhost' (using password: YES)

0 Answers0