I guess I forgot to mention that MySQL was running at the time. I could use
mysqladmin (as long as I used the '-p' option and entered that root password
i setup), and I could also run SELECT statements from the command line.
-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
----- Original Message -----
From: "Martin Gainty" <[EMAIL PROTECTED]>
To: "Jeremy Booker" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, July 20, 2003 1:31 AM
Subject: Re: passwords & DBI/DBD
> when you connect you connect to a running daemon
>
> try running
> mysqld beforehand
>
> -Martin
> ----- Original Message -----
> From: "Jeremy Booker" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, July 19, 2003 7:12 PM
> Subject: passwords & DBI/DBD
>
>
> > 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
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
