win7配置免安装mysql5.6.19过程详解 本文主要介绍免安装配置mysql5.6.19的过程,整个过程中自己出现很多次失误,经过整理,现将一次可成功的过程记录下来,供大家参考。 准备 在mysq官网http://dev.mysql.com/downloads/mysql/,下载最新稳定版本。本文使用的
win7配置免安装mysql5.6.19过程详解本文主要介绍免安装配置mysql5.6.19的过程,整个过程中自己出现很多次失误,经过整理,现将一次可成功的过程记录下来,供大家参考。
basedir = E:/Develop/mysql-5.6.19-winx64 datadir = E:/Develop/TestMysqlData character_set_server=utf8 character_set_client=utf8
2014-06-29 15:58:07 9116 [Note] Plugin 'FEDERATED' is disabled. E:\Develop\mysql-5.6.19-winx64\bin\mysqld: Table 'mysql.plugin' doesn't exist 2014-06-29 15:58:07 9116 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 2014-06-29 15:58:07 9116 [Note] InnoDB: Using atomics to ref count buffer pool pages
E:\Develop\mysql-5.6.19-winx64\bin>mysql_upgrade Looking for 'mysql.exe' as: E:\Develop\mysql-5.6.19-winx64\bin\mysql.exe Looking for 'mysqlcheck.exe' as: E:\Develop\mysql-5.6.19-winx64\bin\mysqlcheck.exe FATAL ERROR: Upgrade failed通过net start mysqltest启动服务,依然报错。
E:\Develop\mysql-5.6.19-winx64\bin>net start mysqltest mysqltest 服务正在启动 . mysqltest 服务已经启动成功。
CREATE DATABASE test DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;