Monat: Mai 2020

Datenbank und Nutzer unter mysql anlegen

Jens Appel 
CREATE DATABASE 'testdb';
DROP DATABASE 'testdb';
GRANT CREATE,INSERT,DELETE,UPDATE,DROP,ALTER,SELECT on testdb.* to \
      testuser@dione.home.leppa.de IDENTIFIED BY 'PASSWORT';
DELETE FROM mysql.user WHERE USER='testuser';
FLUSH PRIVILEGES;

show grants for 'testuser'@'dione.home.leppa.de';
describe user;
select user,host,authentication_string,plugin from user;