Windows安装MySQL5.7

Windows安装MySQL5.7

1.下载并解压 下载地址:https://www.oaroad.com/download/mysql-5.7.25-winx64.zip 2.配置环境变量 变量名:MYSQL_HOME 变量值:D:\MySQL 变量名:path 变量值:%MYSQL_HOME\bin% 3.初始化MySQL 以管理

二进制安装MySQL

二进制安装MySQL

1.删除centos系统自带的mariadb数据库 rpm -qa|grep mariadb rpm -e mariadb-libs --nodeps 2.安装libaio库 yum -y install libaio numactl 3.下载并解压mysql-5.7.28

mysql中information_schema.tables字段说明

mysql中information_schema.tables字段说明

字段 含义 Table_catalog

Navicat 连接SSH方式连接mysql报错 sshexpected key exchange group packet

Navicat 连接SSH方式连接mysql报错 sshexpected key exchange group packet

修改ssh配置文件 最后一行新增 vim /etc/ssh/sshd_config KexAlgorithms curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-h