On Thu, Nov 30, 2006 at 09:43:08AM +0800, rednux wrote:
> bagaimana cara input ip address/hostname agar host tersebut bisa
> access mysql server ??
> saya coba menggunakan dibawah ini tetap tdk bisa :
>
> insert into host(host,db,Select_priv, Insert_priv,
> Update_priv,Delete_priv, Create_priv, Drop_priv)
> values('192.168.0.174','%','Y','Y','Y','Y','Y','Y');
>
> insert into user (host, user, password)
> values('192.168.0.174','client',password('mypassword'));Tidak dianjurkan ngutak-atik table2nya secara manual. http://dev.mysql.com/doc/refman/5.0/en/adding-users.html Jangan lupa 'flush privileges' kalo abis grant/revoke. Contoh: grant all privileges on namadb.* to 'penggunanamadb'@'192.168.0.174' identified by 'mypassword'; grant all privileges on *.* to 'semuadbbisa'@'192.168.0.174' identified by 'mypassword'; flush privileges; Ronny
signature.asc
Description: Digital signature
