MYSQL cheat sheet

Explore :

SHOW DATABASES;
SHOW TABLES;

USE database;

DESCRIBE table;

CREATE DATABASE database;
DROP DATABASE database;

User:

CREATE USER 'user'@'localhost' IDENTIFIED BY 'pwd';
GRANT ALL PRIVILEGES ON database.* TO 'user'@'localhost' IDENTIFIED BY 'pwd';
FLUSH PRIVILEGES;

Import:

mysql -u username -p databasename < dump.sql

Export:

mysqldump -u username -p databasename > dump.sql

Update user password

Generate pwd: http://www.miraclesalad.com/webtools/md5.php

sudo mysql

SHOW DATABASES;
USE database;
SHOW TABLES;
DESCRIBE usertable;
SELECT ID, user_pass;
UPDATE usertable SET user_pass="md5-pwd" WHERE ID = id;

Sources:

• https://devhints.io/mysql
• https://wordpress.org/documentation/article/reset-your-password/