ummm....
i made a mistake in what i posted... a typing error... it should have been
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@'192.168.1.55' IDENTIFIED BY 'ljpass';
-------------------------------------------
which should/does allow me to access the mysql/db from the mysql command
line client...
my issue that i've tracked down to mysql, is that once i'm inside/running
mysql, i can do a 'use livejournal' which selects the livejournal database.
when i do the following 'mysql> show slave status' i get the error '(Using
password: NO)'. i can access the 'mysql' databases/tables ('use mysql') and
then run 'show slave status' with no problem... (due to my not having setup
any root passwd as of yet...
so, how/what do i need to do to resolve this issue!!
i would imagine that this is a function of access/privs but i'm not sure
what has to be set.
thoughts/comments/ideas/etc...
thanks
bruce
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
bruce
Sent: Tuesday, May 03, 2005 10:53 AM
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
