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

MySQL 8.0 is a very exciting new release of the world's most popular open source database, with comprehensive improvements. Some key enhancements include: SQL window functions, common table expressions, NOWAIT and SKIP LOCKED, descending indexes, grouping, regular expressions, character sets, cost models, and histograms. JSON extended syntax, new features, improved sorting and partial updates. With JSON table functions, you can use SQL mechanics for JSON data. GIS geographic support. Spatial Reference System (SRS), as well as SRS sensing spatial data types, spatial indices and spatial functions. Reliability DDL statements have become atomic and crash safe, and metadata is stored in a single transaction data dictionary. Powered by InnoDB! Observability performance architecture, information architecture, configuration variables, and significant enhancements to error logging. Manageable remote management, Undo Tablespace Management, and new on-the-fly DDL. Security OpenSSL improvements, new default authentication, SQL roles, breaking down super privileges, password strength, and more. Environment: Linux centos8 4.18.0-80.el8.x86_64, Mysql 8.0.18

1, Mysql official website download RPM package

2. Check whether rpm -qa is installed.| grep -i mysql3. Install rpm -e --nodeps software name before uninstalling//forcibly delete, and also forcibly delete related dependent files 4. Install client (mysql-client) rpm -ivh rpm package * Install mysql-community-community-8.0.18* Install mysql-community-libs-8.0.18 * Install mysql-community-client-8.0.18 (the first two are its dependencies)

5. Install server (mysql-server)

6. Check whether the installation is successful. There are the following ways to check: * ps -ef| grep mysql* cat /etc/group | grep mysql* cat /etc/password | grep mysql* mysqladmin --version...

7. Initialize mysqlmysqld --initialize //Create a data file directory and mysql system database to generate a random root password 8. Start mysql service systemctl start mysqld

Start failed because the/var/lib/mysql directory does not have sufficient permissions

The requested URL/var/lib/mysql/was not found on this server.

10. Start mysql service systemctl start mysqld //start ps -ef| grep mysql //view mysql services

The requested URL/log/mysqld.log was not found on this server.| grep password

mysql_secure_installation

13. mysql login mysql -uroot -p //random password login

14. Reset password (Mysql8.0+ has changed) First empty the old password of root use mysql;update user set authentication_string =''where user ='root '; Remarks: Mysql5.7+ password field has been changed to authentication_string field

Reset to new password alter user 'root'@'localhost' identified by 'newpassword'; Remarks: Mysql8.0 password modification method has changed (here is a pit, need to pay attention) Mysql8.0 before: update user set password=password ('root') where user='root';

15. Log out and use the new password to log in again mysqlmysql-uroot-proot

16. How to stop, restart, and view mysql servicessystemctl stop mysqld //Stop servicessystemctl restart mysqld //Restart servicessystemctl status mysqld //View services17. Related installation directory files of mysql/usr/bin //Related commands

/usr/share/mysql //configuration file directory

/var/lib/mysql //database file directory

/etc/my.cnf //mysql startup configuration file

18. Postscript my.ini //configuration file under windows operating system my.cnf //configuration file under linux operating system mysqld //background daemon process, namely mysql daemonmysql //client command line

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.