SA-MP Forums Archive
Help SQL - 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: Help SQL (/showthread.php?tid=572866)



Help SQL - ManGoe - 02.05.2015

Well i haven't used pass but. .. it says used..
pawn Код:
#define SQL_HOST                "localhost"
    #define SQL_USER        "root"
    #define SQL_DB          "shrey"
    #define SQL_PASS        ""
** IT IS LOCALHOST's u cant use it as owns.... **
mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
[19:02:10] [MySQL] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).


Re: Help SQL - Mencent - 02.05.2015

Hello!

Take a new user (you can create it) with a passwort.
If you need help ask here.


Re: Help SQL - ManGoe - 02.05.2015

Well i have tried it 10+ - FAILED
Permission denied even i granted all to all the users....


Re: Help SQL - sammp - 02.05.2015

Reset your MySQL root password.

// Edit

use console and type this

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('password_here');


Re: Help SQL - ManGoe - 02.05.2015

Using XAMPP.... Let me edit.


Re: Help SQL - sammp - 02.05.2015

On the xampp control panel:

Click 'Shell'

the in shell, type "mysql"

Then change the password in there using MySQL. If you don't know how to do that, you shouldn't be usng MySQL


Well, xampp tells you to type this in the shell

mysqladmin.exe -u root password secret