Mysql is the most popular open database and is the M in the LAMP stack (others being Linux-Apache-PHP)
If your on CentOS and your linux server is connected to the internet installing mysql is just a few terminal commands
1. Install the LAMP stack via yum
$ yum install httpd mysql-server php php-mysql
2. Configure the LAMP Stack
$ service httpd start
Now you should have a webserver up and running on http://localhost/
3. Start and secure your mysql database by executing below script
$ service mysqld start $ mysql_secure_installation
Securing your database is very important, specially if your deploying a productions database
4. Install phpmyadmin
Install the EPEL Repo, if your on CentOS 6
$ wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm $ rpm -ivh epel-release-6-8.noarch.rpm
if your on CentOS 7
$ wget http://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm $ rpm -ivh epel-release-latest-7.noarch.rpm
Now install phpmyadmin
$ yum install phpmyadmin
If you want access to phpmyadmin from other computers edit below file and add the host ip’s
$ vi /etc/httpd/conf.d/phpMyAdmin.conf Require ip <other workstation ip> Allow from <other workstation ip> Restart httpd services $ service httpd restart
You can now access using below URL
http://localhost/phpmyadmin
Enter your root username and password and you now have a nice GUI to manage your mysql instance
