Mysql / Centos - Printable Version

Mysql / Centos - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Mysql / Centos (/showthread.php?tid=410854)

Mysql / Centos - acade - 27.01.2013

Hello,

I am getting this error when I go to start my server up,

[20:39:47] [MySQL] Connecting to '109.169.23.185'...
[20:39:47] [MySQL] Connection to '109.169.23.185' failed!

[20:48:14] [MySQL] Connecting to 'localhost'...
[20:48:14] [MySQL] Connection to 'localhost' failed!

This to me leads me to believe it's a problem with mysql as I have just installed it all. I have moved all my files from volt onto a private VPS.

Re: Mysql / Centos - ColorHost-Kevin - 27.01.2013

Did you contact your provider about MYSQL? They should be able to guide you through setting it up with them.

Re: Mysql / Centos - Guest9328472398472 - 27.01.2013

Are you connecting to a server that is not yours?

Regarding your localhost connection, is your MySQL Server running, is your user, database, and password created. Here's something that can help you out with setting MySQL up for a server.

https://sampforum.blast.hk/showthread.php?tid=327272

Re: Mysql / Centos - acade - 27.01.2013

Quote:

Originally Posted by ColorHost-Kevin

Did you contact your provider about MYSQL? They should be able to guide you through setting it up with them.

I've just contacted them now, though I installed mysql and phpmyadmin through Yum

Quote:

Originally Posted by Brandon Javorsky

Are you connecting to a server that is not yours?

Regarding your localhost connection, is your MySQL Server running, is your user, database, and password created. Here's something that can help you out with setting MySQL up for a server.

https://sampforum.blast.hk/showthread.php?tid=327272

All my passwords, users and databases have been created

Re: Mysql / Centos - 3ventic - 28.01.2013

MySQL is quite specific about permissions. Assuming the MySQL is on the VPS as well, try running

mysql -u [user] -h [IP of the server or localhost if on same VPS] -p

enter the password when it asks for it and see how it replies. If it lets you in, there's a problem with your script/plugin. If it doesn't let you in, you should see something like Access Denied for user 'username'@'what-you-entered-in-h-parameter' (Using password: YES).
If that's the case, login using root and change the host stored for the user and flush privileges. If that doesn't work, go search more on Stack Overflow.