A handy tool to manipulate MySQL is the MySQL MySQL Query Browser. It’s from MySQL AB (the company that makes MySQL).
Click through to find out how to create a database using the Query Browser.
Installing MySQL Query Browser on Ubuntu Linux
Depending on how you installed MySQL, MySQL Query Browser may already be installed. If so, it’ll be in the Programming section of the Applications menu:
If not, click here in Firefox to install it, or type the following into a terminal:
sudo apt-get install mysql-query-browser
Make sure you have all the repositories enabled before installing.
Running MySQL Query Browser
Choose “MySQL Query Browser” from the Applications > Programming menu of Ubunutu. Or execute the program “mysql-query-browser” from the terminal.
Once it opens, it’ll ask you to log in. Use the root user and password you specified when installing MySQL:
You can save connection information to avoid having to enter it again. If you want it to save passwords, too, choose that option from Tools: Preferences: General Options: Store connection passwords.
Creating a Database with MySQL Query Browser
Find the “Schemata” window on the right-hand side. “Schema” is a fancy synonym for “database”, and “schemata” is the plural.
Right click anywhere, and choose “Create Schema”.
Enter the name of the new database and hit OK.
The new database is shown in the schemas window:
Setting Permissions on the New Database
Once you’ve created a database, you have to set permissions on it for a given user (other than root) to use it. You can do that textually by executing queries with the MySQL Query Browser. But it’ll probably be easier to set user permissions with MySQL Administrator.
If you liked this article
If you liked this article, don’t forget to subscribe for updates!
Get updates by RSS (What’s RSS?)
Follow me on Twitter
![[del.icio.us]](http://digitivity.org/blog/wp-content/plugins/bookmarkify/delicious.png)
![[Digg]](http://digitivity.org/blog/wp-content/plugins/bookmarkify/digg.png)
![[dzone]](http://digitivity.org/blog/wp-content/plugins/bookmarkify/dzone.png)
![[Facebook]](http://digitivity.org/blog/wp-content/plugins/bookmarkify/facebook.png)
![[LinkedIn]](http://digitivity.org/blog/wp-content/plugins/bookmarkify/linkedin.png)
![[Reddit]](http://digitivity.org/blog/wp-content/plugins/bookmarkify/reddit.png)
![[Slashdot]](http://digitivity.org/blog/wp-content/plugins/bookmarkify/slashdot.png)
![[StumbleUpon]](http://digitivity.org/blog/wp-content/plugins/bookmarkify/stumbleupon.png)
![[Technorati]](http://digitivity.org/blog/wp-content/plugins/bookmarkify/technorati.png)
![[Twitter]](http://digitivity.org/blog/wp-content/plugins/bookmarkify/twitter.png)
![[Yahoo!]](http://digitivity.org/blog/wp-content/plugins/bookmarkify/yahoo.png)
![[Email]](http://digitivity.org/blog/wp-content/plugins/bookmarkify/email.png)
Top Incoming Search Terms
cache:ipeygnfyirqj:digitivity.org/951/install-free-open-source-software-on-mac-osx-with-darwin-ports "hope poster" application mac connecting +"mysql query browser" +ubuntu create a database in ubuntu create dababase mysql mac create database in mysql on ubuntu create empty database create database mysql query browser create database terminal create database ubuntu browser create mysql database on ubuntu desk create password for new wordpress user mysql ubuntu create schema query in mysql using user id and password create user for mysql query browser creating a database in ubuntu database linux ubuntu database query ubuntu db query in ubuntu glendale web design how create new connection in mysql query browser how to choose a schema in mysql query how to create new schema on mysql mac os how to creating a database with mysql on ubuntu how to execute mysql database browser how to execute mysql query ubuntu how to install mysql query browser in linux how to install mysql query browser in ubuntu how to login mysql ubuntu from terminal how to set password on mysql cheme\ how to start working with mysql in ubuntu how to start mysql query browser inlinux ubuntu how to start query browser in linux ubuntu how to update mysql database schema in linux how to update mysql in terminal in ubuntu http://digitivity.org/953/creating-a-database-in-mysql-with-mysql-query-browser-on-ubuntu-linux http://www.ipad-for-free-online.co.uk/ instalando mysqlquerybrowser criando databse install mysql administrator terminal ubuntu install mysql query browser ubuntu install query browser in linux linux mysql browser linux mysql movies db movie database ubuntu mysql assign database permissions mysql assign permissions in query browser mysql browser db mysql browser for iphone mysql browser from firefox on ubuntu mysql browser linux mysql browser ubuntu mysql create database ubuntu mysql create db terminal mysql creating database from terminal mysql execute query from terminal mysql queries mysql queries for create mysql query browser creating database mysql query browser database create mysql query browser database username password mysql query browser new database mysql query browser schema mysql query browser to access mysql query browser ubuntu mysql query for creating a database schema mysql terminal create user with database mysql wordpress create database terminal mysqlquerybrowser create user query browser create table query mysql terminal ubuntu query mysql window root query browser run mysql query browser from ubuntu terminal set db user with mysql query browser site:http://digitivity.org terminal query mysql create ubunto mysql tools for creating database schema ubuntu query browser ubuntu database programming ubuntu login to mysql terminal ubuntu mysql ubuntu mysql create db ubuntu mysql query browser does not remember password ubuntu mysql query database ubuntu mysql-query-browser ubuntu root launch mysql-query ubuntu save mysql ubuntu saving emails to database ubuntu, running mysql query browser from terminal using mysql query browser using mysql query browser in ubuntu linux using mysql ubuntu terminal www.gustoads.comRelated posts:
- Monty Widenius Is Still Trying to Save MySQL From Itself I blogged before about the different versions of the MySQL...
- Will the Real MySQL Please Stand Up? Of late, there isn’t just one version of MySQL being...
- How to Log in to a Webserver Without a Password Using SSH Public Keys on Ubuntu You can avoid the annoyance of typing in your password...
- How to Install Google Skipfish on Ubuntu Linux Skipfish is a new security scanning tool from Google that...
- How to Manually Add Hosts in Windows, Linux, and OS/X Normally when you want to access a server on the...
Explore related content: create database, database, MySQL, MySQL Query Browser, schema, Ubuntu
Hi !
Your Post is very nice. Thanks for your sharing.
This post will be useful to every one….
IT Niche´s last blog ..Welcome to ITNiche Web Design & Development Company
i use cpanel to do all my online SQl creation and database creation, not to sue with Linux but i figure it works the same way?
do people even still use redhat?
free photoshop tutorials´s last blog ..Cute Cat line art to Colorful finish with Photoshop
This is very useful for those that use Ubuntu Linux.
I use only Windows but I’ve heard that Linux is more safety and better at many points..
Hey man thanks so much for sharing,,,
You have solved a big matter if mine…
working on drupal and joomla on this os is great experience thanks for sharing
Thanks for sharing!
Cool, thanks for this. I just installed Ubuntu and was looking for tips on working with MySQL.
Thanks to WordPress I have no problems using mysql. Everything is installing in a second.
Thanks for sharing. You did your topic in a very clear manner of explaining. Now, I can really say that ubuntu browser having a mySQL database will made be easy and convenient to use even with micosofts’ users.
Francis@Coil cord´s last blog ..Coil Cords- Meridian Cable Turns 3 Coil Cords Into 1
Hey man thanks so much for sharing,,,
You have solved a big matter if mine…
drupal will win the race .. this technology is the best to work on
thanks buddy it really helpful for me.
thx for share..i am student IT in indonesia..very useful
thanks i’m bookmarking this page
Great tutorial. Should be bookmarked. Thanks for sharing the info.
Computer Tips Tricks´s last blog ..Fix- 80072efd Windows Update Error Code – Windows 7 and Vista
Very informative post – it was useful information. Cheers!
This post will be useful to every one….
Congratulations, you have officially earned the Dumber than a Box of Rocks Award.
gafas´s last blog ..Gafas de sol Arnette para hombre
Thanks for sharing. You did your topic in a very clear manner of explaining.
it can be acquire good interest rates on financial savings presently. the banks are not proposing very good percentage rates
Nice funny sutff click here for MORE
enjoy many more cool pictures gifs and what not
I’m using PHPmyadmin and the cpanel integrated Mysql Wizard. The user interface looks great I’m wondering if this is a better option to go. Is it open source?
Sergei from Edigitalz
Thanks, I only started experimenting with Linux recently and wasn’t really sure how to do this properly. Very good explanation there.
Thanks for sharing this valuable info..I’ve always found working on MYSQL comfortable for my programming projects..thanks again for the instructive post..
Simple but very effective post about Installing MySQL Query Browser on Ubuntu Linux.
Thanks for nice sharing………….!
Orchids´s last blog ..Vanilla Orchid
A walkthrough for Creating a Database in MySQL. Good thread
พระเครื่อง´s last blog ..แขวนพระ ให้ถูกโฉลกปีมะเมีย
plz regularly share your experience and efforts here………!
This is also an effective post abot MySQL.
Thanks.
.I’ve always found working on MYSQL comfortable
A great tutorial deserves a thumbs up. I’m an IT student, and I’m always using MySql as my backend database.
I’m always using MySql as my backend database.
number one blog thanks.
Thanks, Finally, i was looking for solution to create database.
I’ve just switched to Ubuntu from windows. I often use mysql for my database. Thanks for this useful tutorial
best wireless printer´s last blog ..Brother MFC 7840W Review
very useful info, I have never used MySQL when using linux, because I more often use the windows. I will try next time
wootechno´s last blog ..Gigabyte GN-TB100- 101-inch tablet with NVIDIA Tegra 2 Processors
I love using Ubuntu so much. Now, I’m waiting for new Ubuntu 11.04. It must be very great to see this new version coming.
3 wheel scooter´s last blog ..Slider The Unscooter U6 Review
Hello there could you mind letting me realize which usually service provider you’re using? We have filled your website within Three very different web browsers and I must say this blog lots faster after that many. Can you suggest a excellent hosting provider with a reasonable value? Thanks, We enjoy it!
No wonder why some in the outstanding makers with these women’s boots for winter are coming from Australia, too. You can uncover the adore From Australia and Ugg Australia, which can be equally enjoying their reputation as among the perfect ugg producers throughout the world.
La cantidad de insultos que se me vinieron hoy a la mente… igual ya pasпїЅпїЅ… “yo avisпїЅпїЅ con tiempo” te viпїЅпїЅ a dar
The new Zune browser is surprisingly good, but not as good as the iPod’s. It works well, but isn’t as fast as Safari, and has a clunkier interface. If you occasionally plan on using the web browser that’s not an issue, but if you’re planning to browse the web alot from your PMP then the iPod’s larger screen and better browser may be important.
Wow! This could be one particular of the most beneficial blogs We’ve ever arrive across on this subject. Basically Fantastic. I’m also a specialist in this topic so I can understand your hard work.
Pretty section of content. I just stumbled upon your web site and in accession capital to assert that I get actually enjoyed account your blog posts. Any way I’ll be subscribing to your augment and even I achievement you access consistently rapidly.
My spouse and i have been now peaceful when John could finish off his preliminary research through the entire ideas he was given out of your web site. It’s not at all simplistic just to happen to be freely giving steps which others could have been trying to sell. And now we fully understand we have got the writer to thank for this. These illustrations you made, the straightforward blog navigation, the friendships you will assist to promote – it’s got mostly exceptional, and it’s helping our son and the family recognize that the theme is amusing, which is very essential. Thank you for the whole thing!
I think this is among the most significant information for me. And i am glad reading your article. But want to remark on few general things, The web site style is great, the articles is really excellent : D. Good job, cheers
Thanks for some other informative website. Where else may just I get that kind of information written in such a perfect way? I’ve a venture that I’m simply now working on, and I’ve been on the glance out for such info.