from: 哔哩哔哩尚硅谷の笔记
一、配置文件介绍
在软件安装目录下有文件my.ini,用记事本打开
my.ini文件部分内容摘录及注释
[mysql]
default-character-set=utf8 //客户端字符集
[mysqld]
#The TCP/IP Port the MySQL Server will listen on
port=3306 //修改服务端端口号
#Path to installation directory. All paths are usually resolved relative to this.
basedir=“C:/Program Files/MySQL/MySQL Server 5.5/” //安装目录
#Path to the database root
datadir=“C:/ProgramData/MySQL/MySQL Server 5.5/Data/” //数据库文件目录
#The default character set that will be used when a new schema or table is
#created and no character set is defined
character-set-server=utf8 //默认字符集
#The default storage engine that will be used when create new tables when
default-storage-engine=INNODB //存储引擎,用于执行sql
#Set the SQL mode to strict
sql-mode=“STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION” //语法模式
#The maximum amount of concurrent sessions the MySQL server will
#allow. One of these connections will be reserved for a user with
#SUPER privileges to allow the administrator to login even if the
#connection limit has been reached.
max_connections=100 //最大连接数
配置完成后数据库重启生效
二、MySQL服务端的登陆和退出
保证MySQL服务处于启动状态
方式一:通过mysql自带客户端(只限root账户)
直接输入密码:******,回车进入mysql客户端
退出键入exit
方式二:通过命令行的方式
打开CMD
键入mysql -h localhost -P 3306 -u root -p 后 回车
输入密码******回车进入数据库客户端
连接本机可以使用:mysql -u root -p
三、配置环境变量
-
将目标文件夹bin目录的地址复制
(例如C:\Program Files\MySQL\MySQL Server 5.5\bin) -
桌面上右键“此电脑图标”
-
单击属性
-
点击高级系统设置
-
点击环境变量
-
在系统变量中点击path
-
点击新建
-
将路径粘贴上去,点击确定,确定,确定
最后重启CMD键入mysql -V 若显示版本号,则成功!
若显示:
则失败,重新按照顺序进行配置。