如何更改MySQL的用户名和密码? [英] How to change USERNAME And PASSWORD of MySQL?

问题描述

我已经在计算机(Windows-7操作系统)上安装了 MySQL Server 5.0 .

I have installed MySQL Server 5.0 on my machine (Windows-7 OS).

我现有的MySQL用户名和密码是root，root，由于某种原因，我现在也想同时更改用户名和密码.

My existing USERNAME And PASSWORD for MySQL is root, root and now due to some reason I wants to change both USERNAME And PASSWORD also.

许多人之前曾问过这个问题，但我发现没有人对我有用.因此，任何人都可以告诉我如何从哪里进行更改吗?

Many people have asked this question before but no one I found useful for me. So can anybody please tell me HOW and from WHERE can I change it?

推荐答案

只需从mysql控制台执行以下查询:

Just execute this query from mysql console:

 UPDATE mysql.user SET user='newusername',
 password=PASSWORD('newpassword') WHERE user='root';
 FLUSH PRIVILEGES;

这篇关于如何更改MySQL的用户名和密码?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！