Programming

How to change MySQL 5.0 root password and username

Change Password
Step 1:

Open Command Prompt "CMD"

Step 2:

Type
cd\

Type
MYSQLADMIN -U user -P(password) PASSWORD newpassword
-----------------------------------------------------------------------------------------
user=root or your mysqluser
(password)=your current password
newpassword=your new assigned password

sample: user=root, password=123456, newpassowrd abcdef

mysqladmin -u root -p123456 password=abcdef
-end-


Change Username
Step 1:

Open your Mysql database using your GUI ,ex. MySQLYOG

Select  mysql database, then open user table and now you can change the username then click the save button.

close your GUI

Step 2:
Now we need to restart database. We have two ways to do it, using command promt or using services

A.)Using Command Prompt
-open Command Prompt(cmd)
-type
 net stop mysql
 net start mysql

OR

B.)Using services

-Click Start >>Control Panel>>Administrative tools then open services

-look for the mysql service

-right click then click stop

-right click then click start

-end-

we need to restart mysql services to refresh our database