nixCraft
Linux / UNIX Tech Support Forum
MySQL - changing password
This is a discussion on MySQL - changing password within the Databases servers forums, part of the Mastering Servers category; Hi folks, I ran; Code: mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost' IDENTIFIED BY 'oldpassword'; creating password ...
|
|||||||
| Databases servers Discussions of databases of all types - especially MySQL. |
 |
|
|
LinkBack | Thread Tools | Display Modes |
21-10-2008, 05:06 PM
|
|||
|
|||
MySQL - changing password
Hi folks,
I ran; Code:
mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost' IDENTIFIED BY 'oldpassword'; Now I need changing its password whether to run; Code:
mysql> UPDATE user SET password=PASSWORD('newpassword') WHERE user="'mail_admin'@'localhost'";
TIA B.R. satimis 
|
| Sponsored Links | ||
|
|
|
03-03-2009, 02:01 AM
|
|||
|
|||
|
Password change
Dear
mail.* is mail=database name *=any table in mail database. Command is very right , what you are doing is changing password of the user who is having given permissions on this database and the anything else. Keep it up. Regards anil
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change root password MySQL 5 | chiku | Databases servers | 1 | 16-01-2007 08:46 PM |
| Mysql set root password howto | Databases servers | 1 | 04-01-2007 11:45 PM | |
| HP UX user lock password, change password, password aging | rockdalinux | HP-UX | 0 | 20-12-2006 02:36 PM |
| Changing password at first login. Linux | sbhupathireddy | Linux software | 1 | 05-07-2006 12:29 PM |
| changing dir | sparky | Shell scripting | 8 | 30-03-2006 03:14 AM |
All times are GMT +5.5. The time now is 04:19 PM.
