How to create a connection with MySQL Admin?

I am extremly new with databases. I have only created one, and that was in SQLite on android. I downloaded MySQL Admin for linux (Ubuntu) and downloaded and installed Admin. Now I want to create a database, but I jave know idea what I'm doing. I created a connection via the drop down menu option 'Open Connection Editor', and I keep getting a 'MySQL Error Nr. 2005' error. Do I have 开发者_JAVA技巧to do something command line wise first to set up the database?

Any help is appreciated.

Aedon

MySQL is different to SQLite in that you need to have some server software running the whole time managing the database. It's that server software that you connect a MySQL client to.

You need to grab yourself a copy of MySQL Server then I'd recommend this tutorial

Good luck!

If you are using Ubuntu you can install MySQL Server easily with this command:

sudo apt-get install mysql-server

and then I suggest you to download MySQL Workbench, it's a GUI Tool where you can do almost everything with MySQL databases (create,drop,alter, modeling, administer the service).

Then, you can create a connection with mysql workbench or mysql admin (or another client) and do your stuff. If you installed the server in your PC then the parameter are something like this:

host = localhost
user = root
password = (the password you specified in the installation)