skip-grant-tables + phpmyadmin

Hi,
i've a very huge problem :S
so i've changed the root passwor in phpMyAdmin, after clicking
"execute" i receive an error in phpMyadmin:

#1045 - Access denied for user'root'@'localhost

i've read a lot of thread and at the end i'd followed this steps:
1. stop mysqld : /etc/init.d/mysqld stop
2. start mysqld_Safe : mysqld_safe --skip-grant-tables &

at this point i'm able to view all my db through phpMyAdmin, but i
can't at all change privilege or create user, i can work on the
database see them and see all the user that i'd created before.

3.mysql
3.1 show databases; -> i can see all my databases (20 databases)
4. use mysql
5. update root password
6. flush privileges;
7.exit;
8.mysql restart

and now i can only see ONLY 2 databases: information_Schema; test and
it seems that exists only one user "root"

do you know some tips to restore mysql? have i to reinstall
everything?

Thanks in advance

Cap

cappa wrote:

> do you know some tips to restore mysql? have i to reinstall
> everything?

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

scroll down to the unix section.


--

//Aho