PhpMyAdmin – Administrate your MySQL database through a Web Interface

If you want to administrate your MySQL database, I strongly recommend you to use PHPMyAdmin. It is a Web interface that will allow you to run the most frequently used command through a very user friendly interface.


With that, you will not need to know anything about SQL language, you can just use the tool to do actions such as to create a database, export, import, backup, create user, gave additional permissions to some users, etc….


Obviously, before to install PHPMyAdmin to manage your MySQL databases, you need to install first MySQL Server:

sudo apt-get install mysql-server php5-mysql

Then install PHPMyAdmin by running:

sudo apt-get install phpmyadmin

It will ask you if you want to reconfigure your webserver. Select apache (with [SPACE] and then validate)

The next question will be to know if you want to configure database for phpmyadmin with dbconfig-common? ==> Not needed.

And that’s all.

You should have access to phpmyadmin from Your login is root and your password is the one you set during the installation of MySQL.

Example of configuration

Now let’s say you want to create a Database and a dedicated user to install WordPress on your computer.

1) Click on

2) In the “Create new database” field, set your DB name and click on “Create” button.


You should be informed that the database has been create


3) Now select “Check Privileges” at the right of the table you just created


4) And select “Add a new User”


5) Fulfill the needed information (User name, Host and password)


And select “Grant all privileges on database “myblog” to give this user full access to your database.

If you want to tune the access, simply select the permissions you want to give the user, from the list below.

6) Press to finish.

And now you are all set to configure your wordpress instance !


I know there are others alternatives to phpmyadmin, if you prefer some others, please share them in the comments for me to check them out.


Loves to discover web-based apps to install on his own server@home and write articles about it


Add a comment


Written on Mon, 25 Jun 2018 07:16:53 by Rahul