怎么在centos安装mysql5.7
发布网友
发布时间：2022-04-22 09:18
共2个回答
懂视网
时间：2022-05-01 00:26
亲测验证适用于5.7.10
1. 获得二进制文件
wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.10-linux-glibc2.5-x86_64.tar.gz
2. 加压到 /usr/local/mysql 目录(或者解压到当前目录然后做软链接到/usr/local/mysql)
mkdir /usr/local/mysql
tar -xvf mysql-5.7.10-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.10-linux-glibc2.5-x86_64/* /usr/local/mysql/
3. 创建 /usr/local/mysql/data 目录
mkdir /usr/local/mysql/data
4. 创建mysql用户和修改软件的权限
groupadd mysql
useradd -r -g mysql mysql -s /sbin/nologin (创建mysql用户并设置不可登录)
chown -R mysql.mysql /usr/local/mysql/
5. 初始化数据(切换当前目录到/usr/local/mysql)
bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
2016-01-20 02:47:35 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2016-01-20 02:47:45 [WARNING] The bootstrap log isn‘t empty:
2016-01-20 02:47:45 [WARNING] 2016-01-19T18:47:36.732678Z 0 [Warning] --bootstrap is deprecated. Please consider using --initialize instead
2016-01-19T18:47:36.750527Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2016-01-19T18:47:36.750560Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
6. 复制配置文件到 /etc/my.cnf
cp -a ./support-files/my-default.cnf /etc/my.cnf (如果问是否替换选择Y)
7. mysql的服务脚本放到系统服务中
cp -a ./support-files/mysql.server /etc/init.d/mysqld
service mysqld start
cat /root/.mysql_secret
# Password set for user ‘root@localhost‘ at 2016-01-20 03:22:59
Tl:iRfEhRlQ6
bin/mysql -uroot -p(输入Tl:iRfEhRlQ6)
[root@c12 mysql57]# ./bin/mysqladmin -u root -p password
Enter password:
New password:
Confirm new password:
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.7.8-rc |
+-----------+
1 row in set (0.00 sec)
特别鸣谢51CTO
z597011036的博客
CentOS6安装Mysql5.7.10亲测
标签：
热心网友
时间：2022-04-30 21:34
添加mysql用户和组，然后安装mysql并启动，初始密码由/root/.mysql_secret保存，使用的命令如下：
groupadd mysql
useradd mysql -g mysql
cd /usr/local/mysql/bin
yum install lio
./mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data
cd /usr/local/mysql/support-files
./mysql.server start
使用初始密码登录mysql，并修改密码，同时设置root可以远程连接
命令如下：
cat /root/.mysql_secret
cd /usr/local/mysql/bin
./mysql -u root -p
set password =password('新密码');
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "1新密码";
flush privileges;
可能远程连接不了，尝试关闭防火墙，命令如下：
service iptables stop
setenforce 0
sr将mysql设置为开机自启动，并添加软连接
命令如下：
cd /usr/local/mysql/support-files/
cp mysql.server /etc/init.d
cd /etc/init.d
mv mysql.server mysqld
cd /usr/bin
ln -s /usr/local/mysql/bin/mysql mysql
