bruce wrote:
The problem is in your code, not your db.
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.
MySQL just told you that you connected as [EMAIL PROTECTED] with *no password*. Presumably, this means $pass has no value on the following line.
$dbh = DBI->connect($dsn, $user, $pass, {
PrintError => 1,
AutoCommit => 1,});
-----------------------------------------------------------------
From your debug output, perhaps you set $passwd but used $pass?
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';
-------------------------------------------
[EMAIL PROTECTED] can connect and use db livejournal.
i can access the mysql db/livejournal from the mysql client/command line. mysql -ulj -host192.168.1.55 -p
but here you connect as [EMAIL PROTECTED] localhost is special to mysql. That is, localhost and 192.168.1.55 are not the same thing. See the manual for details <http://dev.mysql.com/doc/mysql/en/connection-access.html>.
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...
Then use localhost, not 192.168.1.55, in your connection string.
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]
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
