Skip to content
Advertisement

PDO cannot connect remote mysql server

server A(192.168.1.3)

mysql server(5.6.12) port 6603,socket /var/run/mysql/mysql.sock

php(5.5.0) php.ini pdo_mysql.default_socket = /var/run/mysql/mysql.sock

server B(192.168.1.4)

mysql server(5.5.11) port 3306,socket /var/run/mysql/mysql.sock

In server A is work when use

JavaScript

but cannot connect to server B when use

JavaScript

ERROR:SQLSTATE[28000] [1045] Access denied for user ‘username’@’localhost’ (using password: YES)

but work on

JavaScript

Advertisement

Answer

JavaScript

should be

JavaScript

hostname is invalid for dsn and so PDO is ignoring host and using default, which is localhost

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement