装置

  • homebrew装置

    • brew install mysql

  • 官网MySQL Community Downloads

    • https://dev.mysql.com/downloa...

环境配置

# 批改  ~/.zshrcvim  ~/.zshrc# 切换编辑模式i   # 增加mysql门路到PATHexport PATH=$PATH:/usr/local/mysql/bin# 退出vim编辑模式,保留批改ESC + :wq!# 使配置失效soucre  ~/.zshrc# 别名设置  mysql启动、敞开、重启alias mysqlstart='sudo /usr/local/mysql/support-files/mysql.server start'alias mysqlstop='sudo /usr/local/mysql/support-files/mysql.server stop'alias mysqlrestart='sudo /usr/local/mysql/support-files/mysql.server restart'

批改字符集

  • 查看字符集、字序集
# 命令行登录mysqlmysql -uroot -p# 查看mysql编码show variables like '%char%';

在 MacOS 里，mysql 一开始就没有 my.cnf 文件，在iterm里，输出：

mysql --help | grep cnf# 失去order of preference, my.cnf, $MYSQL_TCP_PORT,/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf
# 新建my.cnfcd /etcvim my.cnf# 新增如下配置[client]port = 3306default-character-set = utf8[mysqld]port = 3306character-set-server = utf8collation-server = utf8_unicode_ciinit_connect = 'SET NAMES utf8'default-storage-engine = INNODB[mysql]default-character-set = utf8
# 查看mysql编码show variables like '%char%';

[client] 代表客户端默认设置内容
[mysql] 代表咱们应用mysql命令登录mysql数据库时的默认设置
[mysqld] 代表数据库本身的默认设置