I've searched online for this, but I think all the info I've been coming across is for older versions of Mysql. The version I'm working with is version 4.1. I tried "create database" in the mysql directory at a command prompt, but no luck. Says "create" isn't a valid operator.

Anyone MySQL savvy?

 

Connect to your server with admin.
Left hand side of the screen there should be a icon called "Catalogs", click it.
2 junk databases should show up on the right.
Right click in the window on the right and select "Create new Schema".
Configure it.

At least that's how it works for moi.

 

If you're trying to create the database.. the command should be:

CREATE DATABASE [IF NOT EXISTS] db_name


as found here...

mysql is very picky, if it's not EXACTLY the way it wants it, it will throw a random error at you, and you have to guess untill you get it right.

Example: I was trying to create a table or something along the lines.. and it was being picky between ' and `... first time I ever ran across that.

 

people people, people...

stop using the command line prompt with mysql... lol...

use the few FREE graphical clients out there. like SQLYOG. the free version is kinda cool.

although i kinda got used to the free MYSQL FRONT before they went shareware. but that only worked with pre 4.1 and the new password scheme...

you guys are killing yourself with the command line... lol...

also, mysql has a grpahical almost QBE query tool too...