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.

mysql video tutorial》

#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

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 。

groupadd mysql和useradd -r -g mysql mysql

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

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

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

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

(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 文件名。

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

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

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   // 注册启动服务

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';

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!