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
*****************配置文件结束*********************
重点是以下配置，其中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”
|