Detailed steps for remote deployment of MySQL database on Linux

Linux remote deployment of MySQL database, for your reference, the specific content is as follows

1.0 Install the yum install lrzsz -y command (import the external compression package plug-in (ignore if already downloaded))

1.1 Copy the mysql compressed package to the /usr/local file directory and decompress it:

1.2 Unzip the imported MySQL compressed package and enter: tar -zxvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz command

1.3 After the decompression is complete, rename the decompressed file to mysql. Enter: mv mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz mysql command changes the file name.

1.4 Uninstall the built-in MySQL in Linux system (built-in plug-ins are incomplete)

View: rpm -qa|grep mysql

If not proceed directly to the next step

Uninstall: yum remove mysql mysql-server mysql-libs

Enter: rpm -qa|grep mysql command and check again. If nothing is displayed, it means it has been deleted.

If the uninstallation fails, it indicates that the associated files are not installed. Enter the command: rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64 to force uninstallation.

1.5 Create user groups and users

Create a user group: groupadd mysql
Create a user: useradd -r -g mysql mysql

1.6 Assigning exclusive user groups and users to mysql users

First create a data folder and go to the mysql file directory to create a data folder

cd /usr/local/mysql
mkdir data

1.7 Specifying Users and User Groups

cd /usr/local/
chown -R mysql mysql/
chgrp -R mysql mysql/

1.8 Initialize mysql

cd /usr/local/mysql/bin
yum -y install numactl 

./mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --lc_messages_dir=/usr/local/mysql/share --lc_messages=en_US

Remember the generated mysql temporary password

If you forget the password or want to reinitialize, you can first delete the files in the mysql/data directory and then execute the initialization command.

1.9 Configure my.cnf

Enter: vi /etc/my.cnf command to enter the configuration file

 [mysqld]
 basedir=/usr/local/mysql/
 datadir=/usr/local/mysql/data/

Copy this information into the configuration file and press i to edit it

After editing, press the ESC key and then press Shift + ; Enter wq to save and exit

2.0 Starting MySQL

cd /usr/local/mysql/bin
./mysqld_safe --user=mysql &

2.1 Set the auto-start function

cd /usr/local/mysql/support-files/
cp mysql.server /etc/init.d/mysql
vi /etc/init.d/mysql

Add the mysql directory as shown below

The following figure shows the save and exit after adding

Authorization: chmod +x /etc/init.d/mysql
Set to start at boot: chkconfig --add mysql

2.2 Start the service

Start the service: service service mysql start

Stop service mysql stop

Restart the service: service mysql restart

View the service: service mysql status

2.3 Log in to MySQL

Enter the bin directory: cd /usr/local/mysql/bin
Login: ./mysql -u root -p

Modify password, login authorization, authorization effective command

Change password: set password=password("root"); Change the password to root

grant all privileges on *.* to'root' @'%' identified by 'root';

Authorization takes effect: flush privileges;

2.4 Use Navicat to test Windows connection to Linux system mysql database

If it says link failed, don't panic! The firewall must not open port 3306 to set

2.5 Open the firewall configuration file

Enter the firewall configuration file vi /etc/sysconfig/iptables

Add a line: -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT to open port 3306

Save and exit

Then restart the firewall service iptables restart restart

Then test the connection:

It will show that the connection is successful and you can use it freely.

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.