11 lines
315 B
SQL
11 lines
315 B
SQL
CREATE DATABASE drucklog;
|
|
CREATE USER IF NOT EXIST 'druckloguser'@'%' IDENTIFIED BY 'Test123#';
|
|
SELECT user, host FROM mysql.user;
|
|
GRANT ALL PRIVILEGES ON drucklog.* TO 'druckloguser'@'%';
|
|
FLUSH PRIVILEGES;
|
|
EXIT;
|
|
|
|
|
|
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'eprencs';
|
|
FLUSH PRIVILEGES;
|