Shulou(Shulou.com)06/01 Report--

Editor to share with you how to use rpm to install mysql, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

View installation and uninstall

# View rpm-qa | grep mysql# uninstall yum-y remove mysql-libs-5.1.66-2.el6_3.x86_64

1.centos7 needs to uninstall mariadb first

View the command rpm-qa | grep mariadb

Installation package resource address

Mysql download address

# download resource name mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar decompress resource tar-xvf mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar get rpm package mysql-community-common-5.7.19-1.el6.x86_64.rpmmysql-community-client-5.7.19-1.el6.x86_64.rpmmysql-community-server-5.7.19-1.el6.x86_64 .rpmMySQL-community-libs-5.7.19-1.el6.x86_64.rpm installation # installation sequence # common--> libs--> clients-- > server# installation command rpm-ivh mysql-community-common-5.7.19-1.el6.x86_64.rpm mysql-community-libs-5.7.19-1.el6.x86_64.rpm mysql-community-client-5.7.19-1.el6.x86_64.rpm mysql-community- Server-5.7.19-1.el6.x86_64.rpm

You may need to rely on the package libaio

Install the command yum-y install libaio

Initialization

Mysqld-- initialize-- user=mysql starts service mysqld start login # View the initial password cat / var/logs/mysql.log# or grep 'password' / var/logs/mysql.log-n-B login mysql-uroot-pendant 123456 login # modify the initial password set PASSWORD=PASSWORD (' password') Authorization remote link # # Authorization 192.168.0.1 can be remotely linked to * [all databases]. * [all tables] account: root password 123456grant all privileges on *. * to 'root'@'192.168.0.1' identified by' 123456 "ipgrant all privileges on" # authorizes all ipgrant all privileges on *. * to 'root'@'%' identified by' 123456 "database" above *. [table] # make the authorization take effect immediately flush privileges; is all the contents of the article "how to install mysql in rpm". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.