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 snippet
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 |
flush privileges;
nach dem grant nicht vergessen, sonst suchst Du Dich wund warum es trotzdem nicht geht.
natuerlich :-S … danke thomas! :-)