For a production machine I probably would have went with CentOS because the support lifecycle is longer than with Fedora.
For your mysql issues, where are you seeing that particular error? You will have to create separate mysql login for each script (blog, wiki, messageboard, etc.) that you want to run. You should never allow your scripts to connect directly to your server with the mysql root login. Also, on a new install I don't think that there is a default mysql password set, so you will need to change that as well.