Difference between revisions of "Setting the root password"

From MyWiki
Jump to: navigation, search
(Created page with "<source lang="sql"> mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass') -> WHERE User='root'; mysql> FLUSH PRIVILEGES; </source>")
 
Line 1: Line 1:
<source lang="sql">
+
<source lang="text">
 
mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
 
mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
 
     ->                  WHERE User='root';
 
     ->                  WHERE User='root';
 
mysql> FLUSH PRIVILEGES;
 
mysql> FLUSH PRIVILEGES;
 
</source>
 
</source>

Revision as of 17:48, 25 October 2014

mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
    ->                   WHERE User='root';
mysql> FLUSH PRIVILEGES;