Search Suggest

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

Đăng nhận xét