1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Can't connect to mysql server
PabloAguado
Little Clucker
**
Posts: 20
Threads: 4
Joined: Aug 2014
Reputation: 0
#1

30.09.2014, 03:45
Well i have searched for a solution on ****** but didn't find any so i decided to post it here so basically i am trying to do this with phpmyadmin but when i open the server it says Access Denied when i never placed a password inside of it

pawn Код:
#define MYSQL_HOST  "localhost"
#define MYSQL_USER  "root"
#define MYSQL_DB    "LARPDB"
#define MYSQL_PASS  ""
Log

Код:
[23:31:17] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[23:33:25] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "larpdb", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[23:33:25] [DEBUG] CMySQLHandle::Create - creating new connection..
[23:33:25] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[23:33:25] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[23:33:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:33:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:33:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:33:25] [DEBUG] mysql_errno - connection: 0
[23:33:25] [ERROR] "mysql_errno" - invalid connection handle (id: 0)
[23:33:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:33:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:33:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:33:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:33:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:34:10] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "LARPDB", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[23:34:10] [DEBUG] CMySQLHandle::Create - creating new connection..
[23:34:10] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[23:34:10] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[23:34:10] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:34:10] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:34:10] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:34:10] [DEBUG] mysql_errno - connection: 0
[23:34:10] [ERROR] "mysql_errno" - invalid connection handle (id: 0)
[23:34:10] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:34:10] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:34:10] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:34:10] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:34:10] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:34:10] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:02] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "LARPDB", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[23:42:02] [DEBUG] CMySQLHandle::Create - creating new connection..
[23:42:02] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[23:42:02] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[23:42:02] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:42:02] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:42:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:02] [DEBUG] mysql_errno - connection: 0
[23:42:02] [ERROR] "mysql_errno" - invalid connection handle (id: 0)
[23:42:02] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:42:02] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:42:02] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:42:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:22] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "LARPDB", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[23:42:22] [DEBUG] CMySQLHandle::Create - creating new connection..
[23:42:22] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[23:42:22] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[23:42:22] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:42:22] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:42:22] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:22] [DEBUG] mysql_errno - connection: 0
[23:42:22] [ERROR] "mysql_errno" - invalid connection handle (id: 0)
[23:42:22] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:42:22] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:42:22] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:42:22] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:42:22] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:22] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:22] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
Find
Reply
JordanDoughty
Big Clucker
***
Posts: 98
Threads: 18
Joined: Jun 2014
Reputation: 0
#2

30.09.2014, 10:03
Quote:
Originally Posted by PabloAguado
Посмотреть сообщение
Well i have searched for a solution on ****** but didn't find any so i decided to post it here so basically i am trying to do this with phpmyadmin but when i open the server it says Access Denied when i never placed a password inside of it

pawn Код:
#define MYSQL_HOST  "localhost"
#define MYSQL_USER  "root"
#define MYSQL_DB    "LARPDB"
#define MYSQL_PASS  ""
Log

Код:
[23:31:17] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[23:33:25] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "larpdb", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[23:33:25] [DEBUG] CMySQLHandle::Create - creating new connection..
[23:33:25] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[23:33:25] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[23:33:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:33:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:33:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:33:25] [DEBUG] mysql_errno - connection: 0
[23:33:25] [ERROR] "mysql_errno" - invalid connection handle (id: 0)
[23:33:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:33:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:33:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:33:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:33:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:34:10] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "LARPDB", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[23:34:10] [DEBUG] CMySQLHandle::Create - creating new connection..
[23:34:10] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[23:34:10] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[23:34:10] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:34:10] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:34:10] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:34:10] [DEBUG] mysql_errno - connection: 0
[23:34:10] [ERROR] "mysql_errno" - invalid connection handle (id: 0)
[23:34:10] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:34:10] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:34:10] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:34:10] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:34:10] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:34:10] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:02] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "LARPDB", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[23:42:02] [DEBUG] CMySQLHandle::Create - creating new connection..
[23:42:02] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[23:42:02] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[23:42:02] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:42:02] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:42:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:02] [DEBUG] mysql_errno - connection: 0
[23:42:02] [ERROR] "mysql_errno" - invalid connection handle (id: 0)
[23:42:02] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:42:02] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:42:02] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:42:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:22] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "LARPDB", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[23:42:22] [DEBUG] CMySQLHandle::Create - creating new connection..
[23:42:22] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[23:42:22] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[23:42:22] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:42:22] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:42:22] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:22] [DEBUG] mysql_errno - connection: 0
[23:42:22] [ERROR] "mysql_errno" - invalid connection handle (id: 0)
[23:42:22] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:42:22] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:42:22] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:42:22] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:42:22] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:22] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:42:22] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
Make sure you've allowed it to use a password in your settings for mysql.
Find
Reply
PabloAguado
Little Clucker
**
Posts: 20
Threads: 4
Joined: Aug 2014
Reputation: 0
#3

30.09.2014, 12:23
How do i do that? it's my first time using mysql
Find
Reply
PabloAguado
Little Clucker
**
Posts: 20
Threads: 4
Joined: Aug 2014
Reputation: 0
#4

30.09.2014, 21:27
Can i get some help please?
Find
Reply
PabloAguado
Little Clucker
**
Posts: 20
Threads: 4
Joined: Aug 2014
Reputation: 0
#5

01.10.2014, 13:04
Can i please have some assistance with my current problem?
Find
Reply
PabloAguado
Little Clucker
**
Posts: 20
Threads: 4
Joined: Aug 2014
Reputation: 0
#6

02.10.2014, 03:25
Bump, please help me guys i don't understand the problem i am experiencing
Find
Reply
VishvaJeet
Big Clucker
***
Posts: 127
Threads: 6
Joined: May 2013
Reputation: 0
#7

02.10.2014, 03:29
Quote:

CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
are you sure you are using correct username & password ?
Find
Reply
PabloAguado
Little Clucker
**
Posts: 20
Threads: 4
Joined: Aug 2014
Reputation: 0
#8

02.10.2014, 12:54
Yes they are default username and password for phpmyadmin i don't know why it doesn't work
Find
Reply
Ox1gEN
Huge Clucker
****
Posts: 364
Threads: 41
Joined: Aug 2014
Reputation: 0
#9

02.10.2014, 13:08
Same motherfucking problem I had, check this thread, IceCube! helped me with that plus alot of googling and shit.

thread: https://sampforum.blast.hk/showthread.php?tid=534077

scoop through that thread, I guarantee you are going to find at least one answer.
Find
Reply
PabloAguado
Little Clucker
**
Posts: 20
Threads: 4
Joined: Aug 2014
Reputation: 0
#10

04.10.2014, 21:28
I have read all what he stated and tried every way i somewhat fixed the 1045 error but it still says in the log that it fails to connect but the connection is successful only the myslq_errno states the problem

Код:
[17:23:56] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "LARPDB", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[17:23:56] [DEBUG] CMySQLHandle::Create - creating new connection..
[17:23:56] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[17:23:56] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[17:23:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[17:23:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[17:23:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[17:23:56] [DEBUG] mysql_errno - connection: 0
[17:23:56] [ERROR] "mysql_errno" - invalid connection handle (id: 0)
[17:23:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[17:23:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[17:23:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[17:23:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[17:23:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[17:23:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[17:23:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
Can you please explain how to fix this since i have followed all the steps
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help