Impossible to connect to mysql server

[dbarasuk]

Hi,

I have a serious problem to connect to mysql. I previously created mysql tables using phpMyAdmin, then swuitched back to the command line option of mysql to manage my tables; from there, it become impossible to see the browser based PhpMyAdmin page. I changed the password (which was wrong in the phpmyadmin config) then i could see the page again (I mean what you see when you type [localhost...] in the address bar).

But when I tried to login using my offline webpages of the site i am working on, i got a message : "Access denied for user '$user'@'localhost' (using password: YES)"

The paradox is the fact that the password and username i use to login are exactly the same as the ones you can see when you select the table from which I am trying to log into.

How can I solve this headache, please?

Regards,
dbarasuk.

[venelin13]

You said you've changed the password via the command line interface. Well, did you changed it at the phpMyAdmin config file, too? You will find this file at the phpMyAdmin directory and it is named "config.inc.php".

[dbarasuk]

Yes i changed the password at phpMyAdmin too. before I did, i could'nt even see the first page you see when you type [localhost...] in the address bar. The only problem is the fact i can't login any more. This is strange to me.

what's next to get overcome?

many thanks

[eelixduppy]

The only thing I can think of is that your permissions are screwed up somehow. Maybe it's a problem with the password not being in the old format [dev.mysql.com]? Not quite sure.

[dbarasuk]

it's just a mistery
but i think everything is about the privileges

I have granted all the privileges to the user connecting to mysql but with no result yet.

regards,

[phranque]

did you reload the grant tables?

mysqladmin -uusername -ppassword reload