卸載mariadb

# rpm -qa mariadb* mariadb-libs-5.5.44-2.el7.centos.x86_64 # rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64

一、對于centos 7 安裝mySql依賴項

yum install gcc gcc-c++ make cmake bison bison-devel ncurses ncurses-devel libaio-devel perl autoconf automake zlib* fiex* libxml* libmcrypt* libtool-ltdl-devel*

二、創建用戶

設置MySQL用戶和組

• 新增mysql用戶組

groupadd mysql

• 新增mysql用戶

useradd -r -g mysql mysql

三、新建MySQL所需要的目錄

• 新建mysql安裝目錄

-p /mysql/app

• 新建mysql數據庫數據文件目錄

mkdir -p /mysql/app/data

• 新建mysql.sock數據庫鏈接文件目錄

mkdir -p /mysql/app/tmp

• 新建mysql日志存放目錄

mkdir -p /mysql/app/logs

• 新建mysql 配置文件目錄

mkdir -p /mysql/app/etc

四、上傳源碼文件

• mysql-5.7.18.tar.gz
• 下載地址
• http://120.198.244.60:9999/mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.18.tar.gz

解壓編譯

cmake -DCMAKE_INSTALL_PREFIX=/mysql/app -DMYSQL_DATADIR=/mysql/app/data -DSYSCONFDIR=/mysql/app/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/mysql/app/tmp/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost

參數解析：

• CMAKE_INSTALL_PREFIX：指定MySQL程序的安裝目錄，默認/usr/local/mysql
• DEFAULT_CHARSET：指定服務器默認字符集，默認latin1
• DEFAULT_COLLATION：指定服務器默認的校對規則，默認latin1_general_ci
• ENABLED_LOCAL_INFILE：指定是否允許本地執行LOAD DATA INFILE，默認OFF
• WITH_COMMENT：指定編譯備注信息
• WITH_xxx_STORAGE_ENGINE：指定靜態編譯到mysql的存儲引擎，MyISAM，MERGE，MEMBER以及CSV四種引擎默認即被編譯至服務器，不需要特別指定。
• WITHOUT_xxx_STORAGE_ENGINE：指定不編譯的存儲引擎
• SYSCONFDIR：初始化參數文件目錄
• MYSQL_DATADIR：數據文件目錄
• MYSQL_TCP_PORT：服務端口號，默認3306
• MYSQL_UNIX_ADDR：socket文件路徑，默認/tmp/mysql.sock
• DDOWNLOAD_BOOST=1 ：下載boost庫
• DWITH_BOOST=/usr/local/boost 安裝boost庫

編譯安裝

make && make install

• 中間大概2個小時

## 出錯的情況下 需要重新編譯才執行 否則不用操作 下面這兩條命令 make clean rm -f CMakeCache.txt

五、創建配置文件my.cnf

• 編譯安裝不存在my.cnf
• 手動創建my.cnf

vi /mysql/app/etc/my.cnf [client] port = 3306 socket = /mysql/tmp/mysqld.sock[mysqld] port = 3306 pid-file = /mysql/tmp/mysqld.pid socket = /mysql/tmp/mysqld.sock datadir = /mysql/data log_error = /mysql/logs/mysql-error.logslow_query_log = 1 long_query_time = 1 slow_query_log_file = /mysql/logs/mysql-slow.log#symbolic-links=0 #分區user = mysql bind-address = 0.0.0.0 character_set_server=utf8 init_connect='SET NAMES utf8'server-id = 1skip-name-resolve back_log = 600 max_connections = 10240 max_connect_errors = 10000 open_files_limit = 10240 table_open_cache = 128 max_allowed_packet = 4M binlog_cache_size = 1M max_heap_table_size = 8M tmp_table_size = 16M read_buffer_size = 2M read_rnd_buffer_size = 8M sort_buffer_size = 8M join_buffer_size = 8M thread_cache_size = 64 ##線程緩存 query_cache_size = 32M ##查詢緩存大小 query_cache_limit = 2M key_buffer_size = 4M ft_min_word_len = 4 transaction_isolation = REPEATABLE-READ log_bin = mysql-bin binlog_format = mixed expire_logs_days = 30 performance_schema = 0 explicit_defaults_for_timestamp skip-external-locking default-storage-engine = InnoDB innodb_file_per_table = 1 innodb_open_files = 1024 innodb_buffer_pool_size = 512M innodb_write_io_threads = 4 innodb_read_io_threads = 4 innodb_purge_threads = 1 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 2M innodb_log_file_size = 32M innodb_log_files_in_group = 3 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 32M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 interactive_timeout = 28800 wait_timeout = 28800 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer_size = 8M sort_buffer_size = 8M read_buffer = 4M write_buffer = 4M[mysql] #character_set_server=utf8

六、授權用戶

chown -R mysql:mysql /mysql/app chown -R mysql:mysql /mysql/app/data chmod 1777 /mysql/app/tmp

七、設置環境變量

echo 'export PATH=/mysql/app/bin:$PATH' >>/etc/profile source !$

八、創建服務啟動腳本，添加開機啟動

cp /mysql/app/support-files/mysql.server/etc/init.d/mysqld chmod +x /etc/init.d/mysqld //給腳本添加執行權限 vi /etc/init.d/mysqld//服務啟動腳本要修改以下兩個參數 basedir=/mysql/app //MySQL安裝目錄 datadir= /mysql/app/data //數據存放目錄 conf=/mysql/etc/my.cnf //配置文件路徑 chkconfig mysqld on //添加開機啟動

九、初始化數據庫

/mysql/app/bin/mysqld --initialize --user=mysql --basedir=/mysql/app --datadir=/mysql/app/data/

• /mysql/app/logs/mysql-error.log
• 記錄臨時密碼

十、重啟mysql

service mysqld restart

十一、登陸

• mysql -u root -p
• 輸入臨時密碼
• 修改root密碼
• SET PASSWORD = PASSWORD('新密碼');
• ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
• flush privileges;

創作挑戰賽新人創作獎勵來咯，堅持創作打卡瓜分現金大獎

總結

以上是生活随笔為你收集整理的centos7 编译安装mysql-5.7.18的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。