WDlinux官方论坛 - Powered by Discuz! Board

标题: [求助] 用了MYSQL优化工具最后一个出现数据库连接密码出错 [打印本页]

作者: jjh5207 时间: 2014-2-21 08:55 标题: 用了MYSQL优化工具最后一个出现数据库连接密码出错

本帖最后由 jjh5207 于 2014-2-21 08:57 编辑

用了MYSQL优化工具最后一个出现、

无法连接mysql，请检查mysql是否已启动及用户密码是否设置正确!:

用了

sh /www/wdlinux/tools/mysql_wdcp_chg.sh

重起数据库还是出现了
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.

作者: jjh5207 时间: 2014-2-21 09:10

本帖最后由 jjh5207 于 2014-2-21 09:11 编辑

这下能打开了测试下：http://www.it62.com

把/www/wdlinux/etc/my.cnf文件里的设置还原一下，修改用vi 编缉
输入o 进入开编缉
保存按ESC键盘然后按冒号：如果在保存在冒号后输入wq

然后在SSH里执行service mysqld restart即可

以下是my.cnf文件的默认设置

# mysql conf /etc/my.cnf
# Created by http://www.wdlinux.cn
# Last Updated 2010.06.01
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 128M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 8M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 8
max_connections = 300
wait_timeout = 30
interactive_timeout = 30
max_connect_errors = 9
long_query_time = 1
tmp_table_size = 16M
#log-bin=mysql-bin
#binlog_format=mixed
#server-id = 1
[mysqldump]
quick
max_allowed_packet = 8M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 12M
sort_buffer_size = 1M
read_buffer = 1M
write_buffer = 1M
[mysqlhotcopy]
interactive-timeout

作者: fuzball 时间: 2016-11-29 10:13

这下能打开了测试下：http://www.it62.com

把/www/wdlinux/etc/my.cnf文件里的设置还原一下，修改用v ...
jjh5207 发表于 2014-2-21 09:10

收藏一下此默认配置

欢迎光临 WDlinux官方论坛 (http://wdlinux.cn/bbs/)