How to Install Phpmyadmin
in ubuntu 14.04
Phpmyadmin is a
free tool used to administrative MySQL database in a GUI mode (Using web
browser). You can perform almost all the major tasks like creating ,
deleting and modifying databases, tables, rows etc. you can also optimize
and repair tables just with a single click .
Note
: Before you get started with this, you need to install
LAMP or MySql-Server on this server.
Step
1 - Update Ubuntu repositories and install phpmyadmin
root@digidom:~# apt-get update
root@digidom:~# apt-get install phpmyadmin
Step
2 - During installation you will be asked
to select a Web server to run the phpmyadmin interface. Hit
"SPACE", "TAB", and then "ENTER"
to select Apache.
Step
3 - You will be asked to configure a
database for phpMyAdmin. Select Yes and press Enter.
Note : If you already configured
mysql-server manually, just choose “No” and hit enter to complete the
installation.
Step 4 - Provide a password for the Database
Administrative user.
Step 5
- Provide a MySQL application password for phpmyadmin.
Success, phpMyAdmin installation has been completed now.
Step 6 - The installation process actually adds the phpMyAdmin Apache configuration file into the "/etc/apache2/conf-enabled/ "Directory, where it is automatically read.
Step
7 - Restart apache
service.
root@digidom:~# service apache2 restart
Step
8 - Launch a Web
browser and login to phpMyAdmin with the username and password created during
installation "http://Your-Server-IP-Address/phpmyadmin/".
You will be redirected to PhpMyAdmin main web interface.
Now, you can manage your MySQL databases from phpMyAdmin web
interface.
Additional
Note : phpMyAdmin should work well. In case phpMyAdmin
is not working "page not found", please do the following steps and add to end of line.
root@digidom:~# vi /etc/apache2/apache2.conf
Include /etc/phpmyadmin/apache.conf
root@digidom:~# service apache2 restart
No comments:
Post a Comment