PDA

View Full Version : Change user root & password of Xampp MySql


topvip
2010-07-24, 12:31 PM
here's how to change user root and password of xamppMySql:

1.Open your browser first
2.Typing "localhost/phpmyadmin" in your browser address bar
3.Typing "root" for username and leave blank for password, if you don't change password yet
4.Click {1} Privileges
5.Click {2} add new user
6.typing your username, for host: leave it for any host "%" and typing typing your password and retyping your password again on retype
7.Click "Go" to create the username and password yout typing
8.now, close your browser and try to login again with username and password yout type earlier
9.if this success you can drp/ delete root and pma user in your MySql
10.wait, we don't finish yet. try login to your MySql on your browser, but the root and pma user was delete
11.Yes, you can't login to your MySql, keep reading
12.Open this file in notepad: \Xampp\phpmyadmin\config.inc.php
13.find this text: “$cfg['Servers'][$i]['auth_type']=’config’;” and change to this: “$cfg['Servers'][$i]['auth_type']=’http”;”
14.try to login again in your MySql again
15.Bingo, now your MySql more secure than before.
username is the first layer of your security