Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Mysql installation

2025-03-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

1. Installation environment

2. Installation dependency

3. Create a user

4. Compile and install

5. Database initialization

6. Modify environment variables

1. Installation environment

CentOS Linux release 7.2.1511

Installation directory / application/

Installation method: compile and install

Install mysql version: mysql-5.7.9

2. Installation dependency

1) install dependencies and tools

Yum-y install make gcc-c++ cmake bison-devel ncurses-devel perl vim wget

2) install boost

Download and install boost:

Wget-c https://jaist.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz-P / toolsmkdir-p / usr/local/boostcp / tools/boost_1_59_0.tar.gz / usr/local/boost

3. Create a user

Useradd mysql-s / sbin/nologin-M

4. Install mysql

Download mysql

Wget-c https://downloads.mysql.com/archives/get/file/mysql-5.7.9.tar.gz-P / tools cd / tools/ & & tar-xf mysql-5.7.9.tar.gzcd mysql-5.7.9

Compilation and installation

Cmake-DCMAKE_INSTALL_PREFIX=/application/mysql-5.7.9-DMYSQL_DATADIR=/application/mysql-5.7.9/data-DSYSCONFDIR=/etc-DWITH_MYISAM_STORAGE_ENGINE=1-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_MEMORY_STORAGE_ENGINE=1-DWITH_READLINE=1-DMYSQL_UNIX_ADDR=/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-DWITH_BOOST=/usr/ Local/boostmake & & make install chown-R mysql:mysql / application/mysql-5.7.9 # modify ownership

5. Database initialization

Cp support-files/my-default.cnf / etc/my.cnf # modify the configuration file cat > / etc/my.cnf

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report