How to Change MySQL Database Usernames

While you can’t change the name of a database user, you can create a new one and assign it to an existing database. Here’s how to do that.

1. From your webhost dashboard, locate the area that lists your MySQL Databases
2. From there, locate the option to Add a User for an associated database
3. Create the new user
4. If you’re working in WordPress then once the new MySQL user is created, you’ll need to update the wp-config file with the new MySQL username, which can be done through your admin panel or FTP
5. Access the associated website from the front end to be sure it resolves correctly
6. If resolution occurs, delete the old MySQL user