Mysql: Difference between revisions
From AWVVO
Jump to navigationJump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== Installation == | |||
<syntaxhighlight lang="bash" copy line highlight="0"> | |||
sudo apt install mysql-server | |||
sudo systemctl start mysql | |||
sudo systemctl enable mysql | |||
sudo mysql_secure_installation | |||
sudo mysql | |||
</syntaxhighlight> | |||
== Create user == | == Create user == | ||
<syntaxhighlight lang="SQL" copy> | <syntaxhighlight lang="SQL" copy> | ||
| Line 28: | Line 38: | ||
| | | | ||
|} | |} | ||
== Show column names in database == | |||
<syntaxhighlight lang="SQL" copy> | |||
SELECT TABLE_NAME, COLUMN_NAME | |||
FROM INFORMATION_SCHEMA.COLUMNS | |||
WHERE TABLE_SCHEMA = 'SFC' | |||
ORDER BY TABLE_NAME, column_name | |||
</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
