How to install MySQL database in CentOS 6.X

How to access MySQL database from GUI using PhpMyAdmin
This tutorial will guide you to install MySQL database package in CentOS 6.X server environment.

Install MySQL server package
# yum install mysql-server mysql

Check installed MySQL package
# rpm -qa mysql*
mysql-libs-5.1.73-8.el6_8.x86_64
mysql-server-5.1.73-8.el6_8.x86_64
mysql-5.1.73-8.el6_8.x86_64

Start MySQL package
# service mysqld start

Auto start MySQL service on reboot time
# chkconfig mysqld on


Rest MySQL root passwrod
Syntax:
/usr/bin/mysqladmin -u root password 'new-password'
Example,
#/usr/bin/mysqladmin -u root password 'linux@321'

login in MySQL
# mysql -u root -p
Enter password: prompt_password_here
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Exit from MySQL
mysql> quit
Bye
Share on Google Plus

About Penguin Technology

I am a passionate cloud and DevOps professional specializing in Linux and open-source solutions. Through this blog, I share my knowledge and experience with the community, offering tips and insights on cloud technologies and DevOps practices.
    Blogger Comment

0 comments:

Post a Comment