SA-MP Forums Archive
mysql host prob website - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql host prob website (/showthread.php?tid=657937)



mysql host prob website - Dangjai - 18.08.2018

Hello i've created a website tops list and gangs list and etc.
When I connect it with VPS it's says failed to connect to database.
I got a free db4free.net db and tested it and worked .
What the reason? the webpage script or what?
and how to fix that.
Thank you.


Re: mysql host prob website - Dangjai - 19.08.2018

< Bump >


Re: mysql host prob website - Ciandlah - 19.08.2018

Have any screenshots of the error, or code line?. you can PM me for help


Re: mysql host prob website - Satish1 - 19.08.2018

It says Failed to connect to DB.


Re: mysql host prob website - Seifspeed - 19.08.2018

Try adding your IP to remote connections in your control panel.


Re: mysql host prob website - Satish1 - 20.08.2018

What you mean Seif?


Re: mysql host prob website - KinderClans - 20.08.2018

Probably the database user you're trying to connect with doesn't have permissions. Go to phpmyadmin, select your created database for the server, go to "Privileges" and assign global permissions to the user you're using. Or even better, create a new one with permissions just on the server database.




Re: mysql host prob website - Satish1 - 22.08.2018

How to give them the privileges?


Re: mysql host prob website - Satish1 - 22.08.2018

Yes I saw them It's already granted tho


Re: mysql host prob website - Satish1 - 22.08.2018

The problem is that it says FAILED to Connect TO SEF Database! https://imgur.com/a/UVunlWx
Am using A VPS But I think I need to enable something? And I have tried it on a free db it did work. Can someone help me here?


Re: mysql host prob website - KinderClans - 22.08.2018

Quote:
Originally Posted by Satish1
Посмотреть сообщение
The problem is that it says FAILED to Connect TO SEF Database! https://imgur.com/a/UVunlWx
Am using A VPS But I think I need to enable something? And I have tried it on a free db it did work. Can someone help me here?
If you're using a VPS in "HOST"* you should put your VPS ip, not localhost.

*I'm referring to the mysql configuration of your gamemode.


Re: mysql host prob website - Satish1 - 22.08.2018

I did still not working