ERROR! The server quit without updating PID file (/opt/mysql/mysql/data/cvs.pid)
查日誌
130228 16:59:25 [ERROR] /opt/mysql/mysql/bin/mysqld: unknown variable 'default-character-set=utf8'
130228 16:59:25 [ERROR] Aborting
找到以下資料:
[#0x004E] MySQL 5.5版本下my.ini內[mysqld]項中不能再寫default-character-set=utf8
RT。
原來在5.1版本時,為了解決中文亂碼問題設定預設字符集為utf8時,在my.ini內的 [mysql] 和 [mysqld] 項中都是寫:
- default-character-set=utf8
到了5.5版本, [mysql] 項內可以這麼寫, [mysqld] 項內不能再這麼寫了,而是必須寫:
- character-set-server=utf8
否則在啟動MySQL服務時會有1067錯誤。
目前已知5.1和5.5有這麼一個不同之處,且是從5.5的安裝版本自動生成的my.ini檔案中看出的。
【參考】http://aoyi.iteye.com/blog/1121940
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/14184018/viewspace-754981/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Mysql:The server quit without updating PID file (/eipdb1/mysql/data/EIPDB1.pid).MySqlServerUI
- MySQL提示:The server quit without updating PID file(…)失敗MySqlServerUI
- Starting MySQL.The server quit without updating PID fileMySqlServerUI
- The server quit without updating PID fileServerUI
- MySQL啟動報錯:The server quit without updating PID fileMySqlServerUI
- The server quit without updating PID file (/mydata/mysql/BIDB.pid).[FAILED]ServerUIMySqlAI
- mysql The server quit without updating PID file異常解決辦法薦MySqlServerUI
- Linux安裝mysql出現ERROR! The server quit without updating PID file問題解決LinuxMySqlErrorServerUI
- MySQL The server quit without updating PID file xx/var/DESKTOP-BHVUG0D.pidMySqlServerUI
- MYSQL啟動後報:ERROR! The server quit without updating PID file錯誤的問題解決MySqlErrorServerUI
- The server quit without updating PID file (/var/mysqltest1.pid).[FAILEDServerUIMySqlAI
- mysql啟動報錯Manager of pid-file quit without updating file.[FAILED]MySqlUIAI
- MysqL錯誤之_ERROR! MySQL server PID file could not be found!MySqlErrorServer
- MySQL server PID file could not be found!MySqlServer
- StartingMySQL.ERROR!TheserverquitwithoutupdatingPIDfile(/data/mysql/mysql.pid).MySqlErrorServerUI
- Mysql啟動錯誤-server PID file could not be foundMySqlServer
- ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables optErrorMySqlServer
- mysql 5.7.21 CMake Error: The source directory "/data/server/mysql" does not appear to contain CMakMySqlErrorServerAPPAI
- SQL SERVER – Attach mdf file without ldf file in DatabaseSQLServerDatabase
- ERROR 1290:The MySQL server is running with the --secure-file-priv optionErrorMySqlServer
- 【MySQL】mysql啟動常見報錯 mysqld_safe mysqld from pid file hostname.pid endedMySql
- mysql錯誤: [ERROR] InnoDB: auto-extending data file /data/ibdata1 is of a different size 768 pages...MySqlError
- docker mysql mysqld: Error on realpath() on ‘/var/lib/mysql-files‘ No such file or directoryDockerMySqlError
- Error: package MySQL-Cluster-server-gpl is not relocatableErrorPackageMySqlServer
- mysql之pid檔案MySql
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- CDH CM cloudera-scm-server dead but pid file existsCloudServer
- MySQL資料匯入匯出之Load data fileMySql
- StartingMySQL…ERROR!TheserverquitwithoutupdatingPIDfile(/mydata/data/t1.pid).MySqlErrorServerUI
- 【MySQL】ERROR 1878 (HY000): Temporary file write failure.MySqlErrorAI
- Mysql 報The MySQL server is running with the --secure-file-priv option so it cannot execute this stat...MySqlServer
- nginx: [error] open() “/var/run/nginx/nginx.pid“ failed (2: No such file or directory)NginxErrorAI
- MySQL data pageMySql
- mysql error 2005 - Unknown MySQL server host 'localhost'(11001)MySqlErrorServerlocalhost
- ERROR 1290 (HY000): The MySQL server is running withErrorMySqlServer
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- Warning:The /usr/local/mysql/data directory is not owned by the 'mysql' or '_mysql'MySql
- SQL Error (1130): Host IP is not allowed to connect to this MySQL serverErrorMySqlServer