update, identidied menjadi identified

grant all privileges on *.* to 'sysadmin'@'localhost' identified by
'password';

harusnya perintah diatas hanya untuk root

2008/11/10 Muhamad Yamin <[EMAIL PROTECTED]>

> nama usernya sysadmin ? sudah di buat belum user sysadminnnya ? kalau belum
> di buat dulu dan beri akses user
>
> grant all privileges on *.* to 'sysadmin'@'localhost' identidied by
> 'password';
>
>
> 2008/11/10 Dodo <[EMAIL PROTECTED]>
>
>>  kirman wrote:
>>
>> Kalau tidak salah, user defaultnya adalah root and passwd : [kosong],
>> bukan sysadmin
>>
>> Jika mau setting password, saya memiliki pengalaman tentang hal itu,
>> barangkali kalau berkenan bisa mampir kesini mas
>>
>> http://kirmann.wordpress.com/2008/03/15/set-password-xampp-di-linux/
>>
>> 2008/11/10 Dodo <[EMAIL PROTECTED]>
>>
>>> *Dear All
>>>
>>> *Saya mau migrasi database dari WIndows ke Linux deangan Xampp.
>>> Setelah semua terinstall dan saya coba jalankan dengan memasukan username
>>> "sysadmin" tapi tampil message error seperti dibawah ini :*
>>>
>>> Warning*: mysql_connect() 
>>> [function.mysql-connect<http://192.168.1.3/cpm/function.mysql-connect>]:
>>> Access denied for user 'sysadmin'@'localhost' (using password: YES) in *
>>> /opt/lampp/htdocs/cpm/includes/ConnectDB_mysql.inc* on line *5*
>>>
>>> The configuration in the file config.php for the database user name and
>>> password do not provide the information required to connect to the database
>>> server
>>>
>>> Kira2 kenapa ya or salah dimana ? Mohon pencerahanya
>>>
>>>
>>>  Terima kasih atas response-nya.
>>
>> Kalo untuk password itu saya sudah tau, tapi saat saya masuk ke database
>> user dianggap tidak ada dan  tampil message error seperti di atas
>>
>>
>>  ------------------------------
>>
>> _______________________________________________
>> milis mailing [EMAIL 
>> PROTECTED]://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org
>>
>>
>>
>> _______________________________________________
>> milis mailing list
>> [email protected]
>> http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org
>>
>>
>
_______________________________________________
milis mailing list
[email protected]
http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org

Kirim email ke