I have never changed user, but can try this.. copy/paste from google
Instructions
Click the Windows "Start" button and type "cmd" in the search text box. Press*Enter*to open the Windows command line.
Type "mysql" and press*Enter*to start the MySQL command line utility. Using the MySQL command line, you can update the tables on the database.
Type the following SQL code to update the root user:
UPDATE mysql.user SET user='newuser' WHERE User = 'root';
Change*newuser*with the value you want to use in place of*root
Type the following SQL code to change the default user's password:
UPDATE mysql.user SET authentication_string = password('pass') WHERE User = 'newuser';
Replace*pass*with the new password, and replace*newuser*with the name of the user you set up in the previous step.
|