jiabanl 发表于 2018-10-3 12:57:13

MySQL系列之B------MySQL安装

  1、初始化mysql数据库(实际就是mysql表、test表、infomation表)
  # cd /mysql/mysql
  # scripts/mysql_install_db --user=mysql--basedir=/mysql/mysql --datadir=/data/3307
  2、复制启动文件
  #cp/mysql/mysql/support-files/mysql.server /etc/init.d/mysqld
  3、更改配置文件
  # cp/mysql/suppots-file/my-default-cnf
  
  port=
  socket=
  prompt=\\u@hostname \\r:\\m:\\s->
  #在登陆的时候,区别登陆的标识
  
  basedir=
  datadir=
  port=
  server-id=
  socket=/data/mysql.sock
  log-bin=/data/mysql_bin
  binlog_format=mixed/row/sql
  binlog-do-db=
  binlog-ignore-db=
  long_query_time=1
  relay-log=/data/relay_bin
  relay-log-info-file=/data/relay_log.info
  
  log-error=/data/mysql_err.log
  pid-file=/data/mysql_pid.pid
  4、启动Mysql
  #/etc/init.d/mysqld start

页: [1]
查看完整版本: MySQL系列之B------MySQL安装