I have installed mysql in my system and created a new user using create user command.
Although I can login as this new user through gui in mysql but how can I login as this new user through sqlclient command line.
It is to simple although you can't do that directly through menu->mysql5.0>sqlcommandlineclient
for this to happen go to command prompt
I.e run>cmd
go to the path of bin directory where mysql is installed in your system
as cd C:\Program Files\MySQL\MySQL Server 5.0\bin in my system
type mysql -h 'hostname where server is running not yourhostname as to connect to 14 server i will use 192.168.1.14' -p -u 'yourusername' press enter
it will ask for your password provide that. You are done.
