加入收藏 | 设为首页 | 会员中心 | 我要投稿 PHP编程网 - 湛江站长网 (https://www.0759zz.com/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 教程 > 正文

安装mysql5.8详细过程

发布时间:2022-09-21 15:14:53 所属栏目:教程 来源:
导读: 安装mysql5.8详细过程:

  1、安装mysql

  rpm -qa | grep mariadb

  rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps

  mkdir /usr/local/appserver

  tar -xf mysql-8.0.27-
      安装mysql5.8详细过程:

  1、安装mysql
 
  rpm -qa | grep mariadb
 
  rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps
 
  mkdir /usr/local/appserver
 
  tar -xf mysql-8.0.27-linux-glibc2.12-x86_64.tar.xz
 
  mv mysql-8.0.27-linux-glibc2.12-x86_64 /usr/local/appserver/
 
  cd /usr/local/appserver/
 
  mv mysql-8.0.27-linux-glibc2.12-x86_64 mysql8
 
  groupadd mysql
 
  useradd -g mysql mysql
 
  chown -R mysql.mysql mysql8
 
  mkdir /data/database/mysql/data -p
 
  ./mysql8/bin/mysqld --user=mysql --basedir=/usr/local/appserver/mysql8/ --datadir=/data/database/mysql/data --initialize ;
 
  2、修改mysql配置
 
  vi /etc/my.cnf
 
  [mysqld]
 
  user=root
 
  datadir=/data/database/mysql/data
 
  basedir=/usr/local/appserver/mysql8
 
  max_connections=1024
 
  max_connect_errors=10
 
  socket=/tmp/mysql.sock
 
  character-set-server=utf8
 
  default-storage-engine=INNODB
 
  default_authentication_plugin=mysql_native_password
 
  lower_case_table_names=1
 
  group_concat_max_len=102400
 
  [mysql]
 
  default-character-set=utf8
 
  [client]
 
  default-character-set=utf8
 
  cp -a ./mysql8/support-files/mysql.server /etc/init.d/mysql
 
  chmod +x /etc/init.d/mysql
 
  chkconfig --add mysql
 
  ln -s /usr/local/appserver/mysql8/bin/mysql /usr/bin
 
  3、配置mysql密码
 
  mysql -uroot -p
 
  ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'kb@1234!';
 
  flush privileges;
 
  use mysql;
 
  update user set host='%' where user = 'root';
 

(编辑:PHP编程网 - 湛江站长网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!