On Wed, 25 Jul 2001, pungki wrote:
> Assalamu'alaikum,....
waalaikum salam
>
> Saya install mysql 3.23.33. Terus ada beberapa error waktu jalanin :
>
> root@cindy:~# /usr/local/mysql/bin/mysqladmin -h cindy version variables
> /usr/local/mysql/bin/mysqladmin: connect to server at 'cindy' failed
> error: 'Host 'cindy.anakgaul.com' is not allowed to connect to this MySQL
> server'
>
> Lalu :
>
> Script started on Wed Jul 25 09:13:59 2001
> root@cindy:~# /usr/local/mysql/bin/mysqadmin -h 192.168.1.22 version
> /usr/local/mysql/bin/mysqladmin: connect to server at '192.168.1.22' failed
> error: 'Host 'cindy.anakgaul.com' is not allowed to connect to this MySQL
> server'
>
> Lalu :
>
> root@cindy:~# /usr/local/bin/mysql/bin/mysqladmin --socket=/tmp/mysql.sock
> version
> /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
>
> Kalo saya baca di mysql.info bagian can't connect to [local]....., dia
> bilang socketnya biasanya ada di /tmp/mysqld.sock. Nah, kalo di saya adanya
> /tmp/mysql.sock= , besarnya 0 (saya pake slack 7.1). Jalanin server
> mysqldnya pake :
> # safe_mysqld --user=mysql &
>
>
> Dan kalo di telnet :
>
> root@cindy:~# telnet cindy 3306
> Trying 192.168.1.22...
> Connected to cindy.anakgaul.com.
> Escape character is '^]'.
> Host 'cindy.anakgaul.com' is not allowed to connect to this MySQL
> serverConnection closed by foreign host.
>
>
> Tapi kalo saya ps ax :
>
> root@cindy:~# ps ax|grep mysql
> 123 tty1 S 0:00 sh /usr/local/mysql/bin/safe_mysqld --user=mysql
> 139 tty1 S 0:00
> /usr/local/mysql/libexec/mysqld --basedir=/usr/local/
> 141 tty1 S 0:00
> /usr/local/mysql/libexec/mysqld --basedir=/usr/local/
> 142 tty1 S 0:00
> /usr/local/mysql/libexec/mysqld --basedir=/usr/local/
> 236 pts/1 S 0:00 grep mysql
>
>
> Kira-kira gimana nih benerinnya ? Oh iya...kalo :
>
> # mysql -u root -p
> Enter passwrod :
>
> Berhasil masuk mysql monitor.
>
> Makasih banyak yah.....
>
file mysql.sock memang besarnya 0, file nya ada kalau mysql daemonnya
jalan.
supaya bisa connect dari host lain, mesti diberikan hak akses dulu, dengan
perintah (misal)
GRANT ALL PRIVILEGES on *.* to user@host identified by 'password'
Pesan:
Access denied for user: 'root@localhost' (Using password: NO
menunjukkan bahwa anda harus memasukkan password, dengan perameter -p
baca manual di bagian mysql privileges dengan teliti.
--
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
