Connecting to the server 127.0.0.1:9000 failed:

[KrackAdams]

Originally Posted by trevius

It isn't his config file unless he is using the wrong username and/or password for his database in the config file.

Looks more like a mysql account issue. You might want to make the changes to the my.cnf file that I recommended in the Wiki for remote database access. It will allow connections other than just localhost. Make sure you restart the server or at least mysql after you make the changes. Otherwise, you might just be able to change your mysql account to make it work properly with it the way it is.

I did the my.cnf change form the wiki and now mysql server will not start

[trevius]

You restarted your PC? Mysql can be really nasty to get working again if you run into that problem where it won't start. Normally it is because your accounts are messed up, which was probably due to something you were changing around in the accounts before you stopped mysql, and the changes didn't really take effect until you stopped and tried to restart it.

You can always try setting the my.cnf back to what it was before and see what happens. If it works again, you will probably want to make additional accounts with with different host names to make sure it works once your mysql changes with the my.cnf change. You can make some with @'192.168.1.100', @'127.0.0.1', @'localhost', and one of those are bound to work lol. It all depends on what mysql thinks it is being ran from and where you are connecting from. Even though it is all still on the same PC, it can be a little tricky. If you are running multiple NIC cards, it can get even more complicated.

Mysql on Linux can definitely be a real pain sometimes. At one point, I had mine so messed up and wasted so much time trying to fix it that I wound up just formatting and reinstalling Linux from scratch again.

[trevius]

You restarted your PC? Mysql can be really nasty to get working again if you run into that problem where it won't start. Normally it is because your accounts are messed up, which was probably due to something you were changing around in the accounts before you stopped mysql, and the changes didn't really take effect until you stopped and tried to restart it.

You can always try setting the my.cnf back to what it was before and see what happens. If it works again, you will probably want to make additional accounts with with different host names to make sure it works once your mysql changes with the my.cnf change. You can make some with @'192.168.1.100', @'127.0.0.1', @'localhost', and one of those are bound to work lol. It all depends on what mysql thinks it is being ran from and where you are connecting from. Even though it is all still on the same PC, it can be a little tricky. If you are running multiple NIC cards, it can get even more complicated.

Mysql on Linux can definitely be a real pain sometimes. At one point, I had mine so messed up and wasted so much time trying to fix it that I wound up just formatting and reinstalling Linux from scratch again.

[trevius]

Ooops - double post from when the forums were down earlier I guess lol...