Centos6.5 online installation of mysql 8.0 detailed tutorial, centos6.5mysql

Centos6.5 online installation of mysql 8.0 detailed tutorial, centos6.5mysql

Centos6.5 install mysql 8.0 online in the following sequence.

Mysql detaching from bottom to top

[root@localhost /]# rpm -e --nodeps qt-MySQL-4.6.2-26.el6_4.x86_64 [root@localhost /]# rpm -e --nodeps mysql-server-5.1.71-1.el6.x86_64 [root@localhost /]# rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64 [root@localhost /]# rpm -e --nodeps mysql-devel-5.1.71-1.el6.x86_64 [root@localhost /]# rpm -e --nodeps mysql-5.1.71-1.el6.x86_64 [root@localhost /]# rpm -qa | grep mysql

Add an online Mysql Source

cd /etc/yum.repos.d/vi mysql.repo# Enable to use MySQL 8.0[mysql80-community]name=MySQL 8.0 Community Serverbaseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/enabled=1gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

Verify that the correct subrepositories has been enabled and disabled by running the following command to check its output (DNF enables the system, replacing the command of Yum! On DNF)

yum repolist enabled | grep mysql

Install mysql in YUM
Copy codeThe Code is as follows: yum install-y mysql-community-common mysql-community-libs mysql-community-client mysql-community-server mysql-community-devel

Start Mysql Service

service mysqld start

View the status of the MySQL server

service mysqld status

Set startup

chkconfig mysqld on

Generate random password

grep 'temporary password' /var/log/mysqld.log

Log on again

mysql -uroot -p b/xE8hdZoEwJ

Configure the Mysql password and permissions

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Report@123';

Allow the root user to log on Remotely Anywhere and have any operation permissions on all databases
[Code] grant all privileges on *. * TO 'root' @ '%' identified by 'report @ 100' with grant option;
Flush privileges;

Highlights: mysql installation tutorials for different versions

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.