by
~Syed JAHANZAIB~
Short References for Mysql Passwords related issues:
To setup root password for first time (default is no password), use mysqladmin command at shell prompt as follows:
mysqladmin -u root password NEWPASSWORD
Mysqladmin command to change old password (if you already know the old one)
However, if you want to change (or update) a root password, then you need to use following command
mysqladmin -u root -p'oldpassword' password newpass
For example, If old password is abc, and we will set it to new password 123456, enter:
mysqladmin -u root -p'abc' password '123456'
SET PASSWORD FOR 'radius'@'localhost' = PASSWORD('NEWPASS');
SET PASSWORD FOR 'conntrack'@'localhost' = PASSWORD('NEWPASS');
If you dont know the old mysql ROOT password and want to reset it, follow these steps !
If you’d like to automate this process you could start by looking at this simple shell script which will allow you to reset a password with one command.
sudo service mysql start
cd /var/run
sudo cp -rp ./mysqld ./mysqld.bak
sudo service mysql stop
sudo mv ./mysqld.bak ./mysqld
sudo mysqld_safe --skip-grant-tables --skip-networking &
mysql -u root
FLUSH PRIVILEGES;
SET PASSWORD FOR root@'localhost' = PASSWORD('my_new_password');
Change MYSQL Root ID password (old password to new)
mysql -u root -pROOTPASSWORD
use mysql;
update user set password=PASSWORD('MYNEWPASSWORD') where User='root';
flush privileges;
use mysql;
SET PASSWORD FOR 'radius'@'localhost' = PASSWORD('MYNEWPASSWORD');
=====================================
/etc/radiusmanager.cfg /var/www/radiusmanager/config/system_cfg.php /usr/local/etc/raddb/sql.conf
Short notes on how I changed empty mysql empty root password
UPDATE mysql.user SET authentication_string= '' WHERE User='root';
UPDATE mysql.user SET plugin = '' WHERE user = 'root';
UPDATE mysql.user SET authentication_string=PASSWORD('mynewpassword') WHERE User='root';
UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root';
service mysql restart
Jz
If the event tracker is of no use to you then you can disable it. To do this, open the Group Policy Object Editor Console.
Go to Start > Run…, type gpedit.msc and press OK.
Navigate to Computer Configuration > Administrative Templates > System and in the right hand pane, select the “Display Shutdown Event Tracker” setting.
Double Click this setting to open the Properties page. You are now given the option to leave it in a default state of Not Configured, set it to Always Enabled, Enabled for Servers/Workstations (Windows XP Pro) or Disabled completely (as the image below demonstrates).
Note:
When you enable the Group Policy for Server only, the Shutdown Event Tracker appears when you shut down a computer running Windows 2003, whereas for Workstation only, the Shutdown Event Tracker appears when a computer running Windows XP Professional is shut down.
After you make the change to the Group Policy, open the Command Prompt and run the gpupdate /force command to refresh the policy and have your settings be applied straight away. Alternatively you can just restart the machine.
When you next attempt to shutdown or restart the machine, the Shutdown event tracker will no longer be visible and the normal shutdown prompt will appear (as seen in the image below).
Syed Jahanzaib - Personal Blog to Share Knowledge ! 