Reseting MySQL root password

This can be used to reset any user password. But it's primary used to reset root password.

Create text file (reset.txt) and enter the following line:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');

Now run this command:

mysql_safe -init-file=reset.txt

Keys: mysql, reset password

Slackware 12.0 - MySQL Error /usr/libexec/mysqld: can't find file './mysql/host.frm'

/usr/libexec/mysqld: can't find file './mysql/host.frm'
or
you can't start mysql at all.

Check if mysql have permissions on /var/lib/mysql files and folders and check if they belong to mysql/mysql user/gorup. There should be directory mysql (/var/lib/mysql/mysql).

I have problem because there is no mysql dir. So I have run mysql_install_db as root. That was wrong.
login as root and then "su mysql", login as mysql user. Then run mysql_install_db. This will install mysql system databases. Now run mysql_safe daemon (Slackware /etc/rc.d/rc.mysql start)

Thats all.

keywords: slackware mysql error, mysql can't start, permission problem, can't find file

First Post

My First Post