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.<\/p>\n
finally from http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/resetting-permissions.html#resetting-permissions-unix<\/a><\/p>\n do it as follows:<\/p>\n then import my old database backup through phpMyAdmin and add new user priviledge, it’s golden!<\/p>\n","protected":false},"excerpt":{"rendered":" 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 … Continue reading “mysql issue”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1366","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=\/wp\/v2\/posts\/1366","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1366"}],"version-history":[{"count":0,"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=\/wp\/v2\/posts\/1366\/revisions"}],"wp:attachment":[{"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1366"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1366"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
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.<\/pre>\n<\/blockquote>\n
\n
sudo service mysqld stop<\/pre>\n
sudo service mysqld start --skip-grant-tables<\/pre>\n
mysqladmin -u root password 'newpassword'<\/pre>\n<\/blockquote>\n