So you have finally got MySQL running in Ubuntu. Now how to manipulate the database? You can open the Terminal window and use the MySQL command prompt but it can become really laborious after a while, especially if you’ve been using some sort of GUI in Windows to work with MySQL. Although there are several options, in this blog post we’re installing mysql-admin. Conventionally people use the command prompt to install software, but this should be present in the repository.
Go to System -> Administration -> Synaptic Package Manager
It gives you this window (it asks for your user password before the window):
Search for mysql-admin. Mark it, and then click Apply. After it has been installed, you’ll need to run MySQL Query Browser in order to view databases. It’s not as elaborate as the Windows versions of many GUIs, but it does the job better than the command prompt.