MariaDB: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Geist (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „===== INIT SECURE DB ===== '''$ mysql_secure_installation''' ===== CREATE NEW USER|GRANT ALL PRIVILEGES ===== '''mysql> CREATE USER 'newuser'@'localhost' I…“) |
Geist (Diskussion | Beiträge) |
||
| Zeile 4: | Zeile 4: | ||
===== CREATE NEW USER|GRANT ALL PRIVILEGES ===== | ===== CREATE NEW USER|GRANT ALL PRIVILEGES ===== | ||
| + | '''mysql> CREATE USER 'newuser'@'%' IDENTIFIED BY 'password'; ''' | ||
| + | '''mysql> CREATE USER 'newuser'@'[IP|DOMAIN]' IDENTIFIED BY 'password'; ''' | ||
'''mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; ''' | '''mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; ''' | ||
| + | |||
'''mysql> GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';''' | '''mysql> GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';''' | ||
'''mysql> FLUSH PRIVILEGES;''' | '''mysql> FLUSH PRIVILEGES;''' | ||
Version vom 7. April 2022, 15:54 Uhr
INIT SECURE DB
$ mysql_secure_installation
CREATE NEW USER|GRANT ALL PRIVILEGES
mysql> CREATE USER 'newuser'@'%' IDENTIFIED BY 'password'; mysql> CREATE USER 'newuser'@'[IP|DOMAIN]' IDENTIFIED BY 'password'; mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost'; mysql> FLUSH PRIVILEGES;