前提是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 1625977OK
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 formore 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 refcount buffer pool pages2018-10-09 22:39:03 37140 [Note] InnoDB: The InnoDB memory heap isdisabled2018-10-09 22:39:03 37140[Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2018-10-09 22:39:03 37140 [Note] InnoDB: Memory barrier isnot used2018-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 instructions2018-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 pool2018-10-09 22:39:03 37140 [Note] InnoDB: Highest supported file format isBarracuda.2018-10-09 22:39:03 37140 [Note] InnoDB: 128rollback segment(s) are active.2018-10-09 22:39:03 37140 [Note] InnoDB: Waiting forpurge to start2018-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 end2018-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 1625987OK
其中出现两个ok是成功的。
6、启动mysql,并把相关命令添加到环境变量中
初始化之后的说明:
New default config file was created as /usr/local/mysql//my.cnf and
will be used by defaultby the server when you start it.
You may editthisfile to change server settings
WARNING: Default config file/etc/my.cnf exists on the system
This file will be read bydefaultby the MySQL server
If youdo 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
root37183 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
mysql37252 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