Linux安装MySQL

MySQL_Linux版的安装，先在官网下载对应版本

官网：[https://www.mysql.com ](https://www.mysql.com/)

通过Xftp工具将安装包放在/opt文件夹下，

在Linux中输入，查看对应的文件

cd /opt/
ll

RPM命令：软件包管理

rpm -qa :查看所有已经安装了的软件
    -i： 安装
    -e：卸载
    -hv：查看安装进度 
rpm -qa | grep -i mariadb 查看软件 |表示管道符，将前一个命令的输出作为下一个命令的输入  -i忽略大小写

mariadb默认在CentOS系统里，默认安装，需要先卸载

mariadb：是mysql的的分支

因为有软件依赖mariadb，需要强行卸载

rpm -e --nodeps  mariadb-libs 

卸载后用命令，按顺序安装，我只抽出部分有用的包进行安装

rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm 
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm 
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm 
yum -y install perl   在线安装需要的文件
yum -y install net-tools   若没有需要在线安装这俩
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm 

此时已经安装好 查看版本

mysqladmin --version

此时需要先初始化

mysqld --initialize --user=mysql

查看默认生成的密码

 cat /var/log/mysqld.log
 最后一行
 root@localhost: ljDQQL=A/4f6

此时可以启动mysql了

systemctl start mysqld  
systemctl enable mysqld   设置开机自启
mysql -uroot -p
输入刚才的密码

登陆之后重新设置密码

set password = password('123456');   
quit  退出在重新登陆

修改编码集

vi /etc/my.cnf

添加

[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci  排序编码

添加完例子

[client]
default-character-set=utf8

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

重启mysql

systemctl restart mysqld