Getting the "mysql" prompt

Getting the "mysql" prompt

am 02.04.2006 19:30:54 von TechBoy

I installed MySQL4.0. No for creating a databse the help says like go
to "mysql>" prompt and then enter some commands. How do I get this
prompt ??

Re: Getting the "mysql" prompt

am 02.04.2006 20:44:22 von Jonathan

techBoy wrote:
> I installed MySQL4.0. No for creating a databse the help says like go
> to "mysql>" prompt and then enter some commands. How do I get this
> prompt ??
>
You will have to use the mysql command line tool, which is normally
called mysql and should be located in the mysql/bin directory.

Type:

mysql -u [username] -p

and replace [username] for the username you will use to login to mysql,
you will be prompted for a password because of the -p option.

See also: http://dev.mysql.com/doc/mysql/en/mysql.html

Jonathan