SA-MP Forums Archive
Problems with Mysql - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Problems with Mysql (/showthread.php?tid=574028)



Problems with Mysql - FunkySimonp - 12.05.2015

Hey Guys,
I have a big Problem with MySQL on my Server i have searched on ****** and i had done all what i can but this problem doesnt repair... If anyone is German pls Answer in German for better understanding. Here is my Log:
[22:24:47] [MySQL] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] Lade Gangzonen..
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_int called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] Zone: 0 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_int called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] Zone: 1 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_int called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] Zone: 2 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_int called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] Zone: 3 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_int called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] Zone: 4 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_int called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] Zone: 5 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_int called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called


Re: Problems with Mysql - Alex Magaсa - 12.05.2015

What version of MYSQL you use?


Re: Problems with Mysql - FunkySimonp - 12.05.2015

Hey Alex,
I dont know really, because i have used this Server last time at last year. If you think you can help me i can give you my Teamviewer ID and Pass.


Re: Problems with Mysql - Alex Magaсa - 12.05.2015

Quote:
Originally Posted by FunkySimonp
Посмотреть сообщение
Hey Alex,
I dont know really, because i have used this Server last time at last year. If you think you can help me i can give you my Teamviewer ID and Pass.
I can help you from here too that's not a problem, go to server log (server_log.txt) and check what MYSQL version you use. then reply back! or just give the server_log.txt file (upload it)!


Re: Problems with Mysql - FunkySimonp - 12.05.2015

[19:21:16] SA:MP MySQL Plugin v2.1.1 Loaded.
Is this the right Information?


Re: Problems with Mysql - Alex Magaсa - 12.05.2015

Quote:
Originally Posted by FunkySimonp
Посмотреть сообщение
[19:21:16] SA:MP MySQL Plugin v2.1.1 Loaded.
Is this the right Information?
Not sure if this plugin is out-dated but try to install this plugin and tell me solutions (if it's fixed or not)!


Re: Problems with Mysql - FunkySimonp - 12.05.2015

WHAT THE HELL ITS FIXED I LOVE YOU BRO THANKS MAN!!!!


Re: Problems with Mysql - Alex Magaсa - 12.05.2015

Quote:
Originally Posted by FunkySimonp
Посмотреть сообщение
WHAT THE HELL ITS FIXED I LOVE YOU BRO THANKS MAN!!!!
I am glad that i helped you & it's fixed!


Re: Problems with Mysql - FunkySimonp - 12.05.2015

But now i get an Run time error 19:"File or Function is not Found"


Re: Problems with Mysql - Alex Magaсa - 12.05.2015

Quote:
Originally Posted by FunkySimonp
Посмотреть сообщение
But now i get an Run time error 19:"File or Function is not Found"
Hmm,
Install and run this plugin.
Also make sure you got a script that works with the latest plugins/includes !



Note: If you are using windows plugins to linux it wont work, you need (.so - linux plugins)!