# Name Description
1 Activate MySQL to be used in the network. Edit file /etc/my.cnf
Indicate comment to the line: skip-networking
2 Create database create database NAME
3 Assign user permit to access the system from anywhere. use mysql
update user set host='%' where user='root'
Assign password: update user set password=password('PASSWORD') where user='root'
flush privileges
4 Delete database drop database NAME
5 Data location /var/lib/mysql/
6 View databases show databases
7 View tables show tables
UTILITY QUERY TO SETUP
To execute a command copy to the clipboard (CTRL-C), then on the terminal screen press right button to paste
USER LIST
use mysql;
select user,password,host from user;
OPEN USER PRIVILEGES
update user set
Select_priv='Y', Insert_priv='Y', Update_priv='Y', Delete_priv='Y', Create_priv='Y', Drop_priv='Y', Reload_priv='Y', Shutdown_priv='Y',
Process_priv='Y', File_priv='Y', Grant_priv='Y', References_priv='Y', Index_priv='Y', Alter_priv='Y', Show_db_priv='Y',
Super_priv='Y', Create_tmp_table_priv='Y', Lock_tables_priv='Y', Execute_priv='Y', Repl_slave_priv='Y', Repl_client_priv='Y',
ssl_type='Y', ssl_cipher='Y', x509_issuer='Y', x509_subject='Y', max_questions=0, max_updates=0, max_connections=0
where user=
'USERID'