windows安装MySQL 5.7.30

news/2025/1/3 4:24:45/

1.下载地址:https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.30-winx64.zip

2.安装

解压：解压到D盘，改名为：mysql-5.7.30
设置环境变量
- 系统—>高级系统设置—>环境变量—>系统变量
  新建变量名：MYSQL_HOME 值：D:\mysql-5.7.30
- Path最后添加：;%MYSQL_HOME%\bin

mysql-5.7.30下创建my.ini，内容如下：

[mysqld]
#端口号
port = 3306
#mysql-5.7.30-winx64的路径
basedir=D:\mysql-5.7.30
#mysql-5.7.30-winx64的路径+\data
datadir=D:\mysql-5.7.30\data
#最大连接数
max_connections=200
#编码
character-set-server=utf8
default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
skip-grant-tables  #无需密码验证
[mysql]
#编码
default-character-set=utf8

管理员运行cmd
- mysqld -install 成功：Service successfully installed
- mysqld --initialize 成功：没有提示
- net start mysql 启动
修改密码
- mysql -u root -p 回车
- use mysql
- update user set authentication_string=password(“123456”) where user=“root”
- alter user user() identified by “123456”;
- net stop mysql 停止服务器
删除my.ini 中 skip-grant-tables
net start mysql 启动
mysql -u root -p 回车输入密码

3. Ubuntu16.04 安装MySQL ODBC驱动

下载：https://cdn.mysql.com/archives/mysql-connector-odbc-5.2/mysql-connector-odbc-5.2.7-linux-glibc2.5-x86-64bit.tar.gz
安装
- 解压到 /use/local 命名为：mysql-connector-odbc-5.2.7
- cd /usr/local/mysql-connector-odbc-5.2.7/bin
- sudo ./myodbc-installer -d -a -n “MYSQL” -t “DRIVER=/usr/lib/libmyodbc5a.so;SETUP=/usr/lib/libmyodbc5a.so”
- sudo cp -r /usr/local/mysql-connector-odbc-5.2.7/lib/. /usr/lib
- sudo cp -r /usr/local/mysql-connector-odbc-5.2.7/lib/. /usr/lib64
配置ODBC驱动
- sudo vi /etc/odbcinst.ini (与执行myodbc-installer 冲突)
  [MYSQL]
  Description=ODBC for MySQL
  Driver=/usr/lib/libmyodbc5a.so
  SETUP=/usr/lib/libmyodbc5a.so
  Driver64=/usr/lib64/libmyodbc5a.so
  SETUP64=/usr/lib64/libmyodbc5a.so
  FileUsage=1
配置访问数据库信息
- 创建echat 数据库
- sudo gedit /etc/odbc.ini
  [echat]
  Driver = /usr/lib/libmyodbc5a.so
  SERVER = 192.168.2.111
  PORT = 3306
  DATABASE = echat
  USER = root
  PASSWORD = 123456
  OPTION = 67108864
  SocketBufferSize = 4096
  FetchBufferSize = 100
  CHARSET = UTF8
测试：isql -v echat