我需要为带有SUSE版本11发行版的linux 2.16版本运行MySQL服务.
下载以下文件并安装所有rpms,如下所示:
MySQL-server-5.5.27-1.sles11.i586
MySQL-client-5.5.27-1.sles11.i586
MySQL-devel-5.5.27-1.sles11.i586
MySQL-shared-5.5.27-1.sles11.i586
MySQL-shared-compat-5.5.27-1.sles11.i586
安装过程中没有错误,我通过以下方式确认已安装的软件包:
rpm -qa|grep -i sql
但是在尝试执行时服务器没有启动:
$> mysql
M得到以下内容作为eror msg:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
我已经检查过/etc/init.d位置,只有mysql条目而不是mysqld,这是服务器启动错误的原因.
在谷歌上搜索了几个小时,我也试过./mysql从相同的位置开始,但得到以下输出:
Starting MySQL..The server quit without updating PID file (/var/lib/mysql/ABC2-rahul.pid).
我是mysql的新手,任何帮助将不胜感激.提前致谢.
我已经cheked,发现一些配置文件已经在/usr/share / mysql中了,我已经将my-huge.cnf文件复制到/ etc位置,有什么评论吗?
以下是来自同一my.cnf文件的内容:
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 384M
max_allowed_packet = 1M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 8
log-bin=mysql-bin
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout