Toad for MySQL - Community for development, administration, tuning, tips and tricks

Thread: How does one change an mySQL user's password?

This question is answered.

Reply to this Thread

Search Forum

Back to Thread List

	Replies: 2 - Pages: 1 - Last Post: Sep 1, 2011 7:40 PM by: ktanan	Threads: [ Previous \| Next ]

ktanan

Posts: 2
Registered: 8/18/11

How does one change an mySQL user's password?
Posted: Aug 22, 2011 10:35 AM

for example in Oracle :
ALTER USER <username> IDENTIFIED BY <new_password>

Thank you.

Mauritz

Posts: 314
Registered: 8/23/07

Re: How does one change an mySQL user's password?
Posted: Aug 22, 2011 10:57 AM

in response to: ktanan

Answered

This page should help you out:

http://dev.mysql.com/doc/refman/5.0/en/set-password.html

ktanan

Posts: 2
Registered: 8/18/11

Re: How does one change an mySQL user's password?
Posted: Sep 1, 2011 7:39 PM

in response to: Mauritz

FYI ...It's work!!
-----
MYSQL
update user set password=PASSWORD("newpass") where User='dbUser';

FLUSH PRIVILEGES;

Oracle alter user Username identified by NewPassword Message was edited by: ktanan

Pages: 1

Back to Thread List

Threads: [ Previous | Next ]

Toad World