Jeremy Booker wrote:
>I installed the current stable release of MySQL from RPMs. I used the client
>and server packages.
>
>After installing the server package, the RPM printed a note saying I should
>run two commands. I only got the first one, which was
># ./mysqladmin -u root --password
>I assume this gave the root user a password.
>
>I then downloaded and proceeded to compile the Perl DBI and DBD:mysql
>packages. The DBI package installed fine after I also installed the
>"MySQL-devel" RPM.
>
>However, the DBD compile/install failed when I ran 'make test'. The output
>looked like this:
>
>=============
>Mysql connect('database=test;host=','',...) failed: Access denied for user:
>'[EMAIL PROTECTED]' (Using password: NO) at t/mysql.t line 55
>not ok 1: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
>It looks as if your server is not up and running.
>This test requires a running server.
>Please make sure your server is running and retry.
>t/mysql.............FAILED tests 1-68
>Failed 68/68 tests, 0.00% okay
>Failed Test Status Wstat Total Fail Failed List of Failed
>----------------------------------------------------------------------------
>----
>t/10dsnlist.t 10 2560 9 9 100.00% 1-9
>t/20createdrop.t 10 2560 5 5 100.00% 1-5
>t/30insertfetch.t 10 2560 11 11 100.00% 1-11
>t/40bindparam.t 10 2560 28 28 100.00% 1-28
>t/40blobs.t 10 2560 11 11 100.00% 1-11
>t/40listfields.t 10 2560 16 16 100.00% 1-16
>t/40nulls.t 10 2560 11 11 100.00% 1-11
>t/40numrows.t 10 2560 25 25 100.00% 1-25
>t/50chopblanks.t 10 2560 35 35 100.00% 1-35
>t/50commit.t 255 65280 30 30 100.00% 1-30
>t/ak-dbd.t 255 65280 90 88 97.78% 1, 4-90
>t/akmisc.t 10 2560 351 351 100.00% 1-351
>t/dbdadmin.t 10 2560 21 21 100.00% 1-21
>t/insertid.t 255 65280 12 12 100.00% 1-12
>t/mysql.t 68 68 100.00% 1-68
>t/mysql2.t 255 65280 ?? ?? % ??
>1 test skipped.
>Failed 16/18 test scripts, 11.11% okay. 721/728 subtests failed, 0.96% okay.
>make: *** [test_dynamic] Error 29
>==================================================
>
>I also noticed that whenever I do anything with the mysqladmin program, I
>always have to give the '-p' option and then enter my password for anything
>to work.
>
>So, what do I need to do to get 'make test' to work? Do I need to remove the
>password somehow, or give some extra options with make? (I'm a complete
>newbie to MySQL and DB administration)
>
>Thanks in advance.
>
>Regards,
> Jeremy
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Jeremy Booker - Owner / Webmaster
>JTech Web Systems
>www.JTechWebSystems.com
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>"Therefore do not worry about tomorrow, for tomorrow will worry about
>itself. Each day has enough trouble of its own." -Mathew 5:34
>
>
>
>
EXPLANATION: The reason you are getting the error is because you are
compiling as root (user for unix/linux). The system (unless otherwise
specified) assumes same user for MySQL. The root user in MySQL has a
password which you are not supplying as you are compiling. There may be
a way to supply the password and if you know it go ahead and do it. make
test should proceed fine.
WARNING: This may not be the best way to make you installation work but it is what worked for me. I did not know this forum existed when I had the same problem.
I re-installed MySQL (client,server,devel) with the force option because I did not know how to supply the password nor reset it. The compilation of DBD worked fine; after which I created MySQL users and set passwords.
--
Peter K. Aganyo Eternal Designs Inc., +1(617)344-8023 (fax & voicemail)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
