Maison > base de données > tutoriel mysql > le corps du texte

MySQL 5.5.38安装出现的问题

WBOY
Libérer: 2016-06-07 15:47:18
original
1098 Les gens l'ont consulté

卸掉5.1.73, 安装5.5.38,出现的一些问题。 系统启动、关闭 net start mysql; net stop mysql; 删除服务:两种方法 sc delete mysql mysqld -remove 安装 mysqld --install mysql --defaults-file=D:\mysql 5.5.38\my.ini --install 后面跟的事服务名。 5.5

卸掉5.1.73, 安装5.5.38,出现的一些问题。


系统启动、关闭

net start mysql;

net stop mysql;


删除服务:两种方法

sc delete mysql 

mysqld -remove 


安装

mysqld --install mysql --defaults-file="D:\mysql 5.5.38\my.ini"

--install 后面跟的事服务名。


5.5.38与5.1.73中不同之处:


mysqld

5.1.73 default-character-set=utf8

5.5.38 character-set-server=utf8


日志叫法也有区别,记得不是特别清楚

slow_query_log

log_slow_query


另外dir设置出问题也会导致1067系统错误。

#系统基本目录

basedir= C:/srv/mysql-5.5.19
#用户数据目录

datadir= E:/myWeb/mysql5data/data

e it.MySQL 5.5.38安装出现的问题




贴出错误日志:

140707 11:37:55  InnoDB: Starting shutdown...
140707 11:37:55  InnoDB: Shutdown completed; log sequence number 1595675
140707 11:37:55 [Note] D:\MySQL 5.5.38\bin\mysqld: Shutdown complete


140707 11:40:27 [Note] Plugin 'FEDERATED' is disabled.
140707 11:40:27 InnoDB: The InnoDB memory heap is disabled
140707 11:40:27 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140707 11:40:27 InnoDB: Compressed tables use zlib 1.2.3
140707 11:40:27 InnoDB: Initializing buffer pool, size = 2.0G
140707 11:40:27 InnoDB: Completed initialization of buffer pool
140707 11:40:27 InnoDB: highest supported file format is Barracuda.
140707 11:40:28  InnoDB: Waiting for the background threads to start
140707 11:40:29 InnoDB: 5.5.38 started; log sequence number 1595675
140707 11:40:29 [ERROR] D:\MySQL 5.5.38\bin\mysqld: unknown option '--skip-locking'
140707 11:40:29 [ERROR] Aborting


140707 11:40:29  InnoDB: Starting shutdown...
140707 11:40:30  InnoDB: Shutdown completed; log sequence number 1595675
140707 11:40:30 [Note] D:\MySQL 5.5.38\bin\mysqld: Shutdown complete


140707 11:43:45 [Note] Plugin 'FEDERATED' is disabled.
140707 11:43:45 InnoDB: The InnoDB memory heap is disabled
140707 11:43:45 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140707 11:43:45 InnoDB: Compressed tables use zlib 1.2.3
140707 11:43:45 InnoDB: Initializing buffer pool, size = 2.0G
140707 11:43:45 InnoDB: Completed initialization of buffer pool
140707 11:43:45 InnoDB: highest supported file format is Barracuda.
140707 11:43:46  InnoDB: Waiting for the background threads to start
140707 11:43:47 InnoDB: 5.5.38 started; log sequence number 1595675
140707 11:43:47 [ERROR] D:\MySQL 5.5.38\bin\mysqld: unknown variable 'default-character-set=utf8'
140707 11:43:47 [ERROR] Aborting


140707 11:43:47  InnoDB: Starting shutdown...
140707 11:43:47  InnoDB: Shutdown completed; log sequence number 1595675
140707 11:43:47 [Note] D:\MySQL 5.5.38\bin\mysqld: Shutdown complete


140707 11:45:51 [Note] Plugin 'FEDERATED' is disabled.
140707 11:45:51 InnoDB: The InnoDB memory heap is disabled
140707 11:45:51 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140707 11:45:51 InnoDB: Compressed tables use zlib 1.2.3
140707 11:45:51 InnoDB: Initializing buffer pool, size = 2.0G
140707 11:45:52 InnoDB: Completed initialization of buffer pool
140707 11:45:52 InnoDB: highest supported file format is Barracuda.
140707 11:45:52  InnoDB: Waiting for the background threads to start
140707 11:45:53 InnoDB: 5.5.38 started; log sequence number 1595675
140707 11:45:53 [ERROR] D:\MySQL 5.5.38\bin\mysqld: unknown variable 'default-character-set=utf8'
140707 11:45:53 [ERROR] Aborting


140707 11:45:53  InnoDB: Starting shutdown...
140707 11:45:54  InnoDB: Shutdown completed; log sequence number 1595675
140707 11:45:54 [Note] D:\MySQL 5.5.38\bin\mysqld: Shutdown complete






Étiquettes associées:
source:php.cn
Déclaration de ce site Web
Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn
Tutoriels populaires
Plus>
Derniers téléchargements
Plus>
effets Web
Code source du site Web
Matériel du site Web
Modèle frontal