四虎影视在线影院在线观看,小s货再浪些再咬紧点h,国产精品水嫩水嫩,97精产国品一二三产区

標(biāo)題: [求助] 用了MYSQL優(yōu)化工具最后一個出現(xiàn)數(shù)據(jù)庫連接密碼出錯 [打印本頁]

作者: jjh5207 時間: 2014-2-21 08:55 標(biāo)題: 用了MYSQL優(yōu)化工具最后一個出現(xiàn)數(shù)據(jù)庫連接密碼出錯

本帖最后由 jjh5207 于 2014-2-21 08:57 編輯

用了MYSQL優(yōu)化工具最后一個出現(xiàn)、

無法連接mysql，請檢查mysql是否已啟動及用戶密碼是否設(shè)置正確!:

用了

sh /www/wdlinux/tools/mysql_wdcp_chg.sh

重起數(shù)據(jù)庫還是出現(xiàn)了
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文件里的設(shè)置還原一下，修改用vi 編緝
輸入o 進(jìn)入開編緝
保存按ESC鍵盤然后按冒號：如果在保存在冒號后輸入wq

然后在SSH里執(zhí)行service mysqld restart即可

以下是my.cnf文件的默認(rèn)設(shè)置

# mysql conf /etc/my.cnf
# Created by http://cd-genova.com
# 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文件里的設(shè)置還原一下，修改用v ...
jjh5207 發(fā)表于 2014-2-21 09:10

收藏一下此默認(rèn)配置

歡迎光臨 WDlinux官方論壇 (http://cd-genova.com/bbs/)