Home > Operation and Maintenance > CentOS > How to install centos database?

How to install centos database?

coldplay.xixi
Release: 2020-06-20 13:30:08
Original
3365 people have browsed it

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
Copy after login

2. Create a user and mysql directory

1. Create a mysql group

Enter the command :

groupadd mysql
Copy after login

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

Enter the command:

useradd -r -g mysql mysql
Copy after login

3. Set a password for the mysql user

Enter the command :

passwd mysql
Copy after login

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
Copy after login

3. Unzip

Enter the command:

cd /usr/local
Copy after login

Enter the command:

tar xzvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
Copy after login

4. Change the name of the extracted file to mysql

Enter the command:

mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql
Copy after login

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
Copy after login

2. Solve the garbled problem

Input command:

vi /etc/my.cnf
Copy after login

Change:

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

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

Enter the command:

cp mysql.server /etc/init.d/mysql
Copy after login

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

Enter the command:

vi /etc/init.d/mysql
Copy after login

Change:

basedir=/usr/local/mysql
   datadir=/usr/local/mysql/data
Copy after login

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/
Copy after login

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
Copy after login

3. Start mysql

Enter the command:

./mysqld_safe --user=mysql &
Copy after login

& symbol: Throw the current process to the background

6. Enter the client

1. Log in

Enter the command:

./mysql -uroot -p
Copy after login

Then enter your temporary password

2. Change the password

Enter the command:

set password=password('你的密码');
Copy after login

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
Copy after login

2. Authorize the window

Enter the command:

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

3. Window remote connection

Enter the command:

mysql -hIP地址 -uroot -p123456
Copy after login

8. Set the mysql service to automatically start at boot

1. Add service mysql

Enter the command:

chkconfig --add mysql
Copy after login

2. Set the service to start automatically after booting

Enter the command:

chkconfig mysql on
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template