in reply to Canot connect to the remote mysql server through those lines
Examples of $data_source values are: dbi:DriverName:database_name dbi:DriverName:database_name@hostname:port dbi:DriverName:database=database_name;host=hostname;port=port
Try as I might, I don't see how: 'DBI:mysql:nikkou6_db:mysql3.freehostia.com' is following that specification.
Assuming (big assumption) that user 'nikkou6_db' has exactly the same permissions as 'root' from the first connect sequence, you may still also have some 'non-local' permission issues for that user within your MySQL permission table. Otherwise, if you intended to connect using 'root' (very bad idea), you also have an incorrect user component in your call.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
| A reply falls below the community's threshold of quality. You may see it by logging in. |