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.
root privaleges are gone
Moderator: General Moderators