我在本机winxp用vmware安装了CentOS5,在搭建LAMP环境时,当安装了Mysql后启动服务时提示:
我是这样安装的(按照discuz用户手册上步骤安装的):
下载wget http://zy.jcwcn.com/soft/server/ ... i686-glibc23.tar.gz后
# tar xzvf mysql-5.0.45-linux-i686-glibc23.tar.gz
# mv mysql-5.0.45-linux-i686-glibc23 /usr/local/
# ln -s /usr/local/ mysql-5.0.45-linux-i686-glibc23 /usr/local/mysql
# useradd mysql
# chown -R mysql:root /usr/local/mysql/
# cd /usr/local/mysql
# ./scripts/mysql_install_db --user=mysql
# cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
# chown root:root /etc/rc.d/init.d/mysqld
# chmod 755 /etc/rc.d/init.d/mysqld
# chkconfig --add mysqld
# chkconfig --level 3 5 mysqld on
# cp ./support-files/my-huge.cnf /etc/my.cnf
# mv /usr/local/mysql/data /var/lib/mysql
# chown -R mysql:mysql /var/lib/mysql/
# vi /etc/my.cnf
修改以下内容:
(1) 在 [mysql] 段增加一行:
default-character-set = GBK
(2) 在 [mysqld] 段增加或修改:
datadir = /var/lib/mysql
--skip-innodb
default-character-set = GBK
--wait-timeout = 3
max_connections = 256
max_connect_errors = 10000000
thread_concurrency = 8
最后一步将 log-bin 注释,没有找到这个节点
# bin/MySQLadmin -u root password 'password_for_root'
请问大侠 ,我该怎么解决,小弟先谢谢啦
[ 本帖最后由 willing_appfuse 于 2008-5-13 23:15 编辑 ]


最新回复