mysql -u root -p
create database MYDATABASENAME;
create user 'MYUSERNAME'@'localhost' identified by 'MYPASSWORD';
grant all privileges on MYDATABASENAME.* to 'MYUSERNAME'@'localhost' with grant option;
flush privileges;
quit
mysql -u root -p
create database MYDATABASENAME;
create user 'MYUSERNAME'@'localhost' identified by 'MYPASSWORD';
grant all privileges on MYDATABASENAME.* to 'MYUSERNAME'@'localhost' with grant option;
flush privileges;
quit
2 Antworten zu “mysql snippet”
flush privileges;
nach dem grant nicht vergessen, sonst suchst Du Dich wund warum es trotzdem nicht geht.
natuerlich :-S … danke thomas! :-)