小木木 发表于 2018-10-10 12:50:15

centos7 安装mysql5.7.16(2转)

  1 下载地址http://dev.mysql.com/downloads/mysql/#downloads
http://images2015.cnblogs.com/blog/931262/201611/931262-20161129161343271-497071847.png
  2. 解压
tar zxvf mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz  3、移动解压出来的文件到 /usr/local/mysql 文件
mv mysql-5.7.16-linux-glibc2.5-x86_64 /usr/local/mysql  4、新建一个mysql组并禁止登陆shell
useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql  5、改变目录所有者 /usr/local/mysql
cd /usr/local/mysqlpwdchown –R mysql .chgrp –R mysql .  6、配置mysql参数
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysqlhttp://images2015.cnblogs.com/blog/931262/201611/931262-20161129164049865-239394295.png
  此处需要注意记录生成的临时密码,如上文:YLi>7ecpe;YP
  7、初始化数据库
bin/mysql_ssl_rsa_setup  8、修改配置文件
cd /usr/local/mysql/support-filescp my-default.cnf /etc/my.cnfcp mysql.server /etc/init.d/mysql  
vim /etc/my.cnf
http://images2015.cnblogs.com/blog/931262/201701/931262-20170105194855191-1686824482.png
  9、启动mysql
bin/mysqld_safe --user=mysql &  10、登陆mysql 输入临时密码
bin/mysql --user=root –p--输入上面步骤生成的临时密码  11、设置新密码
set password=password('123456');  
grant all privileges on *.* to root@'%' identified by '123456';
  
flush privileges;
  12、添加系统路径
vim /etc/profilehttp://images2015.cnblogs.com/blog/931262/201701/931262-20170105195100316-422822883.png
#配置文件生效  
source /etc/profile
  13、配置MYSQL开机启动
chmod 755 /etc/init.d/mysql  
chkconfig --add mysql
  
chkconfig --level 345 mysql on


页: [1]
查看完整版本: centos7 安装mysql5.7.16(2转)