Linux, FreeBSD, Juniper, Cisco / Network security articles and troubleshooting guides

It is currently Fri Oct 18, 2019 5:20 am

Post a reply :: Mysql change root password
Message body:
Enter your message here, it may contain no more than 60000 characters. 

:D :) ;) :( :o :shock: :? 8-) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :!: :?: :idea: :arrow: :| :mrgreen: :geek: :ugeek:
Font size:
Font colour
BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON
Disable BBCode
Disable smilies
Do not automatically parse URLs
Confirmation code
Confirmation code:
In an effort to prevent automatic submissions, we require that you enter both of the words displayed into the text field underneath.

Topic review - Mysql change root password
Author Message
Post subject: Mysql change root password  |  Post Posted: Tue Feb 10, 2015 6:50 pm
Mysql administrator account is the "root" account. As in Linux this account has all privileges, writing and reading all the databases in MySql server, changing running parameters of the server and so on. It is a security safeguard to keep this password as long and complex as possible (to include upper and lower characters, digits and SHIFT+Numerical keys.

Changing MySql root account password:

To change mysql root password, use administrator account, usually root, and run the following queries:
mysql> update mysql.user set password=password(’NEW PASSWORD’) where user=‘root’;
mysql> flush privileges;

The first mysql query will update the password field in the "user" table in "mysql" database belonging to "root" row and the second query will make the mysql server aware of the change immediately, instead of restarting the server.
Jump to:  
News News Site map Site map SitemapIndex SitemapIndex RSS Feed RSS Feed Channel list Channel list

Delete all board cookies | The team | All times are UTC - 5 hours [ DST ]