Install MySQL and PhpMyAdmin to Apache Web Server on Linux VPS or any Linux Machine [Ubuntu]
PhpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser.To manage mySQL hassle free from GUI Interface PhpMyAdmin is installed along mySQL.
Steps to Install MySql and PhpMyAdmin to VPS
- Login to your VPS command line or Open terminal on your Ubuntu Machine.
 |
| Terminal VPS |
- Type the following commands :
- apt-get install mysql-server
- Now terminal will open a "Package Configuration Wizard".
- Setup the password for the mysql user.
- apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin
- Now again a "Package Configuration Wizard" will open.
- Choose "Apache2" and press YES when asked for "Configuring PhpMyAdmin".
- Enter password for the PhpMyAdmin user and make sure that password of MySQL and PhpMyAdmin are same.
 |
| Configure PhpMyAdmin Wizard |
- Now move PhpMyAdmin to directory accessible on Web i.e [ /var/www ].
- ln -s /usr/share/phpmyadmin /var/www/phpmyadmin
- Now restart Apache Web Server and open PhpMyAdmin Panel.
- restart apache2
- Open your site [ Vps Ip/phpMyAdmin ] e.g [ http://192.168.0.1/phpMyAdmin ]
 |
| PhpMyAdmin Web Interface |
- MySQL and PhpMyAdmin are successfully installed on your VPS or Machine.
