[CentOS] Request info on managing MySQL
josh.dvan at yahoo.co.uk
Mon Sep 22 21:23:53 UTC 2008
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.
More information about the CentOS