mysql issue

I have wordpress running on an old server. This time I move it to the fedora 12 guest under windows 7 host supported by virtualbox.

finally from http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html#resetting-permissions-unix

you must start mysqld  with the --user=mysql option. If you start the server as root without using --user=mysql, the server may create root-owned files in the data directory, such as log files, and these may cause permission-related problems for future server startups.

do it as follows:

sudo service mysqld stop

sudo service mysqld start --skip-grant-tables

mysqladmin -u root password 'newpassword'

then import my old database backup through phpMyAdmin and add new user priviledge, it’s golden!