Lorem ipsum dolor sit amet, consectetur adipiscing elit. Test link

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*

Start MySQL package
# service mysqld start

Auto start MySQL service on reboot time
# chkconfig mysqld on

Rest MySQL root passwrod
/usr/bin/mysqladmin -u root password 'new-password'
#/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

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


Exit from MySQL
mysql> quit

Đăng nhận xét