Voytek Eymont wrote:
I'm trying to install some MySQL support modules into perl,
it fails as the install procedure tries to log to MySQL with no password,
perhaps for other reasons as well ?
anyhow, should I just 'force install DBD::mysql' or is there a better way?
MySQL docs seem to recommend 'force' option
-----
t/prepare_noerror....DBI connect('test','',...) failed: Access denied for
user 'root'@'localhost' (using password: NO) at t/prepare_noerror.t line
22
Can't call method "prepare" on an undefined value at t/prepare_noerror.t li
----
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.
Mike
--
Michael Lake
Computational Research Support Unit
Science Faculty, UTS
Ph: 9514 2238
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
