[CentOS] Re: Request info on managing MySQL

Mon Sep 22 15:08:38 UTC 2008
Scott Silva <ssilva at sgvwater.com>

on 9-20-2008 6:40 PM Joe Klemmer spake the following:
> Good day/night/whatever fellow techies,
> 	I've come to a small problem managing mysql on CentOS 4.7 box[1].  When
> I have done things on mysql on my desktop systems it was always just for
> personal use so I would be lazy and put everything under the "test" db
> so I didn't have to deal with all that security.  But I find that I need
> to put some db's on the "production" box and could use a little
> assistance.
> 	I can manage with the bulk of the work but since mysql is all
> pre-configured on RH based systems I don't know where to find the root
> password or any other tidbits needed to get started.  Access to the
> grant and other admin db's and tables is all I believe I need.  Looking
> through the docs on centos.org didn't reveal anything to me (or I just
> missed it).

I do believe that a default install of Mysql leaves no root password, which 
you *should* add as soon as you start the service.

> 	So the end result of this message is simply can someone point me to the
> howto use mysql on CentOS/RHEL info.  I just need to be able to start
> adding db's and such.  Once there I'm good to go.
> Thank you in advance,
> Joe
> [1] I know, I should upgrade but, as I mentioned, I'm a real lazy guy.

4.7 just came out. So what are you lazy about upgrading?

MailScanner is like deodorant...
You hope everybody uses it, and
you notice quickly if they don't!!!!

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 250 bytes
Desc: OpenPGP digital signature
URL: <http://lists.centos.org/pipermail/centos/attachments/20080922/2a89ad6a/attachment-0005.sig>