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
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 http://www.yourwebsite.com/phpmyadmin 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.