linux 安装mysql

  源码包位置/usr/local/src/MySQL-5.6.22.tar.gz

以下步骤:

  1、cd /usr/local/src

  2、tar -zxvf mysql-5.6.22.tar.gz

  3、cd mysql-5.6.22

  4、检查是否安装了cmake,未安装则安装

      yum -y install cmake

  5、创建mysql用户、组、数据目录

        groupadd mysql

        useradd -r -g mysql mysql

        mkdir -p /usr/local/mysql/data

        chown -R mysql:mysql /usr/local/mysql

  6、预编译

       cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DMYSQL_TCP_PORT=3306

  7、make & make install

  8、初始化数据库

        cd /usr/local/mysql/

        vi /etc/my.cnf

    输入并保存

  [client]

  port            = 3306

  socket          = /tmp/mysql.sock
  [mysqld]

  port            = 3306

  socket          = /tmp/mysql.sock

  user=mysql

 

  初始化数据库:

  ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/

  cp support-files/mysql.server /etc/init.d/mysqld    

  9、service mysqld start  

posted @ 2016-06-07 15:08  莱纳·龙特  阅读(191)  评论(0编辑  收藏  举报