command line client

Hi there,

I recently installed MySQL 5 on my Windows XP. After the installation a
MySQL command line client icon was added to my desktop. I tried to start
mysql by clicking the icon and it asked for a password that applied to the
root user. My question is that how can I log in as a user other than the
root user since the prompt doesn't ask for an user name. Is there something
wrong with my installation? Thank you! :)

Evan Jou

Evan Jou wrote:

> I recently installed MySQL 5 on my Windows XP. After the installation a
> MySQL command line client icon was added to my desktop. I tried to start
> mysql by clicking the icon and it asked for a password that applied to the
> root user. My question is that how can I log in as a user other than the
> root user since the prompt doesn't ask for an user name. Is there something
> wrong with my installation? Thank you! :)

Just open a cmd-window and type

mysql -u<username> -p<password>

and you will login as another user than root.

If you look at the icon preferences, you may see that it runs

mysql -uroot -p

so you can mace a copy of that icon and switch the root part to tne new user
you had created.

--

//Aho