Home > Database > Mysql Tutorial > 更改Mysql root用户密码_MySQL

更改Mysql root用户密码_MySQL

WBOY
Release: 2016-05-27 10:44:18
Original
1351 people have browsed it

新下载了mysql,口令为空,如何修改root口令:

首先登陆mysql

use mysql;
update user set password=password('new_password') where user='root';
flush privileges;
Copy after login

注意需要

flush privileges;

更改Mysql root用户口令的内容小编就给大家介绍到这里,希望对大家有所帮助!

source:php.cn
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template