can't log in to phpMyAdmin - deleted pma user - SOLVED

[Snecz]

Hi,
I think I've made big mistake. I deleted a user called pma in mysql.
And I can't log in to phpMy Admin as a root:
#1045 - Access denied for user 'pma'@'localhost' (using password: NO)

Is there any help?
thaks
Snecz

[martinpre]

in the phpMyAdmin folder there is a file named Documentation.html.
There you should be helped.
But I'm not very good in wrinting English

[sari42]

in your config.inc change controluser/pw to any legal user/pw
temporarily and re-install user "pma" then.

Code: Select all

$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'rootpass';

http://wiki.cihar.com/pma/controluser
http://wiki.cihar.com/pma/Quick_Install#Configuration
addition:
you can use the mysql CLI for adding a user "pma" as well.

[Snecz]

Thanks a lot!
It Helped!