Hi guys,

someone know my root mySQL password. I need help. How do they know? Could they be one of my customer (who is allowed to have shell access)? This person change my root mysql password! I can't access to my root mysql password!

The important question is!
How to reset my root mySQL password now? PLEASE TEACH ME

I need security advise from you to prevent such incident to happen again. Thanks.

Look here:

http://www.mysql.com/doc/R/e/Resetting_permissions.html

Can someone post the latest solution instead of that url?
Or teach me step by step


How the hell this user know my root mysql password? He can reset it?

I am totally lost!

I do a "mysql -u root mysql"

I got

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

How do i go about solving this?

try
mysql -u root -p

Wrong password. That hacker change my mysql root password!

how to solve this?


ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

Read above: Mike "the newbie" (heh, not anymore eh Mike) already gave you the answer:

http://www.mysql.com/doc/R/e/Resetting_permissions.html

I know you answered that you wanted somebody to explain it to you, but frankly, it is perfectly well explained in that page. If you can't read instructions given that clearly, perhaps you ought to consider a new line of business.... Or at least hire professinal help - over here for example: http://webhostingtalk.com/forumdisplay.php?s=&forumid=33

From http://www.mysql.com/doc/R/e/Resetting_permissions.html ,


Restart mysqld with the --skip-grant-tables option
mysql say can't do "--skip-grant-tables " due to security issue.

I can't proceed further...
that's why i need latest update.

I think you better not give any of your users shell access unless you know them very well. Otherwise, it is dangerous.

Originally posted by kaz
From http://www.mysql.com/doc/R/e/Resetting_permissions.html ,


Restart mysqld with the --skip-grant-tables option
mysql say can't do "--skip-grant-tables " due to security issue.

I can't proceed further...
that's why i need latest update.

Of course you have to be root before trying this.

First login as admin, then su to root using "su -".

I do "safe_mysqld --skip-grant-tables" instead of "mysqld --skip-grant-tables" It terminate all the mysql thingy.

After i execute "safe_mysqld --skip-grant-tables" ,
i got

"Starting mysqld daemon with databases from /var/lib/mysql"




and then blank..without returning any [root/root]# or anything.
how do i escape from the blank.