Programmer Think

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 ...

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 ...

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 ...