Site icon EasyOraDBA

Install mysql database along with phpadmin on CENTOS 6 7

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
$ rpm -ivh epel-release-6-8.noarch.rpm

if your on CentOS 7

$ wget
$ 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
Enter your root username and password and you now have a nice GUI to manage your mysql instance

Exit mobile version