1,设置root密码:
mysqladmin -u root password newpassword
2,设置mysql字符集
linux系统下:
修改/etc/my.cnf配置文件,如果没有,在/usr/share/mysql/目录下找个配置文件拷贝到/etc/下并重命名为my.cnf
修改具体内容(红色为添加):
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=utf8
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
.............
character-set-server=utf8
然后重启mysql服务
service mysqld restart
查看设置结果:
进入mysql数据库后执行:show variables like 'character%';