SA-MP Forums Archive
Mysql Test - 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 Test (/showthread.php?tid=399903)



Mysql Test - Jermi - 16.12.2012

Hey guys

First I have fixed my Mysql But How do i run a mysql on windows?? Like The user...DB and Pass...etc

it seems like hard cuz it gives
Quote:

[Sat Dec 15 22:18:30 2012] -------------------------
[Sat Dec 15 22:18:30 2012] Logging Started
[Sat Dec 15 22:18:30 2012] -------------------------
[Sat Dec 15 22:18:31 2012] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).
[Sat Dec 15 22:18:31 2012] Error (0): Function: mysql_ping called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[Sat Dec 15 22:18:31 2012] Error (0): Function: mysql_ping called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[Sat Dec 15 22:18:31 2012] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[Sat Dec 15 22:18:31 2012] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[Sat Dec 15 22:18:31 2012] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[Sat Dec 15 22:18:31 2012] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
hat on server.log [WINDOWS]

soo?


Re: Mysql Test - Djole1337 - 16.12.2012

You've failed to connect.

Try using WampServer.


Re: Mysql Test - RajatPawar - 16.12.2012

Quote:
Originally Posted by Jermi
View Post
How do i run a mysql on windows?? Like The user...DB and Pass...etc
Run a DB on windows? If you want to create a Database on your localhost, use wampserver.


Re: Mysql Test - Jermi - 16.12.2012

Oh...Thanks i use it already


Re: Mysql Test - RajatPawar - 16.12.2012

Do you have a password for your database? Are you entering it right? What color is the icon of wampserver? Green/orange/red?


Re: Mysql Test - iggy1 - 16.12.2012

When testing on wamp server your db details should look like this. (if you haven't edited anything like passwords)

pawn Code:
#define SQL_HOST "localhost"
#define SQL_USER "root"
#define SQL_PASS ""
#define SQL_DB   "dbname"



Re: Mysql Test - Jermi - 16.12.2012

@#Rajat it is Orange but i can't connect to PHPMyadmin to make DB :!!


Re: Mysql Test - ikey07 - 16.12.2012

Quote:
Originally Posted by Jermi
View Post
@#Rajat it is Orange but i can't connect to PHPMyadmin to make DB :!!
Quit skype and teamviewer fully, as they both use 80 port and doesnt let wamp to fully initalize, had same issue


Re: Mysql Test - Jermi - 16.12.2012

@Ikey07 Yeah...Thanks bro ...Now going to try to create Database and also it is Green now


Re: Mysql Test - Jermi - 16.12.2012

Guys i wanna help here...I created one but still not working or loading the script i will rep who will help me