On 2001.08.01 18:27 Martin McCarthy wrote:
> > After installing the MySql server, I have downloaded the following
> > packages :-
>
> Can we take it that you have no problem using mysql other than when
> trying to install DBI? Or are you installing mysql and DBI all at once
> and you're not sure if the problem is mysql, DBI, DBD, or some
> interaction between them?
>
> > During "make test" it fails with the folowing error :-
> >
> > PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib
> > -I/usr/lib/perl5/5.00503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use
> > Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
> > t/00base............ok
> > t/10dsnlist.........DBI->connect(database=test) failed: Access denied for
> > user: 'root@localhost' (Using password: NO) at t/10dsnlist.t line 45
> > Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
>
> Which looks like it is trying to access the 'test' database as user
> 'root' without a password.
>
> Do you have a user that has been granted rights to access the test
> database and doesn't need a password? If so, do the 'make test' as that
> user. In general it's best to avoid doing builds and tests as root,
> anyway...
>
> Note that the error isn't saying that your setup isn't working. Just
> that it can't test it because 'root' can't access the database without a
> password.
>
Also, you could check the mysql info pages.
info mysql
under Privilege system:: -> Access denied::
Here is a taster.
If you encounter `Access denied' errors when you try to connect to the
*MySQL* server, the list below indicates some courses of action you can
take to correct the problem:
* Did you run the `mysql_install_db' script after installing
*MySQL*, to set up the initial grant table contents? If not, do
so. *Note Default privileges::. Test the initial privileges by
executing this command:
shell> mysql -u root test
The server should let you connect without error. You should also
make sure you have a file `user.MYD' in the *MySQL* database
directory. Ordinarily, this is `PATH/var/mysql/user.MYD', where
`PATH' is the pathname to the *MySQL* installation root.
and lots more
cheers
Lawrence
--------------------------------------------------------------------
http://www.lug.org.uk http://www.linuxportal.co.uk
http://www.linuxjob.co.uk http://www.linuxshop.co.uk
--------------------------------------------------------------------
