Tema: Re: kaip sukurti useri duombazei per mysql
Autorius: news.omnitel.net
Data: 2010-08-25 15:46:58
tai sita suvokiu..
tas teises, kaip suprantu, phpmyadmine niekaip nepasiadministruosiu?
reikia eiti per serverio valdymo paneli, kad man duotu visas teises tam
useriui (su kuriuo uzejau i phpmyadmin)?
"VaidasB" <vaidasTrinti@pmbalticTrinti.lt> wrote in message
news:i5334m$uvb$1@trimpas.omnitel.net...
> nu tai elementoriskai - neturi teisiu kurt naujam useriui :)
>
> On 2010.08.25 15:33, news.omnitel.net wrote:
>> 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
>>
>>