I deleted user root@localhost from my mysql database.......

[lpx]

Hi,

I commited a stupid mistake.

I deleted the entry root@localhost from privileges and now i cant connect.

How can i fix this?

I leave an entry there with root@%, why cant i connect?

I just did this because i couldnt connect from other machine in my network. How can i do this too?

Many thx,
_________________
Imaginando o futuro
Imagining the future

[fvant]

Google with these words: reset root password mysql

and find this link for example.

[lpx]

Hi,

Thx, but i don't need to reset the password.

I need to add privileges to acess on localhost

Basicly I want to do this:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'mypass' WITH GRANT OPTION;

In the link you gave me there is a way of doing a command but it didnt worked...

I just dont know what to do...
_________________
Imaginando o futuro
Imagining the future

[nativemad]

I think the problem is that you try to connect through the socket... You could try something like mysql -u root -p -h 127.0.0.1
If you don`t have any data in dbs, you could also remove /var/lib/mysql and do a mysql-install-db again... If you have data, and hopefully different usernames for the dbs, you could dump them and afterwards rebuid, only the mysql-db with the permissions would get lost...

[edcoates]

[lpx]

Hi,

Thx for the help guys.

I made by brute force. Backup tables by doing the following:

open /etc/mysql/my.cnf

write there
[mysqld]
skip-grant-tables

dump tables

run the configuration made after emerge of mysql to restore privileges

get the data again.

Everything is working fine except phpmyadmin.

It just dont work!! :S

It says that the password is wrong when every my other site are running just fine :S
_________________
Imaginando o futuro
Imagining the future