[SOLVED] mysql help part 2

[sasori]

each time i fire up the mysql console, it always asks for the default root password.

then i just learned how to add new users a few hours ago.

the problem now is, how am i gonna make my wamp mysql console to ask for username and password?

so that i can test my newly added user accounts.  ???

[wildteen88]

Open up the command line terminal by going to Start > Run > cmd

 

Now type the following command

mysql -u YOUR_USERNAME -p

and press enter (change YOUR_USERNAME to what ever your new user is). MySQL will then ask for the password. Enter your password and press enter. If successful you'll be logged in as the new user.

 

NOTE: before using the mysql command you may have to navigate to MySQL's bin folder first, to do so run this command first

cd C:\wamp\mysql\bin

now press enter. The command prompt should now read

C:\wamp\mysql\bin>

Now run through the steps above.