MySQL 5.5.38安装出现的问题_MySQL
系统启动、关闭
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.
贴出错误日志：
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