Change Username in Mysql

[msg43]

Well how can you change the mysql username?

I got the password change but I want the username change

so instead of root

it would be something like sillymonkey519563

[Alekix]

In DB mysql:

UPDATE user SET user = 'new user name' WHERE user = 'old user name';

Perhaps?

I'm not overly experienced with MySQL, so I wouldn't know if it would work in all databases. Would in my local one, though. Hope it does for you. :]

[metal_dragen Veteran]

I wouldn't change the root username - it's the admin user that has privileges on everything. Instead, create a new user with limited privileges to use for day-to-day use. You can do this via phpMyAdmin, or using MySQL's Administrator software.

[msg43]

  metal_dragen said:

I wouldn't change the root username - it's the admin user that has privileges on everything. Instead, create a new user with limited privileges to use for day-to-day use. You can do this via phpMyAdmin, or using MySQL's Administrator software.

584870072[/snapback]

please explain how to.

I use windows

[GatorV]

Use this:

http://www.mysql.com/products/administrator/

It's for windows, so you shouldn't have any problems..