... | ... | @@ -243,10 +243,9 @@ Neue Datenbank anlegen: |
|
|
|
|
|
```sql
|
|
|
$ mysql -u root -p
|
|
|
CREATE DATABASE db_user;
|
|
|
CREATE DATABASE database;
|
|
|
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'secret';
|
|
|
GRANT USAGE ON *.* to newuser@localhost IDENTIFIED BY 'secret';
|
|
|
GRANT ALL PRIVILEGES ON db_user.* TO newuser@localhost;
|
|
|
GRANT ALL PRIVILEGES ON database.* TO newuser@localhost;
|
|
|
```
|
|
|
|
|
|
# PHP
|
... | ... | |