Centos7安装MySQL5.7全部流程
1.检查服务器是否已经安装了数据库Mariadb
rpm -qa|grep mariadb
2.卸载系统自带的Mariadb
rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
3.删除/etc/my.cnf
文件,若没有直接重新创建
vim my.cnf
[client]
port = 3306
[mysqld]
port = 3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
max_connections=1000
max_connect_errors=10
character-set-server=utf8
explicit_defaults_for_timestamp=true
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
skip-grant-tables
[mysql]
default-character-set=utf8
4.安装mysql
4.1解压到指定的文件夹
tar -zxvf mysql-5.7.36-linux-glibc2.12-x86_64.tar.gz
4.2修改名称
mv mysql-5.7.36-linux-glibc2.12-x86_64 mysql5.7
4.3更改mysql5.7 目录下所有文件夹所属的用户组、用户以及权限
chown -R mysql:mysql /usr/local/mysql5.7
chmod -R 755 /usr/local/mysql5.7
4.4进入/usr/local/mysql5.7/bin/
目录,编译安装并初始化mysql,务必记住数据库管理员临时密码。在最后一行
- 创建
/use/local/mysql5.7/data
文件夹
./mysqld --initialize --user=mysql --datadir=/usr/local/mysql5.7/data --basedir=/usr/local/mysql5.7
5.启动mysql服务
5.1若mysql服务已经启动,直接杀死进程
5.2查询服务
ps -ef|grep mysql
ps -ef|grep mysqld
5.3启动服务
/usr/local/mysql5.7/support-files/mysql.server start
5.4添加软连接,并重启mysql 服务
ln -s /usr/local/mysql5.7/support-files/mysql.server /etc/init.d/mysql
ln -s /usr/local/mysql5.7/bin/mysql /usr/bin/mysql
service mysql restart
5.5登录mysql ,密码就是初始化时生成的临时密码
mysql -u root -p
5.6修改初始密码为自己的密码
set password for root@localhost = password('123456');
SET PASSWORD = PASSWORD('123456');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;
- 注意:如果Mysql的版本是5.7及以上的话update语句如下
update user set authentication_string=passworD("123456") where user='root';
6.开放远程连接(选项可以不填写)
use mysql;
update user set user.Host='%' where user.User='root';
flush privileges;
7.设置开机自启
cp /usr/local/mysql5.7/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig --list
8.开放3306端口,测试本地客户端是否连接成功
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
9.安装完毕最后测试连接删除线格式