On Mon, November 12, 2007 10:05 am, Michael Lake wrote:
> It's trying to test if it can connect to MySQL and using the MySQL root
> account. If you create a .my.cnf file in your home directory like this:
> [client]
> user=root password=MYSQL_ROOTS_PASSWORD host=localhost
> Then it will be able to connect without a password.
> Make sure the permissions on .my.cnf are user=read only i.e.
> -r--------
> If the above is setup correctly you will be able to type 'mysql' at the
> terminal and also connect and do SQL things with no password as yourself.
thanks, Mike
OK, created .my.cf;
I can 'mysql' at the terminal, not asked for pw and get in OK,
BUT, it still fail in perl:
----one of several---
Failed 13/13 tests, 0.00% okay
t/40blobs............DBI connect('test','',...) failed: Access denied for
user 'root'@'localhost' (using password: NO) at t/40blobs.t line 64
t/40blobs............NOK 1/11Cannot connect: Access denied for user
'root'@'localhost' (using password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
t/40blobs............dubious
Failed 9/9 tests, 0.00% okay
t/utf8...............DBI connect('test','',...) failed: Access denied for
user 'root'@'localhost' (using password: NO) at t/utf8.t line 49
t/utf8...............dubious
----
# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 47266 to server version: 4.1.22-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
mysql> \s;
--------------
mysql Ver 14.7 Distrib 4.1.22, for pc-linux-gnu (i686) using readline 4.3
Connection id: 47266
Current database:
Current user: [EMAIL PROTECTED]
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 4.1.22-standard
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 17 days 21 hours 4 min 51 sec
Threads: 10 Questions: 494182 Slow queries: 21 Opens: 36464 Flush
tables: 1 Open tables: 64 Queries per second avg: 0.320
--------------
ERROR:
No query specified
--
Voytek
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
