Vice City: Multiplayer

Server Development => Scripting and Server Management => Topic started by: Malina on Jul 19, 2016, 09:35 PM

Title: MYSQL error Help me please
Post by: Malina on Jul 19, 2016, 09:35 PM
Hello guys
I have a problem with mysql.
(https://forum.vc-mp.org/proxy.php?request=http%3A%2F%2Fserw-host.tk%2Fb.png&hash=6474381ff02d7e1d2659fee68c3efff24097c83a)
(https://forum.vc-mp.org/proxy.php?request=http%3A%2F%2Fserw-host.tk%2Fb2.png&hash=0a47c36c775e9adb146c71c82717ad34d5c83c24)
Title: Re: MYSQL error Help me please
Post by: . on Jul 19, 2016, 09:40 PM
Title: Re: MYSQL error Help me please
Post by: Malina on Jul 19, 2016, 11:10 PM
Server is running on Debian Jessie with package mysql-server on localhost (vps).
Title: Re: MYSQL error Help me please
Post by: . on Jul 19, 2016, 11:42 PM
Try "127.0.0.1" instead of localhost and see if that does anything. I remember a weird issue a long time ago where I encountered something like that.

Also, if you modified my.conf and bound the MySQL server to your public IP address to access it remotely then use your actual VPS IP.

Also, does your user have the privilege to access that database?
Title: Re: MYSQL error Help me please
Post by: Malina on Jul 20, 2016, 10:50 AM
Ok, work thanks :)
Title: Re: MYSQL error Help me please
Post by: Thijn on Jul 20, 2016, 04:16 PM
Just for clarification: localhost will by default use a unix socket on linux when used with MySQL. Some configurations don't have this enabled by default.
So in order to force your script to connect using TCP use the IP 127.0.0.1