MySQL ( Error ID: 1045 ) - Printable Version

MySQL ( Error ID: 1045 ) - 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 ( Error ID: 1045 ) (/showthread.php?tid=371205)

MySQL ( Error ID: 1045 & Error ID: 1049 ) - DartakousLien - 22.08.2012

Код:

[19:42:00] >> mysql_connect(localhost, user1, server, ******) on port 3306
[19:42:00] CMySQLHandler::CMySQLHandler() - constructor called.
[19:42:00] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "server" | Username: "user1"
[19:42:00] CMySQLHandler::Connect() - Access denied for user 'user1'@'localhost' (using password: YES) (Error ID: 1045)

( test realized in my computer )

well, i'm a begginner in MySQL and i have a problem. I start use MySQL a few days ago, and now i test. but, donґt connect to database. first i don't use xampp server, but i see some topic and after i use a xampp, but appers this message in "mysql_log". i don't know this... i use a MySQL plugin R7

and i see this topic https://sampforum.blast.hk/showthread.php?tid=172475
but...don't help me...

can help me?
i wold be grateful...

thanks

Re: MySQL ( Error ID: 1045 ) - [EuG]ZeRoGoD - 22.08.2012

Here

Check that link that should help you

Its TPluginHandler

Re: MySQL ( Error ID: 1045 ) - DartakousLien - 22.08.2012

what?
i don't understand... sorry!
can i help me?

Re: MySQL ( Error ID: 1045 ) - Vince - 22.08.2012

Quote:

Originally Posted by [EuG]ZeRoGoD

Here

Check that link that should help you

Its TPluginHandler

What does that have to do with this topic? What is that thing anyway?

@OP: Authentication credentials are incorrect. If you didn't change the security settings, then go in phpMyAdmin and log in with username root and blank password. Or whatever the default password is. Check the documentation for default passwords. Create user in phpMyAdmin.

Re: MySQL ( Error ID: 1045 ) - DartakousLien - 22.08.2012

@Vince thanks man, i read your response and i thought one think and...thought "i'll try" and i can

i change

pawn Код:

mysql_connect("localhost","user1","server",password,3306);

pawn Код:

mysql_connect("localhost","root","sampdb",password,3306);

but now, appers other problem ... see

Код:

[00:09:13] >> mysql_connect(localhost, root, sampdb, ******) on port 3306
[00:09:13] CMySQLHandler::CMySQLHandler() - constructor called.
[00:09:13] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sampdb" | Username: "root"
[00:09:13] CMySQLHandler::Connect() - Unknown database 'sampdb' (Error ID: 1049)

can help me? thanks

Re: MySQL ( Error ID: 1045 ) - DartakousLien - 23.08.2012

Sorry for double post, but, i need help!

Re: MySQL ( Error ID: 1045 ) - DartakousLien - 23.08.2012

well, I'm not lowering my head and so I decided to go looking until I found the solution, now everything is solved ...
if someone wants to know more I'll let the links below

http://www.fromdual.ch/mysql-error-c...ages-1000-1049

http://www.phpeasystep.com/mysql/2.html

result

Код:

[18:41:38] >> mysql_connect(localhost, root, sampdb, ******) on port 3306
[18:41:38] CMySQLHandler::CMySQLHandler() - constructor called.
[18:41:38] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sampdb" | Username: "root"
[18:41:38] CMySQLHandler::Connect() - Connection was successful.
[18:41:38] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.