View Single Post
  #1   IP: 117.95.49.129
Old 2010-07-24, 12:31 PM
topvip topvip is offline
超级版主
 
Join Date: 2006-01-04
Posts: 1206
topvip 正向着好的方向发展
Default Change user root & password of Xampp MySql

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
Reply With Quote