- S
- M
- T
- W
- T
- F
- S
- 1
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
Notice:
- View my professional articles @ www.ecodereviewer.com.
Previous: Save the Developers ...
Next: Install PostgreSQL o...
MySQL Change Passwords
Posted By: Eric Lin
Category: Database
Tags: mysql
Posted Date: 2008-05-27 12:09 AM
No of Comments: 0
Clicks: 254
Category: Database
Tags: mysql
Posted Date: 2008-05-27 12:09 AM
No of Comments: 0
Clicks: 254
To set the root password for the first time:
To update the root password:
If you want to update root password using mysql command, login to mysql, then:
now you will need to update the privileges:
Change password for other users:
Enjoy MySQL.
$ mysqladmin -u root password NEWPASS
To update the root password:
$ mysqladmin -u root password OLDPASS NEWPASS
If you want to update root password using mysql command, login to mysql, then:
mysql> update user set password=PASSWORD("NEWPASSWORD") where User='username';
now you will need to update the privileges:
mysql> flush privileges;
Change password for other users:
$ mysqladmin -u username -p OLDPASS NEWPASS
Enjoy MySQL.
Previous: Save the Developers ...
Next: Install PostgreSQL o...