|
 | 作者: rufus1980 [rufus1980]
 论坛用户 |
登录 |
| 我的电脑网卡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不能从其他机器登陆，是什么问题呀，我没有对用户做任何限制。奇怪。 |
| 地主 发表时间: 07/17 19:16 |
|
20CN网络安全小组版权所有
Copyright © 2000-2010 20CN Security Group. All Rights Reserved.
论坛程序编写：NetDemon
粤ICP备05087286号
论坛: UNIX系统 标题: 我装mysql遇到的问题，请高手解决