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

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

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

Postby Snecz » 14. December 2006 20:03

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
Last edited by Snecz on 15. December 2006 23:15, edited 1 time in total.
Snecz
 
Posts: 9
Joined: 09. December 2006 14:46

Postby martinpre » 14. December 2006 21:33

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 ;)
martinpre
 
Posts: 405
Joined: 22. May 2006 16:14
Location: Nähe Tulln / Österreich

Postby sari42 » 14. December 2006 21:37

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.
sari42
 
Posts: 800
Joined: 27. November 2005 18:28

Postby Snecz » 15. December 2006 23:14

Thanks a lot!
It Helped!
Snecz
 
Posts: 9
Joined: 09. December 2006 14:46


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 3 guests