|
各位兄长:
近日遇到一个棘手问题,三天三夜未搞定,请过路大仙指导一二!
本人新安装了RedHat AS 3,将系统的mysql3.23卸了, rpm -e mysql --nodeps , 然后下载了最新的MySQL-server-5.0.0-0.i386.rpm和MySQL-client-5.0.0-0.i386.rpm安装,过程还算顺利; 不过rpm -q mysql-server和rpm -q mysql-client的时候反应package mysql-server is not installed.此为一怪!
接着mysqladmin -u root -p password '123456' ,成功; 但mysql -u root -p ,输入密码后提示
-----------------------------------------------------------
[root@firebird mysql]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12 to server version: 5.0.0-alpha-standard-log
段错误
[root@firebird mysql]#
-----------------------------------------------------------
十分怪异!
在输入命令mysqladmin -u root -p version后,却能正常返回值;
--------------------------------------------------
[root@firebird mysql]# mysqladmin -u root -p version
Enter password:
mysqladmin Ver 8.40 Distrib 5.0.0-alpha, for pc-linux on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.0-alpha-standard-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 23 min 25 sec
Threads: 1 Questions: 28 Slow queries: 0 Opens: 17 Flush tables: 1 Open tables: 11 Queries per second avg: 0.020
------------------------------------------------
为什么就不能直接登陆到 mysql> 呢?
另外,本人修改过/etc/my.cnf文件,内容如下:------------------------------
[client]
#password = my_password
port = 3306
socket = /tmp/mysql.sock
[mysqld_safe]
socket = /tmp/mysql.sock
nice = -5
[mysqld]
user = mysql
pid-file = /var/lib/mysql/mysql.pid
socket = /tmp/mysql.sock
port = 3306
log = /var/log/mysql/mysql.log
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
skip-networking
key_buffer = 16M
max_allowed_packet = 1M
thread_stack = 128K
query_cache_limit = 1048576
query_cache_size = 26214400
query_cache_type = 1
-------------------------------
大仙赐教啊!
为什么就不能直接登陆到 mysql> 呢? 为什么就不能直接登陆到 mysql> 呢? |
|