MySql 在CentOS上的安装部署

首先，你可以使用以下命令检测是否已经安装了mysql相关的软件:

  rpm -qa|grep -i mysql

然后，可以使用yum -y remove命令移除，例如:

yum -y remove mysql-community-client-5.6.38-2.el7.x86_64

新建一个目录用于存放安装文件:

mkdir downloads

获取安装包:

wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

rpm操作:

rpm -ivh mysql57-community-release-el7-8.noarch.rpm

开始安装:

yum -y install mysql-server 

MySql的配置文件：

默认配置文件路径： 
配置文件：/etc/my.cnf 
日志文件：/var/log/var/log/mysqld.log 
服务启动脚本：/usr/lib/systemd/system/mysqld.service 
socket文件：/var/run/mysqld/mysqld.pid

修改一下配置文件:

[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
server_id = 1
expire_logs_days = 3
 
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
 
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

开始启动Mysql:

service mysqld restart

迅速查看密码:

grep "password" /var/log/mysqld.log 

使用随机密码登录:

mysql -u root -p   随机密码

马上修改密码:

alter user 'root'@'localhost' identified by '这是你的新密码 需要字母数字特殊符号'; 


#刷新权限


flush privileges;

创建新的用户:

CREATE USER '用户名'@'%' IDENTIFIED BY '密码';

#这里使用%而不是localhost将允许所有ip登录到数据库

设置权限:

 grant all on *.* to '用户名'@'%' identified by '密码'  with grant option;

重启MySql: 

service mysqld restart

当然，需要远程登录的话，需要设置一下防火墙:

#防火墙开放80端口
firewall-cmd --add-port=3306/tcp --permanent
 
#重启防火墙
firewall-cmd --reload