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
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
0 comments:
Post a Comment