Differences

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

--- mysql_usercreate [2015/04/02 21:52] – created luke7858
+++ mysql_usercreate [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 2: / Line 2: @@
 <sxh bash>CREATE USER 'luke'@'x.x.x.x' IDENTIFIED BY 'testpassword';</sxh>
+Use % for wildcard host. Accessible from any locations. E.g
+<sxh bash>CREATE USER 'luke'@'%' IDENTIFIED BY 'testpassword';</sxh>
+\\
 === Setting user password ===
 <sxh bash>SET PASSWORD FOR 'root'@'localhost'</sxh>
+\\
 === Deleting a user ===
 <sxh bash>drop user 'luke'@'x.x.x.x';</sxh>
+\\
+\\
+=== Checking MySQL Password ===
+Sometimes you forget the password for a user.
+This is annoying as hell. You have a list of old passwords but you are able to log in as root
+You can use the following to confirm if the password is correct:
+<sxh bash>
+mysql> select if(password('randompassword')=password, 'YES', 'NO') from mysql.user where user='lukeslinux';
++-----------------------------------------------------+
+| if(password('randompassword')=password, 'YES', 'NO') |
++-----------------------------------------------------+
+| YES                                                 |
++-----------------------------------------------------+
+row in set (0.00 sec)
+</sxh>