Mysql
From AWVVO
Installation
sudo apt install mysql-server
sudo systemctl start mysql
sudo systemctl enable mysql
sudo mysql_secure_installation
sudo mysql
Create user
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'host';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'newuser'@'localhost';
| show version | mysql -V | ||
|---|---|---|---|
Show column names in database
SELECT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'SFC'
ORDER BY TABLE_NAME, column_name
