On 7/20/05, A. Karim <[EMAIL PROTECTED]> wrote:
> On Wed, 20 Jul 2005, Arif Sulistiyo wrote:
>
> > Ya kalo saya mengira juga permision pak karim tapi kalau saya
> > menggunakan mysql_setpermision yang diatas keluar eror "[mysql][ODBC
> > 3.51 driver] access denied for user [EMAIL PROTECTED] (using
> > password=yes)". padahal password untuk mysql yang ada di server linux
> > sudah sesuai dan sudah dimasukkan.
> >
> >
> > Trims
>
> coba untuk meyakinkan saja, periksa hak user tersebut
> apa output dari :
>
> $mysql -uroot -p
> > show grants for [EMAIL PROTECTED];
>
> (apa outputnya?)
>
> atau dengan memeriksa langsung database mysql
> $ mysql -uroot -p
> > use mysql
> Database changed
> > select user,host,password from user;
>
> (apa outputnya?) benarkah user root diijinkan mengakses database dari
> host 192.168.8.10 ?
>
> *berikutnya ngereply dibawah saja, jgn di atas :-)
>
> --
> Duken
>
> --
> Unsubscribe: kirim email kosong ke [EMAIL PROTECTED]
> Arsip, FAQ, dan info milis di http://linux.or.id/milis
> Tidak bisa posting? Baca:
> http://linux.or.id/problemmilis
> http://linux.or.id/tatatertibmilis
>
>
Outputnya seperti ini pak
select * from user;
+--------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
Shutdown_priv | Process_priv | File_priv | Grant_priv |
References_priv | Index_priv | Alter_priv |
+--------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | root | 7a7eeba37575fe5e | Y | Y |
Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y |
Y | Y |
| himsya | root | | Y | Y |
Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y |
Y | Y |
| localhost | | | N | N |
N | N | N | N | N | N
| N | N | N | N |
N | N |
| himsya | | | N | N |
N | N | N | N | N | N
| N | N | N | N |
N | N |
| localhost | arif | | N | N |
N | N | N | N | N | N
| N | N | N | N |
N | N |
| 192.168.8.10 | root | | Y | Y |
Y | Y | Y | Y | N | N
| N | N | N | Y |
Y | Y |
| 192.168.8.10 | arif | 5d2e19393cc5ef67 | N | N |
N | N | N | N | N | N
| N | N | N | N |
N | N |
| serverlab | root | 7a7eeba37575fe5e | N | N |
N | N | N | N | N | N
| N | N | N | N |
N | N |
+--------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
8 rows in set (0.02 sec)
Trus Seandanya dengan grant maka otputnya seperti ini
show grants for [EMAIL PROTECTED];
+--------------------------------------------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED]
|
+--------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES,
INDEX, ALTER ON *.* TO 'root'@'192.168.8.10' |
| GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES, INDEX, ALTER ON
`diskusi`.* TO 'root'@'192.168.8.10' |
| GRANT ALL PRIVILEGES ON diskusi.diskusi TO 'root'@'192.168.8.10'
|
+--------------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)
--
Unsubscribe: kirim email kosong ke [EMAIL PROTECTED]
Arsip, FAQ, dan info milis di http://linux.or.id/milis
Tidak bisa posting? Baca:
http://linux.or.id/problemmilis
http://linux.or.id/tatatertibmilis
