Differences

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

--- mysql:general [17/02/2025 17:42] – [Rename Column] andrew
+++ mysql:general [01/08/2025 14:01] (current) – [Run scheduled tasks] andrew
@@ Line 382: / Line 382: @@
 <code mysql>
 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>
@@ Line 703: / Line 707: @@
+**Note:-**
+When the name ends in _ci, the collation is case-insensitive.