2 messages in com.mysql.lists.win32RE: MySQL Admin question
FromSent OnAttachments
Rodney Ivers09 Apr 2003 14:24 
Patrick Ouellet10 Apr 2003 05:06 
Subject:RE: MySQL Admin question
From:Patrick Ouellet (poue@microtecsecurite.com)
Date:04/10/2003 05:06:31 AM
List:com.mysql.lists.win32

I assume you have not RTFM.

But since its an easy question, i'll answer it again.

update user set password=(PASSWORD('insertpasshere')) where user='root';

but next time, please read the manual before asking question that are surely answered there!

-----Original Message----- From: Rodney Ivers [mailto:ive@ipa.net] Sent: 9 avril, 2003 17:25 To: win@lists.mysql.com Subject: MySQL Admin question

I am a new MySQL user. I am a little confused about users in the MySQL environment. I would like to know how to change the root password, which implies that I need to know how it is set from the install?

Any pointers to documentation would be appreciated.

Thanks!