Mysql: Difference between revisions
From AWVVO
Jump to navigationJump to search
| Line 5: | Line 5: | ||
sudo systemctl enable mysql | sudo systemctl enable mysql | ||
sudo mysql_secure_installation | sudo mysql_secure_installation | ||
sudo mysql | |||
</syntaxhighlight> | </syntaxhighlight> | ||
Latest revision as of 18:11, 28 March 2025
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
