DMXzone Database Connector PHP Support Product Page
Solved
Error: The server requested authentication method unknown to the client
Reported 15 Nov 2013 20:26:15
1
has this problem
15 Nov 2013 20:26:15 Doug Baltes posted:
Error 2054. Works locally, not on remote server. Working with hosting company. Promoted Solutions
Replied 19 Nov 2013 17:04:21
Well my error was putting the domain name in the MySQL server field instead of localhost. I was trying to connect to the remote database instead of using the testing server. Once I set everything up using localhost on the testing server, and put the files to the remote server everything worked correctly. And, believe me, I changed PHP version, MySQL settings, etc. on the remote server (the host company HostGator were very patient with me). Hope that helps a little.
Replies
Replied 15 Nov 2013 21:12:09
15 Nov 2013 21:12:09 George Petrov replied:
Hi Doug,
Seems something is wrong with your MySql configuration. See www.rockettheme.com/forum/index.php?f=528&t=206205&rb_v=viewtopic
Greetings,
George
Seems something is wrong with your MySql configuration. See www.rockettheme.com/forum/index.php?f=528&t=206205&rb_v=viewtopic
Greetings,
George
Replied 18 Nov 2013 21:19:37
18 Nov 2013 21:19:37 Henk Harms replied:
Need some help here, I tried every combination under the sun but no joy.
I do have other db connection programs such as navicat, and webassist both connect just fine using the same parameters.
What am I doing wrong.....?
Checked PDO, is installed and working.
PDO Driver for MySQL enabled
Client API version 5.5.25
Directive Local Value Master Value
pdo_mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock
Thanks
H
I do have other db connection programs such as navicat, and webassist both connect just fine using the same parameters.
What am I doing wrong.....?
Checked PDO, is installed and working.
PDO Driver for MySQL enabled
Client API version 5.5.25
Directive Local Value Master Value
pdo_mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock
Thanks
H
Replied 19 Nov 2013 17:04:21
19 Nov 2013 17:04:21 Doug Baltes replied:
Well my error was putting the domain name in the MySQL server field instead of localhost. I was trying to connect to the remote database instead of using the testing server. Once I set everything up using localhost on the testing server, and put the files to the remote server everything worked correctly. And, believe me, I changed PHP version, MySQL settings, etc. on the remote server (the host company HostGator were very patient with me). Hope that helps a little.
Replied 20 Nov 2013 09:04:13
20 Nov 2013 09:04:13 George Petrov replied:
Good to hear that your connection problems were solved. Yes indeed it is very important to have the server name right - usually it is localhost indeed.
Depending on how the database is hosted you can get very weird error messages indeed.
Greetings,
George
Depending on how the database is hosted you can get very weird error messages indeed.
Greetings,
George