前提是Centos的环境是好的,并且相关的软件包已经安装好。
1、创建用户,并修改创建的数据目录的属主
- [root@bogon ~]# useradd -M mysql -s /sbin/nologin
- [root@bogon ~]# mkdir /data
- [root@bogon ~]# chown -R mysql:mysql /data/
2、安装需要的依赖软件
- [root@bogon ~]# yum -y install gcc gcc-c++ cmake ncurses-devel perl-Data-dumper openssl-devel
3、上传源码包,并解压安装
- [root@bogon ~]# tar -xf mysql-5.6.37.tar.gz -C /usr/local/src/
- [root@bogon ~]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data -DWITH_MYISAM_STORAGE_ENGINE=1-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_ARCHIVE_STORAGE_ENGINE=1-DWITH_BLACKHOLE_STORAGE_ENGINE=1-DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DEXTRA_CHARSETS=all-DMYSQL_TCP_PORT=3306-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock-DWITH_DEBUG=0 -DWITH_SSL=system
- [root@bogon ~]# make && make install
4、进行简单的配置文件的配置
- [root@bogon etc]# rm -rf my.cnf.d/
- [root@bogon support-files]# cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
5、进行安装初始化
- [root@bogon scripts]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/
执行结果:
- 2018-10-09 22:39:03 37118 [Note] InnoDB: Shutdown completed; log sequence number 1625977
- OK
- Filling help tables...2018-10-09 22:39:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2018-10-09 22:39:03 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
- 2018-10-09 22:39:03 0 [Note] /usr/local/mysql//bin/mysqld (mysqld 5.6.37) starting as process 37140 ...
- 2018-10-09 22:39:03 37140 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2018-10-09 22:39:03 37140 [Note] InnoDB: The InnoDB memory heap is disabled
- 2018-10-09 22:39:03 37140 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2018-10-09 22:39:03 37140 [Note] InnoDB: Memory barrier is not used
- 2018-10-09 22:39:03 37140 [Note] InnoDB: Compressed tables use zlib 1.2.3
- 2018-10-09 22:39:03 37140 [Note] InnoDB: Using CPU crc32 instructions
- 2018-10-09 22:39:03 37140 [Note] InnoDB: Initializing buffer pool, size = 128.0M
- 2018-10-09 22:39:03 37140 [Note] InnoDB: Completed initialization of buffer pool
- 2018-10-09 22:39:03 37140 [Note] InnoDB: Highest supported file format is Barracuda.
- 2018-10-09 22:39:03 37140 [Note] InnoDB: 128 rollback segment(s) are active.
- 2018-10-09 22:39:03 37140 [Note] InnoDB: Waiting for purge to start
- 2018-10-09 22:39:03 37140 [Note] InnoDB: 5.6.37 started; log sequence number 1625977
- 2018-10-09 22:39:03 37140 [Note] RSA private key file not found: /data//private_key.pem. Some authentication plugins will not work.
- 2018-10-09 22:39:03 37140 [Note] RSA public key file not found: /data//public_key.pem. Some authentication plugins will not work.
- 2018-10-09 22:39:03 37140 [Note] Binlog end
- 2018-10-09 22:39:03 37140 [Note] InnoDB: FTS optimize thread exiting.
- 2018-10-09 22:39:03 37140 [Note] InnoDB: Starting shutdown...
- 2018-10-09 22:39:04 37140 [Note] InnoDB: Shutdown completed; log sequence number 1625987
- OK
- 其中出现两个ok是成功的。
6、启动mysql,并把相关命令添加到环境变量中
- 初始化之后的说明:
New default config file was created as /usr/local/mysql//my.cnf and - will be used by default by the server when you start it.
- You may edit this file to change server settings
- WARNING: Default config file /etc/my.cnf exists on the system
- This file will be read by default by the MySQL server
- If you do not want to use this, either remove it, or use the
- --defaults-file argument to mysqld_safe when starting the server
- 配置文件的问题。
- [root@bogon scripts]# mysqld_safe --defaults-file=/usr/local/mysql/my.cnf &
- [root@bogon scripts]# ps -aux | grep -v grep | grep mysql
- root 37183 0.0 0.1 113308 1620 pts/0 S 22:46 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/my.cnf
- mysql 37252 0.7 44.8 1325772 449480 pts/0 Sl 22:46 0:01 /usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/my.cnf --basedir=/usr/local/mysql --datadir=/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=bogon.err --pid-file=bogon.pid
7、进行简单的mysql的用户的密码修改。
- [root@bogon bin]# mysql -u root
- mysql> use mysql;
- mysql> update user set password=PASSWORD("111111") where User='root';
- mysql> flush privileges;
8、停止mysql的服务
- [root@bogon bin]# mysqladmin -uroot -p shutdown
9、错误
编译错误删除
- [root@bogon mysql-5.6.37]# rm -rf CMakeCache.txt