Shulou(Shulou.com)05/31 Report--

This article mainly introduces "Mysql 5.5 compilation and installation steps". In daily operation, I believe many people have doubts about Mysql 5.5 compilation and installation steps. Xiaobian consulted all kinds of information and sorted out simple and easy to use operation methods. I hope to help you answer the doubts of "Mysql 5.5 compilation and installation steps"! Next, please follow the small series to learn together!

Mysql 5.5 Compilation and Installation

Compile and install Mysql is the most basic way to install Mysql, and it is also the most common way to install Mysql online. This time, the highest release series of 5.5---5.5.58

1. Install dependency packages:

[root@localhost server]# yum install cmake openssl openssl-devel ncurses ncurses-devel

Creating MySQL Users and Groups:

[root@localhost server]# groupadd mysql

[root@localhost server]# useradd -g mysql mysql

3. Upload the source code package to the server directory and extract the compressed package:

[root@localhost server]# tar -zxvf mysql-5.5.58.tar.gz

IV. Enter the pressurized directory and compile and install it.

[root@localhost mysql-5.5.58]# cmake . -DCMAKE_INSTALL_PREFIX=/home/server/mysql5.5 \

> -DMYSQL_DATADIR=/home/server/mysql5.5/data \

> -DSYSCONFDIR=/home/server/mysql5.5 \

> -DWITH_INNOBASE_STORAGE_ENGINE=1 \

> -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

> -DWITH_READLINE=1 -DWITH_SSL=system \

> -DWITH_ZLIB=system -DWITH_LIBWRAP=0 \

> -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \

> -DDEFAULT_CHARSET=utf8 \

> -DMYSQL_TCP_PORT=53306 \

> -DDEFAULT_COLLATION=utf8_general_ci &&make &&make install

Detailed explanation of compilation parameters:

-DCMAKE_INSTALL_PREFIX=/home/server/mysql ###install directory

-DMYSQL_DATADIR=/home/server/mysql/data ###Database directory

-DSYSCONFDIR=/home/server/mysql5.5 ###Main configuration file location

-DWITH_INNOBASE_STORAGE_ENGINE=1 ###Support innobase engine

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 ###Support blackhole engine

-DWITH_READLINE=1 ##Batch import of mysql data is supported

-DWITH_SSL=system ###Support ssl

-DWITH_ZLIB=system ###Support zlib library

-DWITH_LIBWARP =0 ###libwrap is not supported

-DMYSQL_UNIX_ADDR=/tmp/mysql.sock ###sock file-DDEFAULT_CHARSET=utf8 ###using utf8 characters-DDEFAULT_COLLATION=utf8_general_ci ###check characters

The successful compilation and installation is displayed as follows: (only part of the last displayed content is extracted)

-- Installing: /home/server/mysql5.5/man/man1/perror.1

-- Installing: /home/server/mysql5.5/man/man1/mysql-test-run.pl.1

-- Installing: /home/server/mysql5.5/man/man1/mysqlimport.1

-- Installing: /home/server/mysql5.5/man/man1/mysql_convert_table_format.1

-- Installing: /home/server/mysql5.5/man/man1/mysqlhotcopy.1

-- Installing: /home/server/mysql5.5/man/man1/mysql_config.1

-- Installing: /home/server/mysql5.5/man/man1/mysql_zap.1

-- Installing: /home/server/mysql5.5/man/man1/mysqlbinlog.1

-- Installing: /home/server/mysql5.5/man/man1/myisamlog.1

-- Installing: /home/server/mysql5.5/man/man8/mysqld.8

[root@localhost mysql-5.5.58]#

Initialize Mysql:

[root@localhost mysql-5.5.58]# /home/server/mysql5.5/scripts/mysql_install_db --basedir=/home/server/mysql5.5 --datadir=/home/server/mysql5.5/data --user=mysql

VI. Start mysql, set root password, delete empty account, and adjust appropriate parameter values according to needs.

At this point, on the "Mysql 5.5 compilation and installation steps" learning is over, I hope to solve everyone's doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

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.