How to install mysql8.0 on centos

centosHow to install mysql8.0: First select the MYSQL version under Linux that suits your version; then install "mysql-8.0.15-el7-x86_64" to "/usr /local/mysql"; finally initialize mysql.

# Recommended: "

mysql video tutorial》

1. Go to the official website and choose the MYSQL version under Linux that suits your version.

#Follow the numbers on the arrows and proceed one by one to enter the picture below.

Wait for the download to complete, so the first step is completed.
2. Upload the downloaded mysql-8.0.15-el7-x86_64.tar.gz to the Linux system for decompression.
(1) I upload this file to the /root/ directory and first check the files in the /root/ directory. to ensure that this file exists on the system.

cd /root/ ls

(2) Unzip the file.

tar -zxvf mysql-8.0.15-el7-x86_64.tar.gz

Then this directory will be generated in the current /root/ directory.

3. Install mysql.
(1) Install mysql-8.0.15-el7-x86_64 under /usr/local/mysql.

mv mysql-8.0.15-el7-x86_64 /usr/local/mysql //将文件移动到 /usr/local/ 目录下，并更名为mysql 。

(2) Add the mysql group and user to the system.

groupadd mysql和useradd -r -g mysql mysql

(3) Enter the /usr/local/mysql directory and modify the relevant permissions.

cd /usr/local/mysql //进入/usr/local/mysql 目录 chown -R mysql:mysql ./ //修改当前目录为mysql用户

(4) Mysql initialization operation, record the temporary password, which will be used when logging in for the first time.

bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data //运行完成会生成一个暂时的密码。

The results are as follows

(5) Check whether the my.cnf file is automatically generated during the initialization process.

cd /etc/ //进入/etc/目录下 ls | grep my.cnf //查看是否有my.cnf 文件。有则会产生结果。

(6) My.cnf is generated during initialization file, skip to step 8 to modify the information of the my.cnf file.

(7) If my.cnf is not generated during the initialization process, create a new my-defalut.cnf file and copy it to /etc/my.cnf

touch my-defalut.cnf //新建一个文件 chmod 755 my-defalut.cnf // 赋予权限 cp my-defalut.cnf /etc/my.cnf // 将文件复制到/etc/ 目录下，并更名为my.cnf 文件名。

(8 )my.cnf information is as follows

[mysqld]

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
port=3306
socket =/tmp/mysql.sock
pid-file=/usr/local/mysql/$hostname.pid //Attention, small details, $hostname here is the host name of Linux. Generally, everyone's host name is different.
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

(9) Configure environment variables for mysql.

vim /etc/profile // 打开profile文件。 export MYSQL_HOME MYSQL_HOME=/usr/local/mysql export PATH=$PATH:$MYSQL_HOME/lib:$MYSQL_HOME/bin

(10) Set as an auto-start item at boot.

Execute the codes in sequence.

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql chmod +x /etc/init.d/mysql //添加可执行权限。 chkconfig --add mysql // 注册启动服务

Enter chkconfig --list //Check whether the addition is successful.

indicates success.
(11) Start the server and log in to mysql.

service mysql start //开启服务器。 mysql -uroot -p //登录进入mysql，然后提示输入密码。

Enter the temporary password generated during the initialization process and press Enter. Enter the page.

At this point, the installation has been successful.
(12) After entering mysql, change the password. Otherwise you can't do anything.

alter user 'root'@'localhost' identified by 'your_password';

Then exit; exit, re-enter, and test.

show databases;

At this point, the entire process of installing mysql version 8.0.15 is over!
Finally, the editor is just a novice, I hope you can give me some advice if you have any questions! ! !

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