1. Official installation document
http://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/
< h3>2, download Mysql yum package
http://dev.mysql.com/downloads/repo/yum/
Download it locally and then Upload to the server, or use wget to download directly
wget http:< span class="hljs-comment">
3. Install software source
Replace platform-and-version-specific-package-name with the rpm name you downloaded p>
sudo rpm -Uvh platform-and-version-specific-package-name.rpm For example
rpm -Uvh mysql57-community-release-el7- 10.noarch.rpm
4. Install mysql server
yum install -y mysql-community-server
If the network environment is not very good, can I make a cup of tea after executing the command? ?Or kill a game of glory (you can download the corresponding rpm package yourself or directly download the...bundle.tar compressed package)
5. First start mysql
service mysqld start (restart is restart, it is best to add lower_case_table_names=1 Go to the line under [mysqld] and restart MySQL. This is for compatibility with windows. Also, add default-character-set=utf8)
systemctl start mysqld.service (this is automatically output after the above steps are executed, my full name here is: Redirecting to /bin/systemctl start mysqld.service)
and then go back [.....]#
6. Then check the running status of mysql
service mysqld status
systemctl < span class="hljs-selector-tag">status mysqld.service (also automatically output by the system , My full name here is: Redirecting to /bin/systemctl status mysqld.service)
Then it will output a large paragraph about MySQL status information:
mysqld.service-MySQL Server
Loaded: loaded ( /usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since 2017-07-30 08:24:29 CST; 26s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 58507 ExecStart=/usr/sbin/mysqld --daemonize --pid -file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 58426 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 58511 (mysqld)
CGroup: /system.slice/mysqld.service
└─58511 / usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/my...
July 30 08:24:21 localhost.localdomain systemd[1]: Starting MySQL Server...
July 30 08:24:29 localhost.localdomain systemd[1]: Started MySQL Server. (Note this sentence, indicating that the MySQL service is already running at this time)
7. Modify the temporary password
After Mysql5.7 is installed by default, root has a password.
7.1 Get the temporary password of MySQL
In order to strengthen security, MySQL 5.7 randomly generates a password for the root user. In the error log, the location of the error log , If the RPM package is installed, the default is /var/log/mysqld.log.
You can view the temporary password only once mysql has been started
grep 'temporary password' /var/log/mysqld. log (If MySQL has been installed before, there may be multiple passwords here. Use the last one. Note that this password is Can be pasted)
The password here is YdsGaxOq>2n!< /code>
7.2 Login and change password
Use the default password to log in
mysql -uroot -p (This is a MySQL command to log in to the root user with a password)
After logging in to the server with this password, you must immediately change the password and perform some database operations, otherwise The following error will be reported:
mysql> select @@log_error;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. mysql>
Modify the password (note that it is best to have after the operation after login; end)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root123';< /span>
If the password setting is too simple, the following prompt will appear
< /div>
How to solve ERROR 1819 (HY000): Your password does not satisfy the current policy requirements? The solution is directly provided here. There are detailed instructions at the end of the article.
Two global parameters must be modified:
First, modify the value of the validate_password_policy parameter
mysql>set global < /span>validate_password_policy=0;
Change the length of the password< /p>
set global validate_password_length=1;
Execute the modification again The password will do
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root123' ; (ALTER etc. can be written in lowercase)
8. Authorize other machines to log in
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' < span class="hljs-keyword">IDENTIFIED BY < span class="hljs-string">'yourpassword' WITH GRANT OPTION; < span class="hljs-keyword">FLUSH PRIVILEGES; span>
9. Detailed instructions on password settings
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
