| | MySQL change user password
mysqladmin -u root password [newpassword]
mysqladmin -u root -p [oldpassword] [newpassword]
- or -
mysql -u root -p
mysql> use mysql;
mysql> update user set password=PASSWORD("NEWPASSWORD") where user='root';
mysql> flush privileges;
mysql> quit
| | More...
10/30/08 | | | | |
|
| | Delete MySQL user
To remove a MySQL user account run this command:
mysql> drop user [username];
Dropping user will not disconnect an active database session, it will take effect after the user disconnects. | | More...
10/19/06 | | | | |
|
| | Create new MySQL user account
The command below will create MySQL user called 'testuser' on localhost with all privileges for database called 'testdb' and with password 'mypassword'. Connect to the server with mysql and run command:
grant all on testdb.* to testuser@localhost identified by 'mypassword';
| |  
More...
10/17/06 | | | | |
|
|
