MySQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 30: | Line 30: | ||
DDL | DDL | ||
</syntaxhighlight> | </syntaxhighlight> | ||
|valign="top"| | |||
|} | |||
== References== | |||
{| | |||
|valign="top"| | |||
* [[MySQL/Dump]] | |||
* [[PostgreSQL]] | |||
|valign="top"| | |||
|valign="top"| | |||
|- | |||
|colspan="3"| | |||
---- | |||
|- | |||
|valign="top"| | |||
|valign="top"| | |||
|valign="top"| | |valign="top"| | ||
|} | |} | ||
Revision as of 21:18, 31 March 2024
|
MySQL » Auth » Unix sudo su
cat << DDL | mysql
CREATE USER 'chorke'@'localhost' IDENTIFIED VIA unix_socket;
GRANT ALL PRIVILEGES ON *.* TO 'chorke'@'localhost' WITH GRANT OPTION;
DDL
|
MySQL » Auth » Local cat << DDL | mysql
CREATE DATABASE IF NOT EXISTS chorke_orgwiki;
CREATE USER 'chorke_orgwiki'@'localhost' IDENTIFIED BY 'sadaqah!';
GRANT ALL PRIVILEGES ON chorke_orgwiki.* TO 'chorke_orgwiki'@'localhost';
DDL
|
|
MySQL » Auth » Remote cat << DDL | mysql
CREATE DATABASE IF NOT EXISTS chorke_orgwiki;
CREATE USER 'chorke_orgwiki'@'%' IDENTIFIED BY 'sadaqah!';
GRANT ALL PRIVILEGES ON chorke_orgwiki.* TO 'chorke_orgwiki'@'%';
DDL
|
References
|
| ||