MySQL

Trotter

Can anyone tell a beginner like me how to set a database Ive made as the default when starting up the MySQL server? Im using a windows machine. Cheers!

Lawnkiller

how are you connecting to the server.

Trotter

I have the mysql icon on my desktop and when I open that it goes straight into a command line box and gives me a mysql> prompt.

The server runs when I start the machine. I didnt set it up that way, its just the way it is.

The Corinthian

USE dbname

And RTFM while yop're at it :mad:

Trotter

I did read the manual. I also know about the USE database. What Im looking for is the server to use my database automatically from startup without typing USE, i.e. when the server starts it goes straight to my db.

The Corinthian

What do you mean by server to use your database automatically? What software do you want to connect to the database? A scripting languages like ASP or PHP? Another database? Explain, as you're not really saying what you want to do.

leeroybrown

TO open mysql the normal command is:

mysql -u username -p

(the -p flag is to ask for a password prompt)

To specify a database to USE you can add the name to the end of the command:

mysql -u username -p dbname

So, considering that your desktop icon is probably just a shortcut of some sort you can just add the dbname to the string describing the shortcut.

davej

I'm not sure exactly what you're looking for but there are a number of ways to reference a particular database within mysql:

EG if using jdbc to connect, you can use a url thus:

url= "jdbc:mysql://myhost.com:3306/dbname/"

I don't think there is a way to assign a default database to a user like the way you can with MS Sql Server. With MS SQL you automatically connect to your user's default database without having to mention it explicitly in a connect command.


davej