How to install centos database?

How to install centos database?

How to install the database in centos:

1. Download mysql5.7

Linux download:

Enter the command:

wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

2. Create a user and mysql directory

1. Create a mysql group

Enter the command :

groupadd mysql

2. Create a mysql user and put it in the mysql group

Enter the command:

useradd -r -g mysql mysql

3. Set a password for the mysql user

Enter the command ：

passwd mysql

3. Unzip mysql

1. Move the downloaded mysql package to the Linux virtual machine

2. Copy the tar package Copy a copy to the /usr/local directory

Enter the command:

mv /software/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz /usr/local

3. Unzip

Enter the command:

cd /usr/local

Enter the command:

tar xzvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

4. Change the name of the extracted file to mysql

Enter the command:

mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql

4. Configure related startup configuration files

1. Copy my_default.cnf to /etc/my.cnf (automatically read when mysql starts)

Enter the command:

cp my-default.cnf /etc/my.cnf

2. Solve the garbled problem

Input command:

vi /etc/my.cnf

Change:

[mysql]
default-character-set=utf8
[mysqld]
default-storage-engine=INNODB
character_set_server=utf8

3. Copy mysql.server to /etc/init.d/

Enter the command:

cp mysql.server /etc/init.d/mysql

4. Modify the /etc/init.d/mysql parameters and give 2 directory locations

Enter the command:

vi /etc/init.d/mysql

Change:

basedir=/usr/local/mysql
　　　datadir=/usr/local/mysql/data

5. Change the owner of the directory /usr/local/mysql

chown -R username:group name/usr/local/mysql/

Input command:

chown -R mysql:mysql /usr/local/mysql/

5. Initialize the mysql database

1. Initialize the database

First go to the mysql/bin directory

Old version of the command: mysql_install_db

New version of the command: ./mysqld --initialize --user=mysql --basedir=/usr/local /mysql --datadir=/usr/local/mysql/data

Generates a data directory, indicating that the database has been initialized successfully

A temporary password will be generated here (save and remember , will be used later)

2. Encrypt the database

Enter the command:

./mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data

3. Start mysql

Enter the command:

./mysqld_safe --user=mysql &

& symbol: Throw the current process to the background

6. Enter the client

1. Log in

Enter the command:

./mysql -uroot -p

Then enter your temporary password

2. Change the password

Enter the command:

set password=password('你的密码');

7. Mysql for window remote access to the Linux virtual machine

1. First, turn off the firewall so that the window can connect.

Enter the command:

systemctl stop firewalld.service

2. Authorize the window

Enter the command:

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

3. Window remote connection

Enter the command:

mysql -hIP地址 -uroot -p123456

8. Set the mysql service to automatically start at boot

1. Add service mysql

Enter the command:

chkconfig --add mysql

2. Set the service to start automatically after booting

Enter the command:

chkconfig mysql on

9. Set the path environment variable

Enter the command: vi /etc/profile

Set the environment variable: export PATH=$ JAVA_HOME/bin:/usr/local/mysql/bin:$PATH

After configuring the environment variables, we no longer need to go to /usr/local/mysql/bin directory, you can now log in to mysql in any directory

10. Complete

In this way, our mysql database is configured

Recommended tutorial: "centos tutorial"

The above is the detailed content of How to install centos database?. For more information, please follow other related articles on the PHP Chinese website!