XAMPP修改mysql的默认密码的三种方法
来源:互联网 发布:百度seo一本通 下载 编辑:程序博客网 时间:2024/04/28 02:47
How I can set a "root" password in MySQL? (method 1)
In the \xampp\mysql\bin directory enter into the console:mysqladmin -u root password secret
Ok, "secret" should be your secret password. Then update the password for PHPMyAdmin. Open the "config.inc.php" in \xampp\phpmyadmin an edit following lines:
INSTEAD OF ...
$cfg['Servers'][$i]['user'] = 'root';$cfg['Servers'][$i]['password'] = '';NOW ...
$cfg['Servers'][$i]['user'] = 'root';$cfg['Servers'][$i]['password'] = 'secret';
Set a new 'root' passwort with mysqladmin
How I can set a "root" password in MySQL? (method 2 )
Well, there is still another possibility to set the root password. Start PHPMyAdmin with http://127.0.0.1/phpmyadmin, open the database "mysql" (never delete this!) and use the table "user". Create here a new user or e.g. simply change the password of "root." MySQL restart! After that, do not forget to change the password in the "xampp/phpmyadmin/config.inc.php" for PHPMyAdmin.How I can set a "root" password in MySQL? (method 3 )
This method based on a suggestion by Ruedi from Basel. With that: Thanks and Grüssli to Switzerland!Tip: Resetting the password can be make also with the /xampp/mysql/resetroot.bat. After that, the password is empty means "".
Step 1: Run cmd
C:\ program files \apachefriends\xampp\mysql\bin>mysqld-nt --skip-grant-tables
Step 2: Run cmd
C:\>C:\ program files\apachefriends\xampp\mysql\bin\mysqladmin -u root flush-privileges password "newpwd"
Step 3: Stopping MySQL
C:\>C:\ program files\apachefriends\xampp\mysql\bin\mysqladmin -u root -p shutdown
Enter password: ****** (newpwd)
Step 4: Edit the “config.inc.php” for the access of PHPMyAdmin
C:\ program files\apachefriends\xampp\phpmyadmin\config.inc.php
Here search for "root"
'$cfg['Servers'][$i]['password'] = 'newpwd'; // MySQL password
Step 5: MySQL restart
转载:http://www.apachefriends.org/zh_cn/faq-xampp-windows.html#password0
- XAMPP修改mysql的默认密码的三种方法
- 修改xampp的mysql默认密码
- 修改xampp的mysql默认密码
- 修改xampp的mysql默认密码
- 修改xampp的mysql默认密码
- xampp修改mysql默认的空密码
- 修改xampp的mysql默认密码
- 修改xampp的mysql默认密码
- xampp中修改mysql默认空密码(root密码)的方法分享
- xampp中修改mysql默认空密码(root密码)的方法
- xampp默认mysql数据库root密码的修改
- xampp默认mysql数据库root密码的修改
- 修改xampp的mysql密码
- xampp默认mysql密码设置,修改mysql的默认空密码
- xampp默认mysql密码设置,修改mysql的默认空密码
- xampp默认mysql密码设置,修改mysql的默认空密码
- xampp默认mysql密码设置,修改mysql的默认空密码
- xampp默认mysql密码设置,修改mysql的默认空密码
- [技术分享-RMS]无法打开加密邮件
- Skype SILK vs. iLBC vs. Speex
- 属性,点语法,实例变量
- 小巧的ifenslave负载均衡工具
- TPC-W Client端部署
- XAMPP修改mysql的默认密码的三种方法
- 好声音第二季秘密筹备 32郎惨被好友挤下台
- ios打电话的两种方式
- UML知识点整理
- linux应用程序 内存泄露问题定位 -- memwatch
- LinkButton的自定义(未完成)
- 系统设计题浅谈
- lua堆栈操作常用函数学习二
- java如何调用windows动态链接库