Dear DBI users,
I am currently using the DBI 1.18 to connect to a MySQL that was in an the same host
than the perl scripts without trouble.
Today, I tried to connect to that server trought an external server using the DBI
module, but I receive the error below:
DBI->connect(server=www.server.com.br;database=database) failed: Access denied for
user: 'user@localhost' (Using password: YES) at ./busca_chapa.pl line 8
I usualy connect to that database externaly trought an ODBC without trouble, but it
was not working with the DBI ? I supose that the troube is the user that was changed
to user@localhost, but the user is only user.
The conection part of the script looks like:
my $db1 = DBI->connect("DBI:mysql:server=www.server.com.br;database=database",
"user", "password");
I checked the user rows from the mysql database, and it was ok for that user, allowing
to connect externaly.
Do anyone have any sugestions where I could find the trouble.
Thanks
Slepetys