MYSQL issue - 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)
+--- Thread: MYSQL issue (
/showthread.php?tid=571692)
MYSQL issue -
lulo356 - 21.04.2015
pawn Код:
[14:26:53] Error: | Query: Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[14:26:53] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[14:26:53] Error: | Query: Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[14:26:53] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[14:26:53] Error: | Query: Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
i get many of this errors but i don't understand whats wrong.
pawn Код:
#define SQL_HOST "127.0.0.1" //5.175.193.248
#define SQL_USER "root"
#define SQL_DB "roleplay"
#define SQL_PASS ""
And no there is no PASSWORD on my MYSQL database
Re: MYSQL issue -
BleverCastard - 21.04.2015
"using password: YES" Are you sure? It wouldn't display this otherwise.
Re: MYSQL issue -
lulo356 - 21.04.2015
Quote:
Originally Posted by BleverCastard
"using password: YES" Are you sure? It wouldn't display this otherwise.
|
Im sure about it
Re: MYSQL issue -
Sithis - 21.04.2015
Show us the line where you connect.
Re: MYSQL issue -
Fel486 - 21.04.2015
If you're using WAMP, here we go.
First go to this directory (4.x.xx = phpmyadmin version)
PHP код:
C:\wamp\apps\phpmyadmin4.x.xx
open the file:
and leave this line like this:
PHP код:
$cfg['Servers'][$i]['password'] = '';
and also:
PHP код:
$cfg['Servers'][$i]['AllowNoPassword'] = true;
Re: MYSQL issue -
lulo356 - 21.04.2015
Quote:
Originally Posted by Fel486
If you're using WAMP, here we go.
First go to this directory (4.x.xx = phpmyadmin version)
PHP код:
C:\wamp\apps\phpmyadmin4.x.xx
open the file:
and leave this line like this:
PHP код:
$cfg['Servers'][$i]['password'] = '';
and also:
PHP код:
$cfg['Servers'][$i]['AllowNoPassword'] = true;
|
I have that, but still giving me the erros that there is an password
Re: MYSQL issue -
lulo356 - 22.04.2015
bump
Re: MYSQL issue -
Azula - 22.04.2015
Quote:
Show us the line where you connect.
|
....
Re: MYSQL issue -
Misiur - 22.04.2015
@Fel486: Woah man, you've got a lot of reading to do if you don't understand difference between phpmyadmin and mysql server.
@OP: You might've probably used wrong order of arguments on connect, and you are using DB name instead of password. Show us that connect line.