>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)
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.
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
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'
Bingung nih, mau diapain lagi. Atau saya salah menterjemahkan mysql.info
diatas ?
Makasih banyak lho bantuannya....
/*---Pungki---*/
>Pesan:
>Access denied for user: 'root@localhost' (Using password: NO
>menunjukkan bahwa anda harus memasukkan password, dengan perameter -p
Makasih banyak, dengan option ini, saya bisa melihat :
Server version 3.23.33
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 hour 10 min 21 sec
Threads: 1 Questions: 114 Slow queries: 0 Opens: 57 Flush tables: 1
Open
tables: 6 Queries per second avg: 0.027
--
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
