MySQL Cheatsheet

Whether you’re new to MySQL or an experienced user, this guide will provide you with the essential commands to make your work more efficient and productive. I’ll update this command list from time to time.

User Management

@'%' -> external access allowed
@'localhost' -> only access on the machine

List users

select * from mysql.user

Create user

CREATE USER 'user_name'@'%' IDENTIFIED BY 'my_password';