WampServer

FYI,


I want to know how to switch user from the root, i have created the user with password and granted permissions for that user, i need to change the user

i tried

mysql> mysql -uusername -ppassword

Error message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax

please help me, its very much required.

If you actually created a mysql userid then the syntax you entered should work!

How did you create the new user?

I created the user using

create user 'username'@'localhost' identified by 'password';

What's the issue?


The command is

mysql -uUSERNAME -p

you must do this from command prompt in the mysql/bin folder.


You cannot do it in the mysql console as you are already logged in as root.

To change the user the console opens with open

C:/wamp/wampmanager.tpl

Search for root and replace with your username

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Thanks a lot it worked....

If you had said you were using the MySQL Console in the first post that would of helped( just a bit )