[Ahmadd]

Im trying to host cnrsf script on wampsever mean localhost and im facing mysql problem (GM not connecting to mysql)

Here is how im trying to connect gm with mysql:

Code:

mysql_connect("localhost", "root", "", "cnrsf", connection, 1);

If there's anything wrong please help me

Code:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

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

[17:08:24]  ===============================

[17:08:24]       sscanf plugin loaded.     

[17:08:24]          Version:  2.8.1        

[17:08:24]    © 2012 Alex "Y_Less" Cole  

[17:08:24]  ===============================

[17:08:24]   Loaded.
[17:08:24]  Loading plugin: streamer
[17:08:24] 

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

[17:08:24]   Loaded.
[17:08:24]  Loading plugin: regex
[17:08:24] 


[17:08:24] ______________________________________


[17:08:24]  Regular Expression Plugin v0.2.1 loaded
[17:08:24] ______________________________________


[17:08:24]  By: Fro © Copyright <TBG> 2009-2011
[17:08:24] ______________________________________


[17:08:24]   Loaded.
[17:08:24]  Loaded 4 plugins.

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

[17:08:24]   Loading filterscript 'cidrban.amx'...
[17:08:24] 
######################################
[17:08:24] #				     #
[17:08:24] # Filerscript 'CIDRBAN' by someone Loaded
[17:08:24] #				     #
[17:08:24] ######################################

[17:08:24]   Loading filterscript 'xmas.amx'...
[17:08:24]   Loaded 3 filterscripts.

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

[17:08:24] Number of vehicle models: 95

[NinjaChicken]

Quote:

[MySQL] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).

Access is being denied, are you sure theirs not password set for the "root" account? Also is the database name correct

[Ahmadd]

Quote:

Originally Posted by NinjaChicken Access is being denied, are you sure theirs not password set for the "root" account? Also is the database name correct

Yea, both are correct.

[Dayrion]

What's your mysql plyugin version?

[Ahmadd]

Quote:

Originally Posted by Dayrion What's your mysql plyugin version?

MySQL Plugin v2.1.1

PS: I'm using windows 64-bit

[Dayrion]

Quote:

Originally Posted by Ahmadd MySQL Plugin v2.1.1 PS: I'm using windows 64-bit

You should use MySQL plugin by pBlueG since I dont even know by who has been made your plugin and what syntax have this function.

[Ahmadd]

Quote:

Originally Posted by Dayrion You should use MySQL plugin by pBlueG since I dont even know by who has been made your plugin and what syntax have this function.

Which version i should use?

[Dayrion]

Quote:

Originally Posted by Ahmadd Which version i should use?

The last one, obviously. You have to update your gamemode too.

[Ahmadd]

Quote:

Originally Posted by Dayrion You should use MySQL plugin by pBlueG since I dont even know by who has been made your plugin and what syntax have this function.

lol now im facing another problem after changing mysql plugin. I

Code:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[18:08:46] 
[18:08:46] Server Plugins
[18:08:46] --------------
[18:08:46]  Loading plugin: mysql
[18:08:46]   Failed.
[18:08:46]  Loading plugin: sscanf
[18:08:46] 

[18:08:46]  ===============================

[18:08:46]       sscanf plugin loaded.     

[18:08:46]          Version:  2.8.1        

[18:08:46]    © 2012 Alex "Y_Less" Cole  

[18:08:46]  ===============================

[18:08:46]   Loaded.
[18:08:46]  Loading plugin: streamer
[18:08:46] 

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

[18:08:46]   Loaded.
[18:08:46]  Loading plugin: regex
[18:08:46] 


[18:08:46] ______________________________________


[18:08:46]  Regular Expression Plugin v0.2.1 loaded
[18:08:46] ______________________________________


[18:08:46]  By: Fro © Copyright <TBG> 2009-2011
[18:08:46] ______________________________________


[18:08:46]   Loaded.
[18:08:46]  Loaded 3 plugins.

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

[18:08:46]   Loading filterscript 'cidrban.amx'...
[18:08:46] 
######################################
[18:08:46] #				     #
[18:08:46] # Filerscript 'CIDRBAN' by someone Loaded
[18:08:46] #				     #
[18:08:46] ######################################

[18:08:46]   Loading filterscript 'xmas.amx'...
[18:08:46]   Loaded 3 filterscripts.

[18:08:46] Script[gamemodes/cnr.amx]: Run time error 19: "File or function is not found"
[18:08:46] Number of vehicle models: 0

I tried R39-2, R39-5, R41-1

[Ahmadd]

Anyone else, please help?

[Ultraz]

Try typing 127.0.0.1 instead of localhost or make password for your user "root".

[Ahmadd]

Quote:

Originally Posted by Ultraz Try typing 127.0.0.1 instead of localhost or make password for your user "root".

Wroked! Thanks tho, +rep

[Zaifii]

Download XAMPP and Upload Your Mysql There and Start mysql from it then open your server and play it LOL