User Tools

Site Tools


mysql:change_passwords

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
mysql:change_passwords [2016/10/13 23:01] – created petermysql:change_passwords [2020/07/15 09:30] (current) – external edit 127.0.0.1
Line 8: Line 8:
 mysql> flush privileges; mysql> flush privileges;
 </code> </code>
 +
 +You may accomplish the same task with mysqladmin MySQL command.
 +
 +<code bash>
 +$ mysqladmin -u root password 'new-password'
 +</code>
 +
 +If you wish to change existing root password, you'll use the following command instead. When entered, you'll be prompted for current root password.
 +
 +<code bash>
 +$ mysqladmin -u root -p password 'new-password'
 +</code>
 +
 +**NOTE**:  You do not have to run "flush privileges" MySQL command to reload the privileges when you use "mysqladmin" command.
 +
 +
 +
 +
mysql/change_passwords.1476399690.txt.gz · Last modified: 2020/07/15 09:30 (external edit)

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki