SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 22/08/2012, 08:03 PM   #1
DartakousLien
High-roller
 
DartakousLien's Avatar
 
Join Date: Jan 2010
Location: Portugal
Posts: 1,149
Reputation: 87
Default MySQL ( Error ID: 1045 & Error ID: 1049 )

Code:
[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 http://forum.sa-mp.com/showthread.php?t=172475
but...don't help me...

can help me?
i wold be grateful...

thanks
__________________
Github : Procurando interessados em participar em projetos comigo.
Visite também o meu portfólio

Last edited by DartakousLien; 22/08/2012 at 11:36 PM.
DartakousLien is offline   Reply With Quote
Old 22/08/2012, 08:06 PM   #2
[EuG]ZeRoGoD
Huge Clucker
 
[EuG]ZeRoGoD's Avatar
 
Join Date: Feb 2012
Location: Scotland[UK]
Posts: 215
Reputation: 19
Default Re: MySQL ( Error ID: 1045 )

Here

Check that link that should help you

Its TPluginHandler
__________________
[EuG]ZeRoGoD is offline   Reply With Quote
Old 22/08/2012, 10:39 PM   #3
DartakousLien
High-roller
 
DartakousLien's Avatar
 
Join Date: Jan 2010
Location: Portugal
Posts: 1,149
Reputation: 87
Default Re: MySQL ( Error ID: 1045 )

what?
i don't understand... sorry!
can i help me?
__________________
Github : Procurando interessados em participar em projetos comigo.
Visite também o meu portfólio
DartakousLien is offline   Reply With Quote
Old 22/08/2012, 10:44 PM   #4
Vince
Spam Machine
 
Vince's Avatar
 
Join Date: Sep 2007
Location: Belgium
Posts: 10,092
Reputation: 2655
Default Re: MySQL ( Error ID: 1045 )

Quote:
Originally Posted by [EuG]ZeRoGoD View Post
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.
__________________
Vince is offline   Reply With Quote
Old 22/08/2012, 11:16 PM   #5
DartakousLien
High-roller
 
DartakousLien's Avatar
 
Join Date: Jan 2010
Location: Portugal
Posts: 1,149
Reputation: 87
Default Re: MySQL ( Error ID: 1045 )

@Vince thanks man, i read your response and i thought one think and...thought "i'll try" and i can
i change
pawn Code:
mysql_connect("localhost","user1","server",password,3306);
to
pawn Code:
mysql_connect("localhost","root","sampdb",password,3306);

but now, appers other problem ... see
Code:
[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
__________________
Github : Procurando interessados em participar em projetos comigo.
Visite também o meu portfólio
DartakousLien is offline   Reply With Quote
Old 23/08/2012, 10:24 AM   #6
DartakousLien
High-roller
 
DartakousLien's Avatar
 
Join Date: Jan 2010
Location: Portugal
Posts: 1,149
Reputation: 87
Default Re: MySQL ( Error ID: 1045 )

Sorry for double post, but, i need help!
__________________
Github : Procurando interessados em participar em projetos comigo.
Visite também o meu portfólio
DartakousLien is offline   Reply With Quote
Old 23/08/2012, 05:29 PM   #7
DartakousLien
High-roller
 
DartakousLien's Avatar
 
Join Date: Jan 2010
Location: Portugal
Posts: 1,149
Reputation: 87
Default Re: MySQL ( Error ID: 1045 )

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
Code:
[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.
__________________
Github : Procurando interessados em participar em projetos comigo.
Visite também o meu portfólio
DartakousLien is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql Error using the Mysql 2.1.1 Plugin yvoms Scripting Help 2 07/06/2013 10:48 PM
MySQL Error (In the MySQL log) Unknown123 Help Archive 10 28/02/2011 10:24 PM
one error (1045) : error 021: symbol already defined: "strtok" |CrippinBloodDrippin| Help Archive 12 26/12/2009 04:47 PM


All times are GMT. The time now is 04:07 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.