一路向前.MySql安装配置及使用

• 安装版本及系统环境

mysql.5.7.17-winx64.zip（直接在官网下载）

Windows Server 2008 x64

Navicat for MySQL（自行下载破解版）

• MySql安装步骤

1. 解压mysql.5.7.17-winx64.zip，如 C:\mysql-5.7.17-winx64
2. 配置MySql环境变量。a.新建系统变量MYSQL_HOME = C:\mysql-5.7.17-winx64 b.在系统变量path前追加%MYSQL_HOME%\bin;
3. 修改解压目录下的my-default.ini文件如下：

4. # For advice on how to change settings please see
   # http://dev.mysql.com/doc/refman/5.7/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.
   [mysql]
   
   # 设置mysql客户端默认字符集
   
   default-character-set = utf8
   
   [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 = 512M
   
   # 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 = C:\\mysql-5.7.17-winx64
   datadir = C:\\mysql-5.7.17-winx64\\data
   port = 3306
   server_id = 10
   max_connections = 200
   
   # 服务端使用的字符集默认为8比特编码的latin1字符集
   
   character-set-server=utf8
   
   # 创建新表时将使用的默认存储引擎
   
   default-storage-engine=INNODB
   
   # 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 = 512M
   # sort_buffer_size = 8M
   # read_rnd_buffer_size = 8M 
   
   # sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

5. cmd到C:\mysql-5.7.17-winx64\bin下依次执行如下命令

mysqld --initialize-insecure //初始化一个无密码的 root 

mysqld -install //安装MySql服务

net start mysql //启动MySql服务

mysql -u root -p //登陆MySql

set password = password('123456'); //添加MySql密码

完成上述命令的过程如果如下所示，应该就已经OK了~,~!

 

• 可视化操作工具安装及配置

1. 1. 安装Navicat for MySQL
   2. 配置连接信息，此时可能会出现本机连不上服务器情况，可能是由于默认的root用户没有远程连接的权限，在服务端使用Navicat连接localhost后，打开user表修改root用户的host字段，改localhost为%，然后重启MySQL即可