mysql问题，麻烦高手解决

冰魂

我的电脑网卡IP为192.168.1.110
1.root用户登陆
==============================================
[root@localhost bin]# /usr/local/mysql/bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.52-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
Bye
[root@localhost bin]#
==============================================
[root@localhost bin]# /usr/local/mysql/bin/mysql -h localhost -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.52-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
Bye
[root@localhost bin]#
==============================================
[root@localhost bin]# /usr/local/mysql/bin/mysql -h 127.0.0.1 -u root -p
Enter password:
ERROR 1045: Access denied for user: 'root@localhost.localdomain' (Using password: YES)
[root@localhost bin]#
=============================================
[root@localhost bin]# /usr/local/mysql/bin/mysql -h 192.168.1.110 -u root -p
Enter password:
/usr/local/mysql/bin/safe_mysqld: line 273:  5895 Segmentation fault      $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1

Number of processes running now: 1
ERROR 2013: Lost connection to MySQL server during query
mysqld process hanging, pid 5898 - killed
[root@localhost bin]# 030718 02:59:04  mysqld restarted

[root@localhost bin]#
==============================================
2,mysql用户登陆
==============================================
[root@localhost bin]# /usr/local/mysql/bin/mysql -u mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.52-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
Bye
[root@localhost bin]#
=============================================
[root@localhost bin]# /usr/local/mysql/bin/mysql -h localhost -u mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.52-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
Bye
[root@localhost bin]#
=============================================
[root@localhost bin]# /usr/local/mysql/bin/mysql -h 127.0.0.1 -u mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.52-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
Bye
[root@localhost bin]#
===========================================
[root@localhost bin]# /usr/local/mysql/bin/mysql -h 192.168.1.110 -u mysql -p
Enter password:
/usr/local/mysql/bin/safe_mysqld: line 273:  5895 Segmentation fault      $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1

Number of processes running now: 1
ERROR 2013: Lost connection to MySQL server during query
mysqld process hanging, pid 5898 - killed
[root@localhost bin]# 030718 02:59:04  mysqld restarted

[root@localhost bin]#
===============================================
比较发现，我的MYSQL不能从其他机器登陆，是什么问题呀，我没有对用户做任何限制。奇怪。