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

# MySQL

## Log In

```
mysql -u root -p -P 3306 -h <IP>
```

## Databases

```
show databases;
use database1;
```

## Tables

```
show tables;
```

## Info

```
select * from table1;
```

## Update Info

```
update users set adm="yes" where username="exampleuser";
```