centos7 tar mysql5.7.27 glic

最新推荐文章于 2023-01-04 21:41:19 发布

z_dy1

最新推荐文章于 2023-01-04 21:41:19 发布

阅读量241

点赞数

文章标签： mysql

本文链接：https://blog.csdn.net/z_dy1/article/details/107247008

版权

# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz

1、解压
# tar xvf mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz
2、移动
# mv mysql-5.7.27-linux-glibc2.12-x86_64 /usr/local/mysql

配置文件

1、编辑主配置文件
# vi /etc/my.cnf
[mysqld]
datadir=/usr/local/mysql/data/
socket=/tmp/mysql.sock
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

!includedir /etc/my.cnf.d

2、创建子配置文件目录
# mkdir /etc/my.cnf.d

3、创建数据目录
# mkdir /usr/local/mysql/data

4、创建pid文件存放目录
# mkdir /var/run/mysqld

5、创建启动用户mysql
# useradd mysql

6、将上面创建的数据目录及pid文件存放目录权限都改为mysql
# chown mysql.mysql /var/run/mysqld/ /usr/local/mysql/  -R

初始化数据库仓库

# /usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

注意：
这里如果执行上面命令报如下的错误
2019-11-28 05:33:06 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2019-11-28 05:33:06 [ERROR]   Child process: /usr/local/mysql/bin/mysqldterminated prematurely with errno= 32
2019-11-28 05:33:06 [ERROR]   Failed to execute /usr/local/mysql/bin/mysqld --bootstrap --datadir=/usr/local/mysql/data --lc-messages-dir=/usr/local/mysql/share --lc-messages=en_US --basedir=/usr/local/mysql
-- server log begin --
解决办法：
# yum install libaio numactl -y

添加MySQL全局环境变量

# vi /etc/profile 
  export PATH=$PATH:/usr/local/mysql/bin
# source /etc/profile

启动MySQL，并设为开机启动

# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
# chkconfig --add mysqld
# chkconfig --level 2345 mysqld on
# service mysqld start

更改密码

1、查看初始密码
# cat /root/.mysql_secret 
# Password set for user 'root@localhost' at 2020-01-28 09:23:50 
xds3!34_*5*
2、修改密码
# mysqladmin -u root password "123456" -p
Enter password: xds3!34_*5*

3、验证密码是否修改成功
# mysql -p123456 -e "show databases;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+

4、设置远端登录
# mysql -p123456
mysql> grant all on *.* to 'root'@'%' identified by '123456';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
用客户端工具连接mysql（先关防火墙）