前言
安装mysql,踩到了很多的坑。本文转载自https://blog.csdn.net/z13615480737/article/details/78906598#commentBox
本篇博客对安装流程进行了简化和再梳理。
1.卸载干净原来安装过的mysql文件以及mariadb文件
在根路径下输入,卸载原来的mysql
rpm -qa|grep -i mysql
还需在根路径下输入,卸载原来的mariadb。原因是centos7之后系统自带了一个免费的数据库mariadb,这个数据库的驱动和mysql有冲突
rpm -qa | grep -i mariadb
2.下载mysql的repo源(下载的是最新的版本)
依次输入,最后一句yum -y install mysql-server 是默认安装到/usr/share/mysql目录下
[root@localhost ~]# cd /usr/local/src/
[root@localhost src]# wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
[root@localhost src]# rpm -ivh mysql57-community-release-el7-8.noarch.rpm
[root@localhost src]# yum -y install mysql-server
上面代码中的第二步即wget...如果提示命令未找到请先输入命令
yum -y install wget
该命令安装好之后,第二步就可以执行成功了
3.配置my.cnf文件
输入vim /etc/my.cnf进入配置文件,按ins启动编辑,写入下面代码,然后按esc输入:wq!强制保存并退出
[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
4.启动mysql服务,需要重置密码
安装成功后,输入下面进行启动mysql服务。
systemctl start mysqld.service
启动服务后,输入下面代码登录账户,之后需要输入密码。
mysql -u root -p
安装好mysql之后系统会生成一个随机密码,这个密码既复杂又不方便,我们先不讲怎么找到随机密码,如何用这个随机密码登录,我们采取的策略是直接修改成自定义密码,使用自定义密码登录mysql,具体如何修改密码请见下篇博客。
https://blog.csdn.net/Delicious_Life/article/details/98481663
5.启动3306端口/授权远程可访问mysql数据库
具体步骤在这篇博客中 https://blog.csdn.net/Delicious_Life/article/details/100046419