重点是以下配置,其中datadir的目录名称必须是data,并且好像必须是MySQL目录下的data.之前自己制定了其他目录,一直出现1067的错误。
#Path to installation directory. All paths are usually resolved relative to this.
basedir="d:\MySQL"
#Path to the database root
datadir="d:\MySQL\Data"
4、在windows环境变量里加入以下内容(方便执行命令行命令)
新建MYSQL_HOME=”d:\MySQL”,
在Path里加入%MYSQL_HOME%\bin
5、将mysql注册为windows系统服务。具体操作是在命令行中执行以下命令:
切换到bin目录后 ,执行mysqld ?install 必须切换到bin目录
C:\Windows\system32>cd /
C:>d:
D:\cd Mysql\bin
D:\cd Mysql\bin>mysqld ?install
Service successfully installed.
D:\cd Mysql\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
“`
6、第5步成功后,在命令行启动mysql
c:>net start mysql
7、修改root的密码为111111
用mysqladmin
mysqladmin -u root password “111111”
如果root已经设置过密码,采用如下方法
mysqladmin -u root password oldpass “newpass”
windows764位下配置mysql64位免安装版(三)
emory per process, so do not
# set it too high.
innodb_buffer_pool_size=77M
# Size of each log file in a log group. You should set the combined size
# of log files to about 25%-100% of your buffer pool size to avoid
# unneeded buffer pool flush activity on log file overwrite. However,
# note that a larger logfile size will increase the time needed for the
# recovery process.
innodb_log_file_size=39M
# Number of threads allowed inside the InnoDB kernel. The optimal value
# depends highly on the application, hardware as well as the OS
# scheduler properties. A too high value may lead to thread thrashing.
innodb_thread_concurrency=8
*****************配置文件结束*********************