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