Mysql安装与配置
1.下载安装包
注意：一定要下bundle整合包，光下一个单独的server包不能用
2.顺序安装
rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-devel-5.7.22-1.el7.x86_64.rpm
3.如果此时还是启动失败
systemctl status mysqld
journalctl -xe
查看具体失败日志，这次碰到的是缺这两个库，直接安装就可以了
yum install -y libaio
yum -y install numactl.x86_64
4. 查看默认随机密码
cat /var/log/mysqld.log |grep password
5.登录并修改密码
mysql -u root -p
set password=password('yourpassword111!!!');
或
alter user 'root'@'localhost' identified by 'yourpassword111!!!';
注意：5.7密码必须字母、数字、符号组成，少了就会报错
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
#刷新下权限
flush privileges;
6.开远程登录
#登录mysql
mysql> use mysql
mysql> update user set host='%' where user='root';
mysql> select host,user from user;
mysql> flush privileges;
#退出mysql，重启mysql服务生效
7.编码
[mysql]
default-character-set=utf8
[mysqld]
default-storage-engine=INNODB
character_set_server=utf8
5.7中表名不区分大小写
/etc/my.cnf
[mysqld]
lower_case_table_names=1
5.7中不支持全0的时间格式
所以，导表时最简单的方法就是直接将全零的时间值，替换为1970时间值
数据库脚本中的 0000-00-00 00:00:00 替换为 1970-01-01 00:00:01 就可以了
博文最后更新时间：
评论
-
暂无评论