Helllo Sir....
I accidentally dropped 'root' from the user table in the mysql database. As a
result I can't do much at all. (I have no other privileged user).
Plz.. help me as soon as possible....
Thanks & Regards,Prashik Pawar9664384939
Sadhiq Wrote -
Run the following commands:
$mysqld_safe --skip-grant-tables &
then issue
$mysql
then issue
GRANT CREATE, DROP ON *.* TO r...@localhost IDENTIFIED BY 'newpass' WITH GRANT
OPTION;
GRANT ALL PRIVILEGES ON *.* TO r...@localhost IDENTIFIED BY 'newpass' WITH
GRANT OPTION;
exit
service mysql restart
http://www.linuxquestions.org/questions/linux-software-2/lost-root-access-in-mysql-486785/
http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html
B.Sadhiq
[Non-text portions of this message have been removed]
