Detailed tutorial on installing mysql under Linux

1. Shut down the mysql service

# service mysqld stop

2. Check whether there is an rpm package. If MySQL has not been installed using rpm, there should be no residue. If there is, you need to delete it

Check syntax: rpm -qa|grep -i mysql

Deletion syntax: rpm -e <package name>

If you encounter dependencies and cannot delete them, use rpm -e --nodeps <package name> to delete the rpm package directly without checking dependencies.

3. Use the find command to check whether the mysql file is installed and delete it if necessary

Check syntax: find / -name mysql

Deletion syntax: rm -rf directory file (or file)

******(2) Create mysql group and user******

1. Delete mysql user by force

Deletion syntax: userdel -r -f mysql (If not, it will prompt you that mysql does not exist, don't worry)

2. Add Group

Add syntax: groupadd mysql

3. Add mysql user

Add syntax: useradd -g mysql mysql

******(3) Unzip the tarball******

1. cd to the mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz directory

2. Unzip the tarball

Decompression syntax: tar zxvf mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz

After decompression, there is an additional file mysql-5.7.12-linux-glibc2.5-x86_64.

Copy this file to your favorite directory and rename it to mysql. Please be patient while copying.

After copying, cd to the mysql directory and create a new data folder.

Copy syntax: cp -r mysql-5.7.12-linux-glibc2.5-x86_64 /usr/local/mysql

New file syntax: mkdir data

chmod 770 data

Create a new data folder in /usr/local/mysql and change the permissions to 770 (drwxrwx---.):

[wangh@HavGO mysql]$ sudo mkdir data
 [wangh@HavGO mysql]$ sudo chmod 770 data

Set the user of /usr/local/mysql to mysql and the user group to mysql:

[wangh@HavGO ~]$ cd /usr/local/
 [wangh@HavGO local]$ sudo chown -R mysql:mysql mysql

Go to the /usr/local/mysql folder and execute the command:

[wangh@HavGO mysql]$ sudo bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

This command means to initialize and create the user, mysql directory and data directory (data created in the third step)

After the execution is completed, you will get a MySQL initial password. We need to save it first and use it when you log in to MySQL for the first time later.

2018-06-30T07:40:21.663544Z 1 [Note] A temporary password is generated for root@localhost: 0hl..Ult.usK

A temporary password is generated for root@localhost:0hl..Ult.usK
0hl..Ult.usK

After the above is completed, execute the command:

[wangh@HavGO mysql]$ sudo bin/mysql_ssl_rsa_setup --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

This command sets up an SSL secure connection to mysql (RSA encryption) and specifies the mysql directory and data directory.

Create a new mysql log folder in /var/log/ to store mysql operation logs:

[wangh@HavGO mysql]$ cd /var/log
 [wangh@HavGO log]$ sudo mkdir mysql

Execute the following command in the /usr/local/mysql folder:

[wangh@HavGO mysql]$ sudo bin/mysqld_safe --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data &

Press Enter again to run this command in the background.

mysqld_safe script function Baidu

Add mysql to /etc/init.d to start the boot:

[wangh@HavGO mysql]$ sudo cp support-files/mysql.server /etc/init.d/mysql

Configure /etc/my.cnf (my.cnf is the configuration file of mysql)

[wangh@HavGO mysql]$ vim /etc/my.cnf

Modify the configuration as shown below:

[mysqld]
 # Set the installation directory of mysql to basedir=/usr/local/mysql
 # Set the storage directory of mysql database data datadir=/usr/local/mysql/data
 # The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
 socket=/tmp/mysql.sock
 #socket=/var/lib/mysql/mysql.sock
 user=mysql
 [mysql-safe]
 log-error=/var/log/mysql/mysqld.log
 pid-file=/var/run/mysqld/mysqld.pid

Other settings are optional

# Set the default character set of the mysql client to default-character-set=utf8
 socket=/var/lib/mysql/mysql.sock
 [mysqld]
 skip-name-resolve
 #Set port 3306 port = 3306
 # Maximum number of connections allowed max_connections=200
# 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
#If you forget your password, you can uncomment it and log in without a password #skip-grant-tables

Configuring environment variables

[wangh@HavGO mysql]$ vim /etc/profile

Add the following content:

export MYSQL_HOME="/usr/local/mysql"
 export PATH="$PATH:$MYSQL_HOME/bin"

After adding, save and exit, and let the environment variables take effect immediately:

[wangh@HavGO mysql]$ source /etc/profile

Now that MySQL has been installed, start the MySQL service:

[wangh@HavGO etc]$ sudo service mysql start

Displays successful startup.

If the mysql folder is not named "mysql" in step 2, mysqld_safe will report an error, showing "mysqld_safe The file /usr/local/mysql/bin/mysqld

does not exist or is not executable."

Because the default mysql path of the mysqld_safe script is /usr/local/mysql, there are two solutions at this time. Change all /usr/local/mysql directories in mysqld_safe to your actual installation directory.

Or create a link to your actual installation directory to /usr/local/mysql

 mkdir /var/lib/mysql
 mysql_install_db --user=mysql --ldata=/var/lib/mysql/

After the mysql service is started, type the command to enter mysql, and the password is the initial password obtained previously;

[wangh@HavGO etc]$ mysql -u root -p

Enter the initial password and press Enter

Set the new password: jkl12345784

Log in again with the new password and you can use mysql.

Change the root password immediately after logging in:

mysql> alter user 'root'@'localhost' identified by 'admin';
 Query OK, 0 rows affected (0.00 sec)

Your_password is the new password you set. The new password should be a strong password that contains uppercase and lowercase letters, numbers, and punctuation marks, and should be at least 6 characters long.

grant all privileges on *.* to 'root'@'%'identified by 'admin' with grant option;
 flush privileges
 ps aux |grep httpd

Summarize

The above is a detailed tutorial on how to install MySQL 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!