On Thu, 26 Jul 2001, pungki wrote:
> >supaya bisa connect dari host lain, mesti diberikan hak akses dulu, dengan
> >perintah (misal)
> >GRANT ALL PRIVILEGES on *.* to user@host identified by 'password'
>
> Saya masuk mysql, lalu :
>
> mysql> select host,user,password from user;
> +-----------+------+------------------+
> | host | user | password |
> +-----------+------+------------------+
> | localhost | root | 3929dbf115e91843 |
> | cindy | root | 3929dbf115e91843 |
> +-----------+------+------------------+
> 2 rows in set (0.00 sec)
>
emm, mungkin perlu di set dns resolve nya dengan bener, mungkin domain
searchnya mesti bener, atau paling nggak di /etc/hosts nya udah
ditambahin.
> mysql> grant all privileges on *.* to root@cindy identified by 'coba-coba';
> Query OK, 0 rows affected (0.00 sec)
>
> Tapi kok 0 row affected yah ? Kalo pake perintah flush privileges, juga 0
> row
> affected.
biasanya emang gitu.
>
> Kalo :
> bash-2.04# ./mysqladmin -h cindy version -p
> ./mysqladmin: connect to server at 'cindy' failed
> error: 'Host 'cindy.anakgaul.com' is not allowed to connect to this MySQL
> server'
>
> bash-2.04# ./mysql -h cindy -u root -p
> ERROR 1130: Host 'cindy.anakgaul.com' is not allowed to connect to this
> MySQL
> server
coba aja grant pivileges nya untuk [EMAIL PROTECTED]
root@<ip-address> atau root@'%'
>
> Lalu saya baca di mysql.info :
>
> Host ... is not allowed to connect to this MySQL server
>
> You can fix this by using the command-line tool `mysql' (on the
> server host!) to add a row to the `user', `db', or `host' table
> for the user/hostname combination from which you are trying to
> connect and then execute `mysqladmin flush-privileges'.
>
> Saya lihat,di tabel user udah ada cindy. Tapi kemudian saya hapus :
> mysql> delete from user where host='cindy';
> Query OK, 1 row affected (0.00 sec)
>
> Kemudian :
> mysql > insert into user
> values('cindy','root',password('nidaimut'),'Y','Y','Y','Y','Y','N','N','N','
> Y','Y','N','Y','Y','Y');
> Query OK, 1 row affected (0.00 sec)
>
> Lalu :
>
> bash-2.04# ./mysqladmin flush-privileges -p
> Enter password:
> bash-2.04#
>
> Tapi kalo jalainin :
> bash-2.04# ./mysqladmin -h cindy version -p
> error-nya masih sama.
> ./mysqladmin: connect to server at 'cindy' failed
> error: 'Host 'cindy.anakgaul.com' is not allowed to connect to this MySQL
> server'
oooi, usernya siapa? pakai parameter -u dong.
--
Utk berhenti langganan, kirim email ke [EMAIL PROTECTED]
Dapatkan FAQ milis dg mengirim email kosong ke [EMAIL PROTECTED]
Informasi arsip di http://www.linux.or.id/milis.php3
