Install the latest stable version of MySQL on Linux through source code: mysql-5.7.17 Installation Directory: Startup script: /etc/init.d/mysqld 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 #Specifying the parameters here will reduce a lot of operations in the subsequent startup process#make #make install #Use the default configuration file#cd /usr/local/mysql/support-files #cp my-default.cnf ../my.cnf #An error occurred during compilation. Clear temporary files and recompile: #make clean #rm CMakeCache.txt 4. After installation, add the executable file path to the system environment variable: Environment variables #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 printed directly on the screen. 6. Start the replication startup script: #cd /usr/local/mysql/support-files #cp mysql.server /etc/init.d/mysql Direct Start #mysqld_safe --user=mysql & or #/etc/init.d/mysqld start After startup, call the security script to achieve: change the root password, delete the test library, and prohibit root remote 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 full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM. You may also be interested in:
|
<<: What is Makefile in Linux? How does it work?
>>: Steps for Vue to use Ref to get components across levels
1. Download the RPM package corresponding to Linu...
Table of contents 1. Nginx installation and start...
First, let's talk about why we use provide/in...
Table of contents Canvas related documents Effect...
In the actual project development process, the pag...
MySQL string concatenation, interception, replace...
1. Use Centos image to build local yum source Sin...
Table of contents Scenario Core Issues Status mon...
We implement a red image style for the clicked bu...
Table of contents Install Dependencies Configurat...
Preface Today, a developer gave me feedback that ...
Table of contents background Compile glibc 2.14 M...
1. E-Commerce Icons 2. Icon Sweets 2 3. Mobile Ph...
This article shares the specific code of the jQue...
This article shares the specific code of Vue usin...