(Using password: NO) while installing DBD::mysql

Hello All,

On Red Hat Linux 7.2 I installed:
MySQL-3.23.58-1.i386.rpm and MySQL-client-3.23.58-1.i386.rpm for a basic ser
ver installation. This installation works OK, I did a few basic operations
and set passwords for root and anonymous accounts (all to the same password
of "qwert" for setup purposes).

I then did the following installations:

Download And, install MySQL-devel-3.23.58-1.i386.rpm.

# rpm -ivh package-1.1.0-i386.rpm

DBI is needed to use DBD-mysql.
Download And, install DBI-1.42.tar.gz

# tar xvfz DBI-1.42.tar.gz
# cd DBI-1.42

# perl Makefile.PL
# make
# make install

Install DBD-mysql-2.1017 (DBD-mysql-2.1017.tar.gz) untar and:

# perl Makefile.PL
# make
# make test

After the "make test" I saw:

t/10dsnlist.........DBI connect('test','',...) failed: Access denied for use
r: 'root@localhost' (Using password: NO) at t/10dsnlist.t line 45
Cannot 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.


I did the following to verify that the mysql server was running:

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 84 to server version: 3.23.58-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select host, user from mysql.user;
+-----------+------+
| host | user |
+-----------+------+
| localhost | |
| localhost | root |
| rdtest | |
| rdtest | root |
+-----------+------+
4 rows in set (0.00 sec)


I studied the CPAN installation instructions and tried:

# perl Makefile.PL --testpassword=qwert
I will use the following settings for compiling and testing:

cflags (mysql_config) = -I'/usr/include/mysql'
libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt
-lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lres
olv
nocatchstderr (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (Users choice) = qwert
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Using DBI 1.42 (for perl 5.006 on i386-linux) installed in /usr/lib/perl5/si
te_perl/5.6.0/i386-linux/auto/DBI
Writing Makefile for DBD::mysql


Then I did a "make" which showed:

# make
cflags (mysql_config) = -I'/usr/include/mysql'
libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt
-lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lres
olv
nocatchstderr (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.


Then I did a "make test" and saw the same error as above:

# make test
gcc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I'/usr/include/
mysql' -fno-strict-aliasing -I/usr/local/include -O2 -march=i386 -mcpu=i686
-DVERSION=\"2.1017\" -DXS_VERSION=\"2.1017\" -fPIC -I/usr/lib/perl5/5.6.
0/i386-linux/CORE dbdimp.c
/bin/sh -c true
/bin/sh -c true
gcc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I'/usr/include/
mysql' -fno-strict-aliasing -I/usr/local/include -O2 -march=i386 -mcpu=i686
-DVERSION=\"2.1017\" -DXS_VERSION=\"2.1017\" -fPIC -I/usr/lib/perl5/5.6.
0/i386-linux/CORE mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
LD_RUN_PATH="/usr/lib/mysql:/usr/lib:/lib" /usr/bin/perl myld gcc -o blib/ar
ch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/
usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns
-lresolv -lc -lnss_files -lnss_dns -lresolv
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.
0/i386-linux -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness qw(&runtests $verb
ose); $verbose=0; runtests @ARGV;' t/*.t
t/00base............
t/00base............ok 1/5
t/00base............ok 2/5
t
/00base............ok 3/5
t/00base............ok 4/5
t/00base............ok
5/5
t/00base............ok
t/10dsnlist.........DBI connect('test','',...) failed: Access denied for use
r: 'root@localhost' (Using password: NO) at t/10dsnlist.t line 45
Cannot 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.

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org