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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
