简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > php教程 > php手册 > body text

phpMyAdmin中修改MySQL root密码的方法

WBOY
Release： 2016-05-26 08:21:16
Original
2380 people have browsed it

phpmyadmin修改mysql用户的密码我们要注意一点的是,如果你修改的是你自己登录的用户密码,那么我们修改之后就必须在phpmyadmin配置文件中进行修改,下面我们一起来看看.

点击顶部的"SQL"标签进入sql命令输入界面,输入以下命令:

update mysql.user set password=PASSWORD('snsgou$123456') where user='root';
Copy after login

注意了,如果你修改了root密码之后我们的phpMyAdmin的配置文件中的密码也需要修改,否则登录不上去.

找到:$cfg['Servers'][$i]['password'] = '';//phprm.com

修改为:$cfg['Servers'][$i]['password'] = 'snsgou$123456';

重启MySQL服务后新密码生效.


教程网址:

欢迎收藏∩_∩但请保留本文链接。

Related labels：
password
source：php.cn
Previous article：PHP邮件发送例子,已测试成功 Next article：php强制运行广告的代码
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
Sudoku checker not working? Can anyone help me identify the error? I tried everything on the online editor but still get the error. But when I do this on VSC...
From 2024-04-06 21:21:07
0
1
474
How to make floated elements stack vertically instead of horizontally in CSS? I'm trying to make a webpage with two columns, with main content on one side and additiona...
From 2024-04-06 20:45:26
0
2
386
Is there a way to force the text in the flexbox to be vertically centered, no matter what other CSS code we have? I have the following CSS code that is part of a larger CSS code used in a website I'm deve...
From 2024-04-06 20:41:51
0
1
518
How to solve the mysterious white space at the bottom of the page in CSS I'm trying to build a simple webpage using Bootstrap and D3, but I don't know how to get r...
From 2024-04-06 20:22:15
0
1
454
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！