====== mysql ======
===== Add a user =====
[[https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql|source]]
<sxh sql>
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
</sxh>
===== Grant multiple permissions =====
<sxh>
GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’;
</sxh>
===== Revoke permissions =====
<sxh>
REVOKE [type of permission] ON [database name].[table name] FROM ‘[username]’@‘localhost’
</sxh>
===== Delete user =====
<sxh sql>
DROP USER ‘demo’@‘localhost’;
</sxh>
===== table size =====
<sxh sql>
SELECT table_schema,round(sum(data_length+index_length)/1024/1024,4) FROM information_schema.tables WHERE table_schema = 'beta_grid' AND table_name = 'assets';
</sxh>
===== user config file =====
in ~/.my.cnf

<sxh ini>
[client]
host     = localhost
user     = myusername
password = mypassword
socket   = /var/run/mysqld/mysqld.sock
 
[mysqld]
# Performance settings used for import.
delay_key_write=ALL
bulk_insert_buffer_size=256M
</sxh>
{{tag>cli mysql}}