SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 31/07/2017, 11:03 AM   #11
aoky
Huge Clucker
 
aoky's Avatar
 
Join Date: Oct 2016
Location: Ireland
Posts: 493
Reputation: 136
Default Re: Access denied MYSQL ?

Just integrate it into your script as Logic said, filterscripts aren't a good idea in my honest opinion.
__________________
owner/developer @ koky's deathmatch
aoky is offline   Reply With Quote
Old 31/07/2017, 11:04 AM   #12
Crystallize
Banned
 
Join Date: Aug 2013
Posts: 1,498
Reputation: 314
Default Re: Access denied MYSQL ?

Quote:
Originally Posted by XeonMaster View Post
no, he is using R40 based on mysql_connect that he used


so you should put MySQL: tag on the variable @Crystallize

EDIT: i did saw the Database in last of params on mysql_connect if im not mistaken

What do you mean on the variable so what do you think I should use on mysql connect? I still dont get it
And I dont want to integrate it , it will create unnecessary errors and will be time wasting.
Crystallize is offline   Reply With Quote
Old 31/07/2017, 11:07 AM   #13
Xeon™
Banned
 
Join Date: Jul 2017
Location: Earth
Posts: 457
Reputation: 96
Default Re: Access denied MYSQL ?

PHP Code:
// var 

new MySQL:mysql 1;

mysql mysql_connect(....) 
for both gm and fs

set gm = 0
and fs = 1
Xeon™ is offline   Reply With Quote
Old 31/07/2017, 11:07 AM   #14
Crystallize
Banned
 
Join Date: Aug 2013
Posts: 1,498
Reputation: 314
Default Re: Access denied MYSQL ?

I think I fixed it.
jalt recommended me to load the fs ongamemodeinit and it works fine.
Code:
SendRconCommand("loadfs bllblb");
thanks everyone tho.
Crystallize is offline   Reply With Quote
Old 31/07/2017, 11:08 AM   #15
skuller12
Big Clucker
 
Join Date: Feb 2015
Location: Galati, Romania
Posts: 101
Reputation: 0
Default Re: Access denied MYSQL ?

@Crystallize show me your mysql_password
skuller12 is offline   Reply With Quote
Old 31/07/2017, 11:12 AM   #16
Xeon™
Banned
 
Join Date: Jul 2017
Location: Earth
Posts: 457
Reputation: 96
Default Re: Access denied MYSQL ?

Quote:
Originally Posted by Crystallize View Post
I think I fixed it.
jalt recommended me to load the fs ongamemodeinit and it works fine.
Code:
SendRconCommand("loadfs bllblb");
thanks everyone tho.
that will not work fine.

its works because of gamemode take first connection. when gamemode connect, the filterscript will stay on connection pending (because of same handle) and if you use filterscript on same handle of gamemode there will be some errors around, and this can be cutting connection bettwen gamemode and server.
Xeon™ is offline   Reply With Quote
Old 31/07/2017, 11:21 AM   #17
Crystallize
Banned
 
Join Date: Aug 2013
Posts: 1,498
Reputation: 314
Default Re: Access denied MYSQL ?

Quote:
Originally Posted by skuller12 View Post
@Crystallize show me your mysql_password
mysql_password "skullergaming" enjoy.

xeonmaster I still don't get it what do i have to do
can you write me a basic fs on how i tshould be? like new mysql; etc?
Crystallize is offline   Reply With Quote
Old 31/07/2017, 11:21 AM   #18
jlalt
Banned
 
Join Date: Oct 2014
Location: Iran
Posts: 1,266
Reputation: 366
Default Re: Access denied MYSQL ?

Quote:
Originally Posted by XeonMaster View Post
that will not work fine.

its works because of gamemode take first connection. when gamemode connect, the filterscript will stay on connection pending (because of same handle) and if you use filterscript on same handle of gamemode there will be some errors around, and this can be cutting connection bettwen gamemode and server.
http://wiki.sa-mp.com/wiki/MySQL#mysql_connect

Quote:
Return Values:
Connection handle or MYSQL_INVALID_HANDLE on error.
mysql_connect function returns handle id, not you. so you can not assign it manually!
jlalt is offline   Reply With Quote
Old 31/07/2017, 11:23 AM   #19
Xeon™
Banned
 
Join Date: Jul 2017
Location: Earth
Posts: 457
Reputation: 96
Default Re: Access denied MYSQL ?

Quote:
Originally Posted by jlalt View Post
http://wiki.sa-mp.com/wiki/MySQL#mysql_connect



mysql_connect function returns handle id, not you. so you can not assign it manually!
oh, sorry! i did mixed it up with SQLite and the old mysql plugin. appologize's
Xeon™ is offline   Reply With Quote
Old 31/07/2017, 03:29 PM   #20
Vince
Spam Machine
 
Vince's Avatar
 
Join Date: Sep 2007
Location: Belgium
Posts: 10,067
Reputation: 2660
Default Re: Access denied MYSQL ?

The fact that you've censored the hostname makes me think you're connecting through the WAN IP. If the MySQL server is on the same local network then you should use the internal hostname or IP address. Going through the WAN IP is like knocking on your own front door every time you want to get something out of your fridge.
__________________
Vince is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL - Access denied Gogorakis Server Support 16 23/08/2014 06:11 PM
Mysql Access Denied Why? danish007 Scripting Help 3 30/06/2014 03:13 AM
MySQL can't connect, beacuse of access denied. TheDeath Scripting Help 3 09/12/2013 06:23 PM
MYSQL Access Denied with right user and pass Mattakil Server Support 12 04/12/2013 07:50 PM
MySQL permission issues/access denied V1ceC1ty Scripting Help 7 19/12/2012 02:09 AM


All times are GMT. The time now is 03:28 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.