Skip to main content

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:

Then install PHPMyAdmin by running:

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.

4 thoughts on “PhpMyAdmin – Administrate your MySQL database through a Web Interface

  1. I am on the /phpmyadmin/setup/index.php page. It says there are no servers configured. Is this asking for the name of the MySQL Server, my Web Server or something else?

  2. Hi Karibu, it’s Duc from Sharetribe Community. So by following this guide we can set up myPHPadmin for Sharetribe as well?

    sudo apt-get install mysql-server php5-mysql
    sudo apt-get install phpmyadmin

    Are these the 2 commands required or there are other steps before that?


    1. Hi,
      Glad to see you here 😉

      You don’t need to install mysql server, you already have it. You can install phpmyadmin directly.
      Do you have apache installed already? Or you are using nginx?

Leave a Reply

Your email address will not be published. Required fields are marked *