首先请确认正确安装好MySQL.
1- 先配置环境变量path
1.1 打开终端,输入: cd ~
会进入~文件夹,
1.2 然后输入:touch .bash_profile
回车执行后,
1.3 再输入:open -e .bash_profile
会在TextEdit中打开这个文件(如果以前没有配置过环境变量,那么这应该是一个空白文档).
如果有内容,请在结束符前输入,如果没有内容,请直接输入如下语句:
export PATH=${PATH}:/usr/local/mysql/bin
然后,保存,退出TextEdit(一定是退出),关闭终端并退出.
此时应该可以直接用以下语句登入MySQL了
>mysql -uroot -p
1.4 关闭MySQL !!!!(在系统偏好设置里面关闭MySQL)
2- 重点来了!!!
2.1 查看一下support-files文件夹(Finder下"前往文件夹";路径:/usr/local/mysql/support-files)
里面有没有my-default.cnf或my.cnf文件...如果有则直接打开添加
在[client] 在下面添加
default-character-set=utf8 默认字符集为utf8
在[mysqld] 添加
default-character-set=utf8 默认字符集为utf8
init_connect='SET NAMES utf8' (设定连接mysql数据库时使用utf8编码,以让mysql数据库为utf8运行)
修改好后,重新启动mysql查看当前数据编码格式。
>
show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
若终端出现如上样式则OK了,否则继续往下看:
2.2 support-files文件夹里面没有my-default.cnf或my.cnf文件,那么就要在/etc下新建my.cnf
$ cd /etc
$ sudo vim my.cnf
2.3 进行完上步操作后会进入vim模式,此时复制(***文本)的内容粘贴进去,,(不包含 ***文本 );
2.4 粘贴成功后注意看vim的第一行"#"有没有丢掉(本人就丢过~~哈哈~),都OK的话点esc退出编辑,
:wq! --保存后强制退出.[附几个编辑命令:dd 删除光标所在行; dw 删除一个字(word); x 删除当前字符].
(***文本):
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# MySQL programs look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, see:
# http://dev.mysql.com/doc/mysql/en/option-files.html
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
default-character-set=utf8
#password = your_password
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
character-set-server=utf8
init_connect='SET NAMES utf8
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
character-set-server=utf8
init_connect='SET NAMES utf8'
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (