- CentOS7.x 安装 MySQL服务个人觉得并没有太大的差别,不明白为什么会有人碰到这么多的问题(当然安装mysql的方式很多,这里是一种比较简单切成功率非常高的一种),下面我将自己安装流程罗列下来:
mysql版本:mysql5.7.x
步骤:
- 卸载CentOS7自带的MariaDB
yum remove mariadb*
备注:如果已经安装mysql,需要卸载原来的服务
- 进入/usr/local/src/路径
cd /usr/local/src/
3.安装MySQL(依次执行下列命令)
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
yum -y install mysql-server
- mysql相关文件
(1)配置文件:/etc/my.cnf
(2)日志文件:/var/log/var/log/mysqld.log
(3)服务启动脚本:/usr/lib/systemd/system/mysqld.service
(4)socket文件:/var/run/mysqld/mysqld.pid
- 修改 vim /etc/my.cnf(下面是我的配置文件)
[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
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
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服务
- centos6:service mysqld restart
centos7: systemctl start mysqld.service - 获取启动日志中的随机密码
grep "password" /var/log/mysqld.log
上图中冒号后的就是随机密码
- 使用获取到密码登录mysql
mysql -u root -p
- 修改mysql密码(必须修改;mysql不同版本有不同的密码规则,5.7.x 必须包含 数字字母符号)
alter user 'root'@'localhost' identified by 'XXXXXX';
flush privileges
XXXXXX 就是设置的密码
flush privileges 刷新权限
- 如果需要远程访问mysql
grant all on *.* to 'root'@'%' identified by 'xxxxxx' with grant option;
root 设置的用户名
xxxxxx 该用户密码
以上就是本人安装5.7.x 的流程,安装过n次,记忆中不曾出过问题