Assalamu'alaikum,....
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.....
/*---Pungki---*/
--
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
