Mysql Cheatsheet

mysql_cheatsheet.md

Use mysql CLI

mysql --user=my_username --password

Create a new user

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

Create new database and grant privilleges

CREATE DATABASE `db_name`;
GRANT ALL PRIVILEGES ON `db_name` . * TO 'username'@'localhost';

Reset password

SET password for 'username'@'localhost' = password('my_new_password');

Start mysql server without password request

Stop mysqld process

sudo mysqld_safe --skip-grant-tables &

Connect to mysql server from your root systemuser via socket (no password required)

sudo mysql --protocol=socket