mysql - Printable Version

mysql - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: mysql (/showthread.php?tid=278231)

mysql - tarmo - 21.08.2011

Hello i have problem!
server log

Code:


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

SA-MP Dedicated Server
----------------------
v0.3c R2, ©2005-2011 SA-MP Team

[14:51:52] filterscripts = ""  (string)
[14:51:52] 
[14:51:52] Server Plugins
[14:51:52] --------------
[14:51:52]  Loading plugin: mysql.dll
[14:51:52]  SA:MP MySQL Plugin v2.1.1 Loaded.
[14:51:52]   Loaded.
[14:51:52]  Loading plugin: sampmysql.dll
[14:51:52] 
/************************************************/
/* SAMP-MySQL v0.1 Plugin loaded successfully ! */
/************************************************/

[14:51:52]   Loaded.
[14:51:52]  Loading plugin: sscanf.dll
[14:51:52] [MySQL] Thread running. Threadsafe: Yes.
[14:51:52] 

[14:51:52]  ===============================

[14:51:52]       sscanf plugin loaded.     

[14:51:52]    © 2009 Alex "Y_Less" Cole

[14:51:52]  ===============================

[14:51:52]   Loaded.
[14:51:52]  Loading plugin: whirlpool.dll
[14:51:52]  
[14:51:52]  ==================
[14:51:52]  
[14:51:52]   Whirlpool loaded
[14:51:52]  
[14:51:52]  ==================
[14:51:52]  
[14:51:52]   Loaded.
[14:51:52]  Loaded 4 plugins.

[14:51:52] 
[14:51:52] Filter Scripts
[14:51:52] ---------------
[14:51:52]   Loaded 0 filter scripts.

[14:51:52] [MySQL] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES). 
[14:51:52] Number of vehicle models: 0

mysql log

Code:

[Sun Aug 21 14:51:52 2011] -------------------------
[Sun Aug 21 14:51:52 2011]      Logging Started
[Sun Aug 21 14:51:52 2011] -------------------------
[Sun Aug 21 14:51:52 2011] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).

pawno

Code:

#define MySQL_host      "localhost"
#define MySQL_user      "root"
#define MySQL_pw        ""
#define MySQL_db        "test"

	Connection = mysql_init();
	mysql_connect(MySQL_host, MySQL_user, MySQL_pw, MySQL_db, Connection, 1);

Re: mysql - Hiddos - 21.08.2011

Small question: Are you trying to load two MySQL plugins at the same time?

Code:

[14:51:52]  Loading plugin: mysql.dll
[14:51:52]  SA:MP MySQL Plugin v2.1.1 Loaded.
[14:51:52]   Loaded.
[14:51:52]  Loading plugin: sampmysql.dll
[14:51:52] 
/************************************************/
/* SAMP-MySQL v0.1 Plugin loaded successfully ! */
/************************************************/

[14:51:52]   Loaded

Re: mysql - tarmo - 21.08.2011

Quote:

Originally Posted by Hiddos

Small question: Are you trying to load two MySQL plugins at the same time?

Code:

[14:51:52]  Loading plugin: mysql.dll
[14:51:52]  SA:MP MySQL Plugin v2.1.1 Loaded.
[14:51:52]   Loaded.
[14:51:52]  Loading plugin: sampmysql.dll
[14:51:52] 
/************************************************/
/* SAMP-MySQL v0.1 Plugin loaded successfully ! */
/************************************************/

[14:51:52]   Loaded

oops

now is load only 1mysql plugin

Code:

SA-MP Dedicated Server
----------------------
v0.3c R2, ©2005-2011 SA-MP Team

[15:27:05] filterscripts = ""  (string)
[15:27:05] 
[15:27:05] Server Plugins
[15:27:05] --------------
[15:27:05]  Loading plugin: mysql.dll
[15:27:05]  SA:MP MySQL Plugin v2.1.1 Loaded.
[15:27:05]   Loaded.
[15:27:05]  Loading plugin: sscanf.dll
[15:27:05] [MySQL] Thread running. Threadsafe: Yes.
[15:27:05] 

[15:27:05]  ===============================

[15:27:05]       sscanf plugin loaded.     

[15:27:05]    © 2009 Alex "Y_Less" Cole

[15:27:05]  ===============================

[15:27:05]   Loaded.
[15:27:05]  Loading plugin: whirlpool.dll
[15:27:05]  
[15:27:05]  ==================
[15:27:05]  
[15:27:05]   Whirlpool loaded
[15:27:05]  
[15:27:05]  ==================
[15:27:05]  
[15:27:05]   Loaded.
[15:27:05]  Loaded 3 plugins.

[15:27:05] 
[15:27:05] Filter Scripts
[15:27:05] ---------------
[15:27:05]   Loaded 0 filter scripts.

[15:27:05] [MySQL] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES). 
[15:27:05] Number of vehicle models: 0

Respuesta: mysql - uprp - 21.08.2011

You didin't buy MySQL, don't you need to buy one, then set it up? all i see here is you trying to connect to "your own " MySQL database, which doesnt exist, try running SAMPSERVER.EXE as admin tho

Re: mysql - tarmo - 21.08.2011

same.

Re: mysql - FireCat - 21.08.2011

Is you're host up? Like do if you're using XAMPP, is the program on?

Re: mysql - tarmo - 21.08.2011

im use wamp server

Re: mysql - tarmo - 21.08.2011

up!!!!!