Re: [CentOS] Request info on managing MySQL

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.