Mysql:
MySQL is most commonly used for Web applications and for embedded applications and has become a popular alternative to proprietary database systems because of its speed and reliability. MySQL can run on LINUX, Windows and Mac OS.
i). Setting Mysql Root Password:
Use Mysqladmin command to set new password as shown below.
ii). Change Mysql Root Password:
If you want to change (or update) a root password, then you need to use the following command:
# mysqladmin -u root -p'bsrtech' password 'mahesh'
iii). Resetting MySQL Root Password:
MySQL is most commonly used for Web applications and for embedded applications and has become a popular alternative to proprietary database systems because of its speed and reliability. MySQL can run on LINUX, Windows and Mac OS.
i). Setting Mysql Root Password:
Use Mysqladmin command to set new password as shown below.
# mysqladmin -u root password newpassword
ii). Change Mysql Root Password:
If you want to change (or update) a root password, then you need to use the following command:
# mysqladmin -u root -p'oldpassword' password 'newpass'For Example old password is "bsrtech" , now you can set the new password is " mahesh "
# mysqladmin -u root -p'bsrtech' password 'mahesh'
iii). Resetting MySQL Root Password:
If u have forgot mysql password in centos or redhat , how to change password steps given below..
Step1: Stop MySQL:
Step5: Log out of MySQL and stop the Safe Mode:
Step6: Start MySQL in the normal mode:
Step7: Log into MySQL with your new password:
Step1: Stop MySQL:
# service mysqld stopStep2: Start MySQL in safe mode:
# mysqld_safe --skip-grant-tables &Step3: Log into MySQL as root:
# mysql -u rootStep4: Reset the password:
mysql> update mysql.user set password=PASSWORD("your new password") where User='root';
mysql> flush privileges;
mysql> exit;
Step5: Log out of MySQL and stop the Safe Mode:
# service mysqld stop
Step6: Start MySQL in the normal mode:
# service mysqld start
Step7: Log into MySQL with your new password:
# mysql -u root -p
Enter password:
mysql>
Thx very much. It was very helpful =)
ReplyDeleteThank you! This was the best one that actually worked!!!
ReplyDelete