MYSQL Help
#1

Recently i've been trying to run CNRSF.. (California Cops and Robbers) and it worked fine.. Everything was perfect as i managed to learn the mysql shit and how to make a database etc.. Ok Lets get to topic

I runned a gamemode that my friend gave me and he recently was running it in his server but thing is.. I get an error, I dont even know why. I mean its an wierd error. It fails to connect to database saying that it has password even though i put password in mysql_connect..

Here's the server log:
Код:
SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[10:10:09] 
[10:10:09] Server Plugins
[10:10:09] --------------
[10:10:09]  Loading plugin: mysql
[10:10:09]  SA:MP MySQL Plugin v2.1.1 Loaded.
[10:10:09]   Loaded.
[10:10:09] [MySQL] Thread running. Threadsafe: Yes.
[10:10:09]  Loading plugin: sscanf
[10:10:09] 

[10:10:09]  ===============================

[10:10:09]       sscanf plugin loaded.     

[10:10:09]          Version:  2.8.1        

[10:10:09]    © 2012 Alex "******" Cole  

[10:10:09]  ===============================

[10:10:09]   Loaded.
[10:10:09]  Loading plugin: streamer
[10:10:09] 

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[10:10:09]   Loaded.
[10:10:09]  Loading plugin: regex
[10:10:09] 


[10:10:09] ______________________________________


[10:10:09]  Regular Expression Plugin v0.2.1 loaded
[10:10:09] ______________________________________


[10:10:09]  By: Fro © Copyright <TBG> 2009-2011
[10:10:09] ______________________________________


[10:10:09]   Loaded.
[10:10:09]  Loaded 4 plugins.

[10:10:09] 
[10:10:09] Filterscripts
[10:10:09] ---------------
[10:10:09]   Loading filterscript 'gps.amx'...
[10:10:09] 
--------------------------------------
[10:10:09] GPS System Loaded
[10:10:09] 0, -2438.551025, 741.183044, 35.107868, Supa Save
[10:10:09] 1, -1795.019897, 576.496948, 35.166793, VIP Lounge
[10:10:09] 2, -1927.602294, 261.575897, 40.718589, Vehicle Dealership
[10:10:09] 3, -2621.093017, 217.150161, 4.283658, Ammunation
[10:10:09] 4, -2632.546142, 619.860168, 14.132818, Hospital
[10:10:09] 5, -1890.214599, 813.722656, 35.422653, Job Center
[10:10:09] 6, -1777.782958, 1201.687133, 24.803468, Bomb Shop
[10:10:09] 7, -1566.389892, 1170.356201, 7.187500, Mini-Games
[10:10:09] 8, -1508.060424, 923.515014, 6.869043, San Fierro Bank
[10:10:09] GPS System Loaded...
[10:10:09] --------------------------------------

[10:10:09]   Loading filterscript 'cidrban.amx'...
[10:10:09] 
######################################
[10:10:09] #				     #
[10:10:09] # Filerscript 'CIDRBAN' by someone Loaded
[10:10:09] #				     #
[10:10:09] ######################################

[10:10:09]   Loading filterscript 'xmas.amx'...
[10:10:09]   Loaded 3 filterscripts.

[10:10:09]  
[10:10:09]  
[10:10:09]  
[10:10:09]  ======================================= 
[10:10:09]  |                                     | 
[10:10:09]  |        YSI version 3.09.0684        | 
[10:10:09]  |        By Alex "******" Cole        | 
[10:10:09]  |                                     | 
[10:10:09]  ======================================= 
[10:10:09]  
[10:10:09] [MySQL] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).
[10:10:09] Loading Vehicles
[10:10:09] (27) Loaded! Owner: 28
[10:10:09] (28) Loaded! Owner: 28
[10:10:09] (29) Loaded! Owner: 152
[10:10:09] (30) Loaded! Owner: 1
[10:10:09] (31) Loaded! Owner: 3
[10:10:10] 
-----------------------------------
[10:10:10] CNRSF (v2.17) PinEvil Loaded
[10:10:10] ------------------------------------

[10:10:10] Number of vehicle models: 95
Reply as soon as possible.. The one who will help me might get a good reward in my future community and reputation too. I meant not might but really. Just help me fix it and i will remember it. I think this is going too long
Reply
#2

Код:
public OnGameModeInit()
{
	
    profileStuff();
	connection = mysql_init(LOG_ONLY_ERRORS, 1);
	
 	mysql_connect("127.0.0.1", "root", "cnrsf", "lol", connection, 1);
This is the connection info..
My database looks fine according to this

Reply
#3

Can i get a little help here guys? I would appreciate some instant help..
Reply
#4

The parameters need to be switched, the password is first and then comes the database name in this plugin not the other way around. Would still suggest not to use outdated plugins but rather BlueG's latest version with threaded queries.

And try to follow the rules next time please, bumping your thread within 24 hours is not allowed.
Reply
#5

Thanks ! +Rep .. Sorry i will wait 24 hours now.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)