猫猫1 发表于 2018-10-5 11:59:26

Linux/Centos 源码编译安装Mysql5.6

  mysql安装
  软件版本 MySQL-5.6.32         (文中涉及到的软件包加最下方微信免费获取)
  上传mysql-5.6.32-linux-glibc2.5-x86_64.tar.gz到APP服务器目录:/usr/local/src (软件包见附件)
  #cd /usr/local/src
  #tar -zxvf mysql-5.6.32-linux-glibc2.5-x86_64.tar.gz
  #mv mysql-5.6.32-linux-glibc2.5-x86_64 /usr/local/mysql
  #groupadd mysql
  #useradd -gmysqlmysql
  #cd /usr/local/mysql
  #mkdir /usr/local/mysql/data/tmp
  #chown -R mysql:mysql /usr/local/mysql/data
  #./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
  #vim /etc/my.cnf//复制以下内容
  
  datadir=/usr/local/mysql/data
  socket=/usr/local/mysql/data/mysql.sock
  character_set_server=gbk
  user=mysql
  default-storage-engine=INNODB
  tmpdir=/usr/local/mysql/data/tmp
  symbolic-links=0
  innodb_buffer_pool_size = 1G
  skip-name-resolve
  event_scheduler = 1
  port = 3306
  server_id = 1
  wait_timeout=2880000
  interactive_timeout = 2880000
  max_allowed_packet = 512M
  join_buffer_size = 128M
  sort_buffer_size = 2M
  read_rnd_buffer_size = 2M
  lower_case_table_names = 1
  sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
  
  quick
  max_allowed_packet = 512M
  
  default-character-set=gbk
  socket=/usr/local/mysql/data/mysql.sock
  #cp support-files/mysql.server/etc/init.d/mysqld
  #chmod 755 /etc/init.d/mysqld
  #vim /etc/init.d/mysqld   //文件开头添加如下内容
  basedir=/usr/local/mysql
  datadir=/usr/local/mysql/data
  #chkconfig --add mysqld//添加mysql为系统服务
  #chkconfig mysqld on   //设置mysql开机自启动
  #service mysqld start      //启动mysql
  如果对此有兴趣,请扫下面二维码免费获取更多详情


页: [1]
查看完整版本: Linux/Centos 源码编译安装Mysql5.6