> For the complete documentation index, see [llms.txt](https://kb.chrisltd.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.chrisltd.com/cheat-sheets/mysql.md).

# MySQL

Login:`mysql -u USERNAME -pPASSWORD`

Dump:`mysqldump -u USERNAME -pPASSWORD DATABASENAME > DUMP.SQL`

Restore:`mysql -u USERNAME -pPASSWORD DATABASENAME < DUMP.SQL`

Add user:

```
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
```

List databases:`SHOW DATABASES;`

Add database:`CREATE DATABASE databasename;`

Use database:`USE databasename;`

Drop database:`DROP DATABASE databasename;`