Thanks for all the replies to this.
I have so far figured that the root user cannot connect to the database.
So I need to set a password for the root user, right?
However, the root user cannot connect to the database to dp this.
Whenever I give the command "mysqldadmin -u root password fred", I get the
following message :-
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
How do I get round this one?
Thanks,
Mark.
>===== Original Message From Colin McKinnon <[EMAIL PROTECTED]> =====
>At 16:57 01/08/01 +0100, Colin McKinnon wrote:
>>At 16:23 01/08/01 +0100, Mark Hannah wrote:
>>>Has anyone sucessfully configured the perl DBI module to work with a MySQL
>>>database?
>>
>>I had no end of troubles getting it to work trying to compile the DBI and
>>DBD stuff / install from RPMs/tarballs until I installed tham through
>>through CPAN:
>
>...and then I actually read your post. Do you have a password set for root
>when connecting from localhost? The default MySQL installations used to
>come with no password but sensibly advised users to set one ASAP. If you
>have the MySQL clients pack installed, you can test this quite easily by
>typing
> mysql
>at the command prompt (logged on as root) and seeing if it connects.
>Another useful one is:
> mysqladmin status
>
>>Access denied for user: 'root@localhost' (Using password: NO)
>
>....but _why_ do you want to program in Perl ???? ;)
>
>HTH
>
>Colin
>
>--------------------------------------------------------------------
>http://www.lug.org.uk http://www.linuxportal.co.uk
>http://www.linuxjob.co.uk http://www.linuxshop.co.uk
>--------------------------------------------------------------------
Totalise - the Users ISP
----------------------
To become a member and a shareholder
visit http://www.totalise.net
-----------------------
The Totalise Email system, probably the most flexible email system in the
world. To register for an account goto http://www.totalise.net
--------------------------------------------------------------------
http://www.lug.org.uk http://www.linuxportal.co.uk
http://www.linuxjob.co.uk http://www.linuxshop.co.uk
--------------------------------------------------------------------
