Very simple, how do I create the Database

[artane]

Hey Guys,

I downloaded MYSQL and I've got the trial version of SQLyog. I'm ready to start but, I'm stuck before I can even begin.

How do I create a database? It sounds simple but, I can't figure out how to open up MYSQL. There doesn't seem to be an executable file for MYSQL on my computer.

Is this something I do from within SQLyog? If so how? As soon as I open it, it wants me to connect to a database. The problem is, I haven't created one yet!

Thanks alot guys,

artane

[CalEvans]

You are a windows user, aren't you. 🙂

(Sorry, had to take the cheap shot)

1: MySQL is a service. There is no program to run, you just start the service. Once it is running, there is no visible sign that the program is running. (Other than your system is slower now) MySQL comes with a system tray app for windows that I BELIEVE starts up when the service does (at least on Win2k it did, last time I used MySQL on windows)

If there is NO OTHER WAY you can tell if it is running on your box, open a DOS box and type

telnet localhost 3306

You should get some sort of string showing the version of mysql running and then it should disconnect. If you get this, you are up and running and ready for #2. If not, something isn't right, retreat to the docs or shake the magic 8-ball here again.

2: SQLyog is the program you are expecting to see when you start MySQL. It is a client to the server and allows you to interact with the server. If you are used to Access then you've got a steep learning curve because it's nothing like Access. Once you get SQLyog installed and running the first thing you have to do is tell it what server you want to connect to. Since your server is local then in the HostAddress just put localhost. In username and password you can put the username and password you assigned yourself or use root and an empty password. (I believe that is the default, I may be wrong.) If you do use root and empty password then please at least change the password when you get connected.

If you've done everything right then you should see the SQLyog database list on the left and the command window on the right. You probably only have 2 databases at this point MySQL and test. You can use test for…testing but leave the mysql database alone. If you don't like test, right click on the server (at the very top of the list of databases) and create you a new one.

HTH, if you have other questions, just ask, I may be sarcastic, but I try to be helpful. 🙂

=C=

p.s. I use Windows too.

[Shadow]

Sorry CalEvans, I must correct you! When installing MySql on Windows you can choose from two options in case of NT, 2000 and XP: to install it as a service or a standalone server (executable). On Win9x, only the standalone mode is available (there are no services on Win9x).

artane, if I were you, I would first read the MySql's instructions on how to install the db on Win32 platforms. It isn't difficult at all, you can figure it out in about 20 minutes.

[CalEvans]

Thanks for the update. I ran it as a service on Win2k for about 6 months but that was a while back.

Even as a a stand-alone program it does not have a front-end program built in like he seems to be looking for. Correct me if I'm wrong but in stand-alone mode, you still have no on-screen indicator that a program is running. At least when I run it as part of Uniform Server (search http://www.sf.net, it's there) I don't have any.

=C=

[Shadow]

MySql doesn't have any built-in front-end no matter how you install it, of course. My intention was to point out that it may be run as a standalone program as well. The rest of your reply was absolutely correct, I'm sorry if you misunderstood me!

I usually revert to start/stop MySql through winmysqladmin (this is the app you talked about which won't start automatically with MySql) and then I have a nice “traffic light” sitting in my tray indicating whether MySql is running or not regardless of the installation type.

[Author]

Posts