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

This article mainly introduces how to configure yum and install mysql. I hope I can add and update some knowledge to you. If you have any other questions you need to know, you can continue to follow my updated article in industry information.

Configure yum Feed

Rpm-Uvh http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm

Modify the source of file startup 5.7

Yum installation command: yum install mysql-community-server

Start the mysql library:

Service mysqld start

View the initial password:

Grep 'password' / var/log/mysqld.log | head-n 1

Enter MySQL

Mysql-u root-p

Change the password:

/ * lower password policy * /

Set global validate_password_policy=0

Set global validate_password_length=1

# set password

Set password=password ("root")

View the database:

Mysql > show databases

Stop the database:

Service mysqld stop

Modify the character set:

/ * Encoding used to establish a connection * /

Set character_set_connection=utf8

/ * coding of the database * /

Set character_set_database=utf8

/ * Encoding of result set * /

Set character_set_results=utf8

/ * coding of database CVM * /

Set character_set_server=utf8

Set character_set_system=utf8

Set collation_connection=utf8

Set collation_database=utf8

Set collation_server=utf8

Query the database building statement:

Show create database test

Modify the character set:

Alter database test charset utf8

Read the above about the configuration of yum and installation of mysql analysis, I hope to give you some help in practical application. Due to the limited space in this article, it is inevitable that there will be deficiencies and need to be supplemented. If you need more professional answers, you can contact us on the official website for 24-hour pre-sales and after-sales to help you answer questions at any time.

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.