I've been working on getting WordPress up and running for the better part of the day, and I'm stuck on MySQL for the moment. I've followed this little howto:
And I thought I had MySQL running fine, but apparently not. I get the error establishing a database when I type the IP of my server in.
This is my wp-config.php (Only the parts that I think are relevent to my problem)
The hostname of my server box is wordpress (I'm hosting it myself) and I've tried to change the host to localhost, but that doesn't work either.
I have a wordpress user set up for the wordpress database under MySQL, and I keep changing the password to make sure I'm not an idiot by misspelling it. I also say the allowed hosts are wordpress, and % (it says that this is all hosts)
I'm totally missing what I'm doing wrong, will someone help me before I go insane doing the same things over and over and it still doesn't work?
Edit: Ok, after playing around a bit more, I found out a few new things.
Setting DB_HOST to localhost allows me to connect to the DB server when I have no password set in the config file. It doesn't seem to matter if I have no password, or any password set for the user in the database itself.
However, it says I cannot connect to the database, wordpress. It says to try <username>_<databasename> which I tried. It didn't work, said it couldn't find the database.
When I have DB_HOST set to WordPress, I cannot connect to the MySQL server at all, for some reason.