[CentOS] Request info on managing MySQL

Mon Sep 22 21:23:53 UTC 2008
Josh Donovan <josh.dvan at yahoo.co.uk>

Joe Klemmer wrote:

> 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.

1. Install mysql

# yum install mysql-server mysql

2. Start MySQL Service

To start mysql server type the following command:
# chkconfig mysqld on
# /etc/init.d/mysqld start

3. Setup mysql root password

Type the following command to setup a password for root user:
# mysqladmin -u root password NEWPASSWORD
Test mysql connectivity

Type the following command to connect to MySQL server:
$ mysql -u root -p

4. Install phpmyadmin and configure it.

5. You are good to go.

Thanks,
Josh.