Differences

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

--- mysql:general [04/10/2023 10:49] – created - external edit 127.0.0.1
+++ mysql:general [01/08/2025 14:01] (current) – [Run scheduled tasks] andrew
@@ Line 273: / Line 273: @@
   ALTER TABLE tableName CHANGE oldcolname newcolname datatype(length);
-  > ALTER TABLE sai_password CHANGE user_id  lowside_user_id varchar(255);
+  > ALTER TABLE password CHANGE user_id  username_id varchar(255);
@@ 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.