mysql

mysql安装-centos

• 下载

Red Hat Enterprise Linux 7 / Oracle Linux 7 (x86, 64-bit), RPM Bundle

• 解压文件

tar -xvf mysql-5.7.30-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql/

• 顺序执行安装

rpm -ivh mysql-community-common-5.7.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.19-1.el7.x86_64.rpm

• 卸载mariadb

# 查看安装的版本
rpm -qa | grep postfix
rpm -qa | grep mariadb

# 卸载安装
yum remove mariadb-lib-xxx
rpm -ev postfix-2.10.1-6.el7.x86_64
rpm -ev mariadb-libs-5.5.52-1.el7.x86_64

• 安装可能缺少的依赖

yum install numactl
yum install perl
yum install libaio

• 启动和重启服务

systemctl start mysqld.service
systemctl restart mysqld.service

• 查看临时密码

grep password /var/log/mysqld.log

• msql设置

# 1.登录
mysql -p
# 2.设置mysql密码为简单密码
set global validate_password_policy=0;
set global validate_password_length=1;
# 3.设置密码
set password=password("450103jzjJ");
# 4.启用远程连接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '450103jzjJ';
flush privileges;
# 5.查看mysql版本
select version();
# 查看编码和排序规则
show variables like '%character%';
show variables like '%collation%';

• 修改utf8编码 /etc/my.cnf

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
max_allowed_packet=1024M

修改排序规则

• 将数据库修改为指定的排序规则，可以直接修改
• 将指定的表修改排序规则

alter table t_pms_carry_year convert to character set utf8 collate utf8_unicode_ci;