登陆mysql
./mysql -u root -p
查看字符集
show variables like '%char%';
临时修改字符集
set character_set_server=utf8;
set character_set_database=utf8;
mac下永久修改字符集
在/etc目录下新建文件my.cnf
加入内容:
[mysqld]
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
文件授权。sudo chmod 664 my.cnf,重启mysql,完成。
首先登录MySQL,sql修改密码:
mysql> use mysql;
mysql> update user set password=password('123') where user='root' and host='localhost';
mysql> flush privileges;