How to set up mysql environment under linux

How to build the mysql environment under Linux: First download the Linux version of MySQL and unzip the file; then add users and set permissions; then initialize the database and install the SSL service; finally open the service and use the root account Just log in.

How to build the mysql environment under Linux:

1) Download the Linux version of MySQL.

2) Warning

If you have previously installed using the operating system's native package management system such as Yum or APT MySQL, you may encounter problems when installing using the native binaries. Make sure that your previous MySQL installation has been completely removed (using your package management system) and that any other files, such as data files from older versions, have also been removed. You should also check configuration files such as /etc/my.cnf or /etc/mysql directory and delete them.

For information on replacing third-party packages with official MySQL packages, see the relevant APT guide or Yum guide.

MySQL depends on the libaio library. If this library is not installed locally, data directory initialization and subsequent server startup steps will fail. If necessary, install using an appropriate package manager. For example, on a Yum-based system:

shell> yum search libaio  # search for info
shell> yum install libaio # install library

Or, on an APT-based system:

shell> apt-cache search libaio # search for info
shell> apt-get install libaio1 # install library

3) Unzip the file

To install the compressed tar file binary distribution, unzip it in the installation location of your choice (usually /usr/local/mysql). This will create the directories shown in the table below.

There are generally two compression methods: command line and direct use of the system’s own decompression

You can directly decompress the downloaded compressed package to a local file; of course, the command line is completely feasible ：

After decompression, move the software package to the /usr/local directory in the system and name it mysql

tar -zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
mv mysql-8.0.11-linux-glibc2.12-x86_64 /usr/local/mysql

4 ) Add users and set permissions (Enter the following commands in order to configure the database)

groupadd mysql
useradd -r -g mysql -s /bin/false mysql
cd /usr/local
cd mysql
mkdir mysql-files
chown mysql:mysql mysql-files
chmod 750 mysql-files

5) Initialize the database

bin/mysqld --initialize --user=mysql

You can see that the system randomly gives The root user is assigned a password, as shown in the picture. This password should be remembered. You can change it if you want to customize it

6) Install SSL service (General distributions will help you install it in advance)

Install openssl before executing the installation command, otherwise an error will be reported

apt install openssl
bin/mysql_ssl_rsa_setup

7) Replication service File

 cp support-files/mysql.server /etc/init.d/mysql.server

8) Open the service

& means running in the background. After executing the command, the terminal will be stuck in one position. Press Enter again. Yes, as shown in the picture

9) Use the root account to log in

bin/mysql -uroot -p

10) Change the root user password

Random login cannot be used once, so we need to change the password, as follows

(1), Option 1: Restrict local login

ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
flush privileges;

(2), Option 2: Any IP can be used with Third-party client login

ALTER USER 'root'@'localhost' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER;    #修改root的密码与加密方式
use mysql;   #切换到mysql库
update user set host='%' where user = 'root';   #更改可以登录的IP为任意IP
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码'; #再次更改root用户密码，使其可以在任意IP访问
flush privileges;    #刷新权限

More related free learning recommendations:mysql tutorial(Video)

The above is the detailed content of How to set up mysql environment under linux. For more information, please follow other related articles on the PHP Chinese website!