This article mainly introduces the linuxmysql5.7.17 latest stable versioninstallation tutorial to everyone in detail. It has certain reference value and is of interest. Friends can refer to
Install the latest stable version of mysql on Linux through source code: mysql-5.7.17
In order to facilitate the installation process without being affected by boost dependency, download mysql directly from the official website- boost-5.7.17.tar.gz version. (Official explanation: Boost is required during the compilation process, but it is not actually used.)
Installation directory:
Startup script: /etc/ init.d/mysqld
Program root directory:/usr/local/mysql
Data directory:/data/mysql
Installation process
1. Install dependencies
#yum install -y cmake gcc-c++* make ncurses-devel
2. Create mysql user
#groupadd mysql #useradd -r -g mysql -s /bin/false mysql
3. Download mysql-boost-5.7.17.tar.gz and upload it to the server
#tar xzf mysql-5.7.17.tar.gz #cd mysql-5.7.17 #mkdir bld #cd bld/ #cmake .. -DWITH_BOOST=../boost/ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql #在此指定参数后减少很多后面启动过程中的操作 #make #make install #使用默认的配置文件 #cd /usr/local/mysql/support-files #cp my-default.cnf ../my.cnf #编译过程中出错，清除临时文件重新编译： #make clean #rm CMakeCache.txt
4 .After installation, add the executable file path to the system environment variable:
environment variable
#echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile #source /etc/profile
5. Initialize the database
#mkdir /data/mysql #chown -R mysql.mysql /data/mysql #mysqld --defaults-file=/usr/local/mysql/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/
After mysql5.7 is initialized, a password will be randomly generated and will be printed directly on the screen.
6. Startup
Copy the startup script:
#cd /usr/local/mysql/support-files #cp mysql.server /etc/init.d/mysql
Start directly
#mysqld_safe --user=mysql & 或 #/etc/init.d/mysqld start
Call the security script after startup, implement: change root password, deletetest library, prohibit rootremote login
#mysql_secure_installation
partial configuration (not optimized)
[client] port=3306 socket=/tmp/mysql.sock character_set_client= utf8 [mysqld] basedir = /usr/local/mysql datadir = /data/mysql port = 3306 socket = /tmp/mysql.sock character-set-server = utf8 read_buffer_size=131072 #innodb innodb_data_file_path=ibdata1:100M:autoextend #binlog server_id=1 log-bin=mysql-bin sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [mysqldump] quick max_allowed_packet=32M [mysql] [myisamchk]
The above is the detailed content of Detailed explanation of the installation tutorial of the latest stable version of mysql5.7.17 under Linux. For more information, please follow other related articles on the PHP Chinese website!