sql相关

sql相关

编码格式

show variables like 'character_set_database';

修改编码格式

SET character_set_client = utf8;
SET character_set_results = utf8;
SET character_set_connection = utf8;

编码链接 https://www.cnblogs.com/bulh/articles/10598066.html

安装相关

mysql

#centos 8
yum install mysql-server
# 7
#得先下载mysql源，通过源取安装 
#https://www.runoob.com/mysql/mysql-install.html


service mysqld start/restart
#报错后去看日志，最后日志里会生成一个默认密码
#一般要给mysql组加上 /var/lib/mysql/* 的权限
chown -R mysql.mysql /var/lib/mysql/
#初始化的，但是没到这一步
mysql_secure_installation -D
systemctl mysql 
chown   mysql.mysql path
chmod -R 777 /var/lib/mysql
log: /var/log/mysql/mysqld.log

更新密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
flush privileges;

增加远程访问权限

use mysql; update user set host='%' where user='root';
之后要重启mysql service mysqld restart
use mysql;select User,authentication_string,Host from user;

参考

https://www.cnblogs.com/ivictor/p/5146247.html
https://www.runoob.com/mysql/mysql-install.html
https://www.jianshu.com/p/12f4f66fc67f

加权限

https://developer.aliyun.com/article/801237