root privaleges are gone

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
newmember
Forum Contributor
Posts: 252
Joined: Fri Apr 02, 2004 12:36 pm

root privaleges are gone

Post by newmember »

HI

i'm using the phpmyadmin v2.6.2 with
mysql 4.1.11 on windows xp + sp1.
php v4.3.5 + apache v1.3.29

i was trying to setup "Linked-tables infrastructure"
(to be able to use foreign keys).
I followed the manual:
1) i logged in as root (with mysql administrator utility) and created user 'pma' and logged out.

2) in config.inc.php i set up control user: 'pma' with
password and gave names to database ('phpmyadmin') and to tables.

3) then i logged in to phpmyadmin as root , went to sql tab, loaded create_tables_mysql_4_1_2+.sql and executed it...
the query was succesfull...

i quit phpmyadmin and logged in as root to mysql admistrator... but i soon found out that root user lost all privilages....

i tried to reset password for root according to steps in mysql faq but after doing that mysql server stopped loading at all with error message:
"the process terminated unexpectedly"

i'm totaly lost...
right now i'm thinking about reinstalling mysql.
Post Reply