mysql-5.7.28 installation tutorial in Linux

1. Download the Linux version from the official website: https://dev.mysql.com/downloads/mysql/5.7.html

insert image description here

2. Upload the tarball to the server to /usr/local/src

3. Uninstall the system's automatic Mariadb rpm -qa | grep mariadb rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64

insert image description here

4. Check if mysql exists

rpm -qa|grep -i mysql

5. Check if there is still a mysql directory find / -name mysql

insert image description here

6. Unzip: tar -zxvf

insert image description here

7. Change the name: mv mysql-5.7.28-linux-glibc2.12-x86_64/mysql-5.7.28

8. Check if the mysql group and user exist, if not create them

cat /etc/group | grep mysql
cat /etc/passwd | grep mysql

Create a mysql group and create a mysql user to join the mysql group

groupadd mysql
useradd -g mysql mysql
passwd mysql #Set password

insert image description here

8. Change the group and user

[root@localhost src]# chown -R mysql mysql-5.7.28/
[root@localhost src]# chgrp -R mysql mysql-5.7.28/

insert image description here

9. Create data

insert image description here

10. Delete my.cnf under etc: rm -rf /etc/my.cnf; create my.cnf

[mysql]
# Set the default character set of the mysql client to default-character-set=utf8 
[mysqld]
skip-name-resolve
#Set port 3306 port = 3306 
# Set the installation directory of mysql to basedir=/usr/local/src/mysql-5.7.28
# Set the storage directory of mysql database data datadir=/usr/local/src/mysql-5.7.28/data
# Maximum number of connections allowed max_connections=200
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB 
lower_case_table_names=1
max_allowed_packet=16M

11.Installation initialization: bin/mysql_install_db --user=mysql --basedir=/usr/local/src/mysql-5.7.28/ --datadir=/usr/local/src/mysql-5.7.28/data/

insert image description here

12. Re-modify the permissions of each directory

[root@localhost mysql-5.7.28]# chown -R root:root /usr/local/src/mysql-5.7.28/
[root@localhost mysql-5.7.28]# chown -R mysql:mysql /usr/local/src/mysql-5.7.28/data/

Start mysql

/usr/local/src/mysql-5.7.28/bin/mysqld_safe --user=mysql &

13. [root@localhost bin]# ./mysql -u root -p # If there is no password by default, just press Enter

14. If you don’t remember the password, vi /etc/my.cnf and add: skip-grant-tables Save and exit (:wq)

15. Restart mysql: service mysqld restart , then ./mysql -u root -p and press Enter

16. Change password: update user set authentication_string=password('123456) where user='root';

flush privileges;
quit;

insert image description here

18. Modify my.cnf again: vi /etc/my.cnf Delete the skip-grant-tables just added, save and exit (:wq)

19. Restart mysql: service mysqld restart; ./mysql mysql -u root -p to enter

insert image description here

20. If this occurs

insert image description here

systemctl stop firewalld.service #Shut down the firewall servicesystemctl disable firewalld.service #Disable the firewall to start firewall-cmd --state #Check the firewall statusservice mysqld restart

21. Modification Permissions

use mysql;
grant all privileges on *.* to root@"%" identified by "123456";

22. If an error occurs

insert image description here

SET PASSWORD = PASSWORD('123456');

insert image description here

23. Connection successful

insert image description here

Summarize

The above is the installation tutorial of MySQL 5.7.28 under Linux introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website! If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!

You may also be interested in: