deutsch

Create DB user with own DBs

mysql -u root -p mysql
create user USER@'IP';
set password for USER@'IP' = password('PASSWORD');
revoke all privileges ON *.* FROM 'USER'@'IP';
create database NAME_testing;
grant all privileges on NAME_testing.* to USER@'IP';
flush privileges;
show grants for USER@'IP';

Was used for a Magento installation