绿色版mysql安装过程

来源：互联网发布：apache tiles3 教程编辑：程序博客网时间：2024/05/17 07:39

1.将绿色安装文件解压到安装目录，我的安装目录为：D:\mysql-advanced-5.6.13-winx64

2.复制一份my-default.ini为my.ini配置文件，然后编辑my.ini文件，修改如下：

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
basedir ="D:\mysql-advanced-5.6.13-winx64"
# datadir = .....
datadir ="D:\mysql-advanced-5.6.13-winx64\data"
# port = .....
# server_id = .....

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

#服务端的编码方式
character-set-server=utf8
[client]
#客户端编码方式，最好和服务端保存一致
loose-default-character-set = utf8

[WinMySQLadmin]
Server = "D:\mysql-advanced-5.6.13-winx64\bin\mysqld.exe"

ps：根据自己的安装路径修改配置信息

3.执行cmd，然后cd到你安装的bin目录下（D:\mysql-advanced-5.6.13-winx64\bin），然后执行mysqld -install（或mysqld --install MySQL --defaults-file="D:\mysql-advanced-5.6.13-winx64\my.ini"指定ini文件），在服务下就会出现mysql的服务

ps:删除服务cmd中执行 sc delete mysql //这里的mysql是你要删除的服务名

4.更改root密码，cmd执行： D:\mysql-advanced-5.6.13-winx64\bin\mysqladmin -uroot -p password 新密码，更改密码为123456，然后回车，它让你输入原密码，原始密码是为空的，所以直接回车，修改成功。然后退出，重新打开cmd，依据之前登陆mysql的方式重新执行一遍，利用修改后的密码登陆。

5.利用图形化界面连接mysql数据库，这里用的是Navicat for MYSQL；

6.问题解决：

本人安装过程中出现cmd连接的上，但是图形化界面连接不上，（而且之后localhost能登进去，而127.0.0.1进不去）在网上找了N多个解决方案，然后改ini文件，删注册表，删服务重装，改hosts文件...各种鼓捣了好长时间，仍旧没有解决，然后用安装版mysql装了一遍，发现3306端口被占用了，然后，我把3306端口给干掉（点击解决端口占用），又重新按上述步骤，结果奇迹发生，居然成功啦，成功啦，成功啦。。。（重要的事说三遍）

0 0