[求助] mysql升級到5.5報錯了

qq682907

wget http://down.wdlinux.cn/in/mysql_up55.sh
sh mysql_up55.sh我是按著這個升級的 是面板安裝好后
升級的

下載 (30.33 KB)

2013-2-28 23:28

詳細的錯誤日志
130228 23:33:43 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130228 23:33:43 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130228 23:33:43 [Note] Server socket created on IP: '0.0.0.0'.
130228 23:33:43 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
130228 23:33:43 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.5.27/data/MyVPS1970.pid ended

caokai

升級后沒有var這個文件夾�。。�！

admin

把這行去掉

liumingzhij26

/www/wdlinux/mysql/bin/mysqld: unknown variable 'default-character-set=utf8'  默認配置了efault-character-set=utf8就不能啟動了

liumingzhij26

回復(fù) 18# liumingzhij26


131102 16:21:24 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql/var
131102 16:21:24 InnoDB: The InnoDB memory heap is disabled
131102 16:21:24 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
131102 16:21:24 InnoDB: Compressed tables use zlib 1.2.3
131102 16:21:24 InnoDB: Initializing buffer pool, size = 128.0M
131102 16:21:24 InnoDB: Completed initialization of buffer pool
131102 16:21:24 InnoDB: highest supported file format is Barracuda.
131102 16:21:24  InnoDB: Waiting for the background threads to start
131102 16:21:25 InnoDB: 1.1.8 started; log sequence number 1589339
131102 16:21:25 [ERROR] /www/wdlinux/mysql/bin/mysqld: unknown variable 'default-character-set=utf8'
131102 16:21:25 [ERROR] Aborting


131102 16:21:25  InnoDB: Starting shutdown...
131102 16:21:26  InnoDB: Shutdown completed; log sequence number 1589339
131102 16:21:26 [Note] /www/wdlinux/mysql/bin/mysqld: Shutdown complete


131102 16:21:26 mysqld_safe mysqld from pid file /www/wdlinux/mysql/var/Centos214.pid ended

liumingzhij26

Starting MySQL.... ERROR! The server quit without updating PID file (/www/wdlinux/mysql/var/Centos214.pid).

basedir=/www/wdlinux/mysql
    datadir=/www/wdlinux/mysql/var
我都修改了這個，為什么還啟動不了，已經(jīng)重啟過了

qq514408389

修改的是init.d目錄下mysqld這個文件，寫少了，樓上正解

happyboy

http://cd-genova.com/bbs/viewthread.php?tid=5461

qq514408389

回復(fù) 14# qq682907


    可以修改下/www/wdlinux/init.d/mysqld這個文件
    里面這兩行basedir=
                  datadir=
    修改如下
    basedir=/www/wdlinux/mysql
    datadir=/www/wdlinux/mysql/var
    然后再重新試試

qq682907

回復(fù) 13# zd305


   沒升級成功

zd305

錯誤日志如下，請教如何解決？
130402 20:03:37 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.5.27/data
/www/wdlinux/mysql-5.5.27/bin/mysqld: Table 'mysql.plugin' doesn't exist
130402 20:03:37 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130402 20:03:38 InnoDB: The InnoDB memory heap is disabled
130402 20:03:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130402 20:03:38 InnoDB: Compressed tables use zlib 1.2.3
130402 20:03:38 InnoDB: Initializing buffer pool, size = 128.0M
130402 20:03:38 InnoDB: Completed initialization of buffer pool
130402 20:03:38  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
130402 20:03:38 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.5.27/data/li260-147.pid ended

admin

檢查mysql是否啟動,或不能啟動的原因,看下日志

zd305

求解決辦法？

tom1978

這個怎么解決 我也一樣的

qq682907

回復(fù) 8# admin


   已經(jīng)發(fā)了 外出了3小時 剛剛回來