Shulou(Shulou.com)05/31 Report--

This article mainly introduces "the detailed process of the installation and use of mysql". In the daily operation, I believe that many people have doubts about the detailed process of the installation and use of mysql. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "the detailed process of installation and use of mysql". Next, please follow the editor to study!

Mysql installation and use download # 1 first go to https://repo.mysql.com/ to download the latest repo source $wget https://repo.mysql.com/mysql80-community-release-sles12-2.noarch.rpm#2 install the mysql80-community-release-sles12-2.noarch.rpm package $sudo rpm-ivh mysql80-community-release-sles12-2.noarch.rpm# if the error message conflicts First check whether $rpm-qa has been installed | grep mysql# kill him if possible-- nodeps forcefully uninstalls $rpm-e xxx (--nodeps) # xxx installs mysql$ sudo yum install mysql-community-server for conflicting rpm names # installs $service mysqld start # launches $sudo service mysqld status # checks the MySQL service status $sudo grep 'temporary password' / var/log/mysqld.log # checks the initial password $mysqld-V # See version reset password $mysql-u root # you need to enter the initial password # modify the root login password Be careful to switch to the mysql database Use use mysql$ ALTER USER 'root'@'localhost' IDENTIFIED BY' password Remote login # requires changing permissions to remotely connect to MYSQL database $mysql-h localhost-uroot-p # enter password login mysql > use mysql; # this DB stores various configuration information of MySQL mysql > select host,user from user; # View user's permissions mysql > select host,user, password from user;mysql > update user set host ='% 'where user =' root' #% means all external machines. If you specify a machine, change the% to the corresponding machine name 'root' refers to the user name to be used: mysql > flush privileges; # to run this sentence, or restart MySQL

The last step is to configure the joining rule in the server firewall to open port 3306

common problem

ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Mysql-u root-p # enter password login # yourpassword is your database account password, root and host are also ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY' 123456 authentication plug-in, handshake process will be different when you connect to the database.

ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'

Mysql-u root-pmysql > use mysql;mysql > select user,host from user +-+-+ | user | host | +-+-+ | root |% | admin | localhost | | mysql.infoschema | localhost | | mysql.session | localhost | | mysql.sys | localhost | Zhangj | localhost | +-+-+ # Note root Host is'%', what you might execute is: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' 123' # change it to: ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY' 123; at this point, the study on "the detailed process of installation and use of mysql" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.