Open any browser and type the following URL to check that phpMyAdmin is working properly or not. Configuration for root User:Ĭonnect with the database server and check the current authentication method of root user.
![reinstall phpmyadmin ubuntu 14.04 reinstall phpmyadmin ubuntu 14.04](https://www.linuxiarz.pl/wp-content/uploads/2015/03/TS3_2-624x280.png)
You can also create new user account to access phpMyAdmin. If ‘ auth_socket’ plugin is loaded for root user then change the authentication method of root user from ‘ auth_socket’ to ‘ mysql_native_password’ for security purpose. root user can use ‘ auth_socket’ or ‘ mysql_native_password’ plugin to make connection with the server. If no password is set for root user when MySQL or MariaDB server is installed then it is necessary to set a password for the database server later.
![reinstall phpmyadmin ubuntu 14.04 reinstall phpmyadmin ubuntu 14.04](https://uitechplus.com/wp-content/gallery/installing-drupal-on-xampp-and-ubuntu-14-04/screen-05.jpg)
But it is better to use phpMyAdmin by making a connection as root user to perform all type of database operations. The default username is ‘ phpmyadmin’ and the password is the one that you have set in the previous step. Step-2: Setup Authentication and PrivilegesĪ default username and password are set at the time of installing phpMyAdmin for doing database tasks. Now, phpMyAdmin is installed properly and you can go for the next step to setup other configuration of phpMyAdmin. Run the following commands to check that Apache2, MySQL and PHP are installed and working.Ĭheck the current status of web server (Apache2).
#Reinstall phpmyadmin ubuntu 14.04 install#
This tutorial will help you to install phpMyAdmin on Ubuntu.īefore starting the installation process, you must confirm that LAMP is working properly. But if you are using LAMP on Ubuntu then you have to install phpMyAdmin by downloading the package. It will be installed on XAMPP server by default when you will install XAMPP server. If you are using XAMPP server for Ubuntu then you don’t need to install phpMyAdmin separately. To do web development works, you can install XAMPP or LAMP. Import or export database or table or data from or to different formats.
![reinstall phpmyadmin ubuntu 14.04 reinstall phpmyadmin ubuntu 14.04](https://1.bp.blogspot.com/-ov5PVTUm6zs/Xzo4el_fTfI/AAAAAAAAD5I/GrPgQ_75PpobhboPw8T5ybSOWzdNA7HBwCLcBGAsYHQ/s400/web%2Bserver%2Bhttp.jpg)
#Reinstall phpmyadmin ubuntu 14.04 update#
Insert, delete and update records of the tables.Create, drop, rename or alter databases, tables, columns, primary keys, unique keys and indexes.