User Tools

Site Tools


mysql:general

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
mysql:general [17/02/2025 17:42] – [Rename Column] andrewmysql:general [03/07/2025 14:31] (current) – [Update user's password] andrew
Line 382: Line 382:
 <code mysql> <code mysql>
 mysql> UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE USER='user-name-here' AND Host='host-name-here'; mysql> UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE USER='user-name-here' AND Host='host-name-here';
 +</code>
 +
 +<code sql >
 +ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword';
 </code> </code>
  
mysql/general.txt · Last modified: by andrew

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki