Tema: kaip sukurti useri duombazei per mysql
Autorius: news.omnitel.net
Data: 2010-08-25 15:33:46
Sveiki,
dar esu zalias diletantas (ne profas) su mysql

gavau prisijungimus prie vienos duomenu bazes per phpmyadmin,
norejau sukurti username ir password tai bazei

CREATE USER michael IDENTIFIED BY PASSWORD 'mypassword123';

gavau error message:
#1227 - Access denied; you need the CREATE USER privilege for this operation


pabandziau kitaip:
GRANT ALL ON my_db.* TO 'my_user'@localhost IDENTIFIED BY 'my_pass';
#1044 - Access denied for user blablabla


ka ne taip darau?
aciu paciu