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

This article introduces the relevant knowledge of "how to install MySQL quickly with CentOS7". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Start the download step without any preparatory work, simple and clear. # download and install yum repository

[root@localhost ~] # wget-I-c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm[root@localhost ~] # yum-y install mysql57-community-release-el7-10.noarch.rpm

# install mysql server

[root@localhost ~] # yum-y install mysql-community-server

# you have completed 50% of the workload, and the next task is to start the service, change the initialization password and delete the yum automatically

# Update package

# start the mysql service

[root@localhost ~] # systemctl start mysqld.service

# check whether it has been started-status (Active:active (running))

[root@localhost ~] # systemctl status mysqld.service

# View the mysqld log and log in with the initialization password-- root@localhost: the system automatically matches the initialization password by default

[root@localhost ~] # grep "password" / var/log/mysqld.log [root@localhost ~] # mysql-u root-p

# enter initialization password to log in

# you need to change the initialization password to use mysql database

# the rules for modifying passwords are as follows: passwords must contain uppercase and lowercase alphanumeric numbers and symbols-provide reference password 'tyzZ001password'

Mysql > ALTER USER 'root'@'localhost' IDENTIFIED BY' New password'; # put tyzZ001! Replace the new password, and then tyzZ001! Is the login password.

# because Yum Repository is installed, it will be updated automatically every time you use yum operation, so you need to uninstall it:

[root@localhost] # yum-y remove mysql57-community-release-el7-10.noarch

# so far, you have completed the installation and simple work with mysql.

# Common mysql commands

[root@localhost ~] # systemctl start mysqld.service # enable service [root@localhost ~] # systemctl stop mysqld.service # disable service [root@localhost ~] # systemctl status mysqld.service # View service status [root@localhost ~] # mysql-u root-p # enter the mysql command window mysql > show databases; # to view all databases mysql > use database names; # use this data to edit mysql > show tables # this is the end of viewing all the tables in a database, "how to quickly install MySQL for CentOS7". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.