centos7 安卓mysql服务 :允许远程登录,修改密码,查看并修改编码

原创
2016/06/06 18:47
阅读数 131

mysql info: 192.168.56.101 root/****** allow remote connect;

how to start stop: service mysqld start; service mysqld stop; allow start on system startup.

all remote connect: set password for ‘root’@‘%’ = password(''); set password for root@localhost=password('root'); UPDATE mysql.user SET Password = PASSWORD('') WHERE user = 'root';

change to utf8: service mysqld stop; vi /etc/my.cnf; character_set_server=utf8 init_connect='SET NAMES utf8'

service mysqld start; mysql -uroot -p password: show variables like 'char%';


展开阅读全文
打赏
0
0 收藏
分享
加载中
更多评论
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部