由 冰魂 在 07-17-2003 19:09 发表:
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: '[email protected]' (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 My