In my previous post, you knew how to set up your own website with Apache, MySQL and PHP on CentOS 6. Today, I’ll show you how to use phpMyAdmin 3.4 to manage your MySQL server. This software provides a user interface that greatly simplifies your interactions with MySQL.
1. Install phpMyAdmin
# cd /var/www/html # wget -c http://downloads.sourceforge.net/project/phpmyadmin/ phpMyAdmin/3.4.3.2/phpMyAdmin-3.4.3.2-english.tar.gz # tar xvfz phpMyAdmin-3.4.3.2-english.tar.gz # mv phpMyAdmin-3.4.3.2-english phpmyadmin # cd phpmyadmin # cp config.sample.inc.php config.inc.php # vi config.inc.php : $cfg['Servers'][$i]['auth_type'] = ‘http‘; # default is cookie : # service httpd restart |
2. Manage MySQL Database With phpMyAdmin
To open the main phpMyAdmin page, type http://ipaddress/phpmyadmin into the address field in your browser.
You can use phpMyAdmin to administer your databases in one of two ways:
- Write SQL queries
- Click links and buttons in the phpMyAdmin interface
3. Quicker Way To The MySQL Server
When MySQL is installed, a simple, text-based program called mysql is also install. To send SQL queries to MySQL by using the mysql client, follow these steps:
Have fun!