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 stopsudo service mysqld start --skip-grant-tablesmysqladmin -u root password 'newpassword'
then import my old database backup through phpMyAdmin and add new user priviledge, it’s golden!