bruce wrote a cross-post with: > i can access the mysql db/livejournal from the mysql client/command line. > mysql -ulj -host192.168.1.55 -p
what happens when you try this with the user/host you specified for the database? i.e. mysql -u lj -host localhost -p or omit the host altogether. see if you get the same error. in which case, you can probably fix it by not assuming mysql will look in your hosts file to find out if the ip address matches localhost. which invariably it doesn't, as localhost is a special name for 127.0.0.1. the real machine name is most likely associated with the ip address you provided. ed c -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of bruce Sent: 03 May 2005 19:53 To: perl-win32-users@listserv.ActiveState.com; mysql@lists.mysql.com; 'Nikolas Coukouma' Subject: perl/mysql issue... hi... i have the following issue.. i've researched it from google.. but i still can't quite figure it out... i'm using a test app with DBI->connect() and i'm getting the following response... (print/debug statements...) ---------------------------------------------------------------------- 'bd dsn = DBI:mysql:livejournal;host=192.168.1.55;port=3306;mysql_connect_timeout=2 'bd user = lj 'bd passwd = ljpass 'bd fdsn1 = DBI:mysql:livejournal;host=192.168.1.55;port=3306|lj|ljpass 'bd loops dbh = 0 'bd loops user = lj 'bd loops pass = ljpass 'bd loops dbh111 = DBI::db=HASH(0x9bf20c8) 'DBD::mysql::db selectrow_hashref failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) at /var/www/html/cgi-bin/DBI/Role.pm line 347. $dbh = DBI->connect($dsn, $user, $pass, { PrintError => 1, AutoCommit => 1,}); ----------------------------------------------------------------- i did the following to configure the mysql database/table ------------------------------------------ $ mysql -uroot -p mysql> CREATE DATABASE livejournal; mysql> GRANT ALL PRIVILEGES ON livejournal.* TO > lj@'localhost' IDENTIFIED BY 'ljpass'; ------------------------------------------- i can access the mysql db/livejournal from the mysql client/command line. mysql -ulj -host192.168.1.55 -p i'm pretty sure i've somehow made an error/left something out when configuring the mysql db for access from perl apps. i'm running the perl app from the same machine... can anyone give me pointers/shed light on what i might need to change. my gut tells me that there's some mysql table/attribute that needs to be changed, but i'm not that familiar with mysql... thanks bruce [EMAIL PROTECTED] _______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs _______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
