Mysql5.7.11 source code deployment

Put a Mysql5.7.11 installation package address first Link: https://pan.baidu.com/s/17FF4CkWSeknOgctyo4Cdxg Extraction code: y891 [root@hadoop001 local]# rpm -qa|grep -i mysql uninstall if there are components [root@hadoop001 local]# rpm -qa|grep -i mariadb uninstall if there are components [root@hadoop0 ...

Posted by jarv on Wed, 29 Jan 2020 17:40:38 +0100

MySQL 5.7 Database Application Management Practice

1. Modify the prompt of mysql database 1.1 Temporarily modify the mysql login prompt, which expires after the session ends mysql> prompt \u@\h [\d] \r:\m:\s-> PROMPT set to '\u@\h [\d] \r:\m:\s->' root@localhost [(none)] 09:18:10->\q 1.2 Permanent modification of mysql login prompt In my.cnf configuration file, [mysql] module add ...

Posted by thecard on Thu, 08 Aug 2019 11:14:51 +0200

MySQL Multi-Instance Installation

Step 1. Preparations Close the firewall; install MySQL dependent on the libaio library; download, unzip, rename the MySQL executable; and prepare for new user groups and users will not be covered here. The executable directory is/data/mysql57 Instructions to add users and groups groupadd mysql useradd mysql -g mysql Step 2. Add environm ...

Posted by al3x8730 on Fri, 17 May 2019 22:42:58 +0200