MYSQL(oh)			     LOCAL			     MYSQL(oh)

MySQL - usage and tips

COMMANDS
     show databases;
     show tables;
     show tables like '%pattern%'

USERS
     CREATE DATABASE db_name;
     CREATE USER 'username'@'localhost' IDENTIFIED BY 'new_password' PASSWORD EXPIRE;
     mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
     ->	  ON db_name.*
     ->	  TO 'username'@'localhost';

EXECUTE
     Executing commands on mysql from a file.
	   $ cat FILE | sudo mysql

READ
     Use a SQL file to update database.
	   $ sudo mysql DATABASE < FILE.sql

BACKUP
     Backup a database:
	   # mysqldump -p DATABASE > FILE.sql
     The argument -p specifies a password, if not given, mysqldump prompts the
     user to enter a password.

   Compress backup
	   # mysqldump DATABASE | gzip > FILE.sql.gz

TIMEZONES
     Adding timezones to mysql:
	   $ mysql_tzinfo_to_sql /usr/share/zoneinfo | sudo mysql mysql

SEE ALSO
     sql(oh)

     - Archlinux manpages: mysql(1)

   links
     - MySQL: https://dev.mysql.com/
     - MySQL - CREATE USER:
     https://dev.mysql.com/doc/refman/8.4/en/create-user.html

AUTHORS
     ohazot(oh) | about(oh) | ohazot.com: https://ohazot.com
     <admin@ohazot.com>

linux , OpenBSD 7.8 |
		    Created:2026-03-24|Updated:2026-03-25|	     MYSQL(oh)