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

First, the description of missing scan found that MySQL has low-risk vulnerabilities, write their own solutions, do their own tests, their own upgrades. Version: MySQL 5.7.25 to the latest version of MySQL 5.7.28. Architecture: master-slave architecture 2, upgrade process 1, download the latest database software MySQL 5.7.282, upload to the specified directory 3, backup database software, database data directory, my.cnf4, extract the database software to the specified path 5, close the standby library 6, use the new version of the software to start the standby library, mysqld_safe & 7, log in to the standby library, and find that the version has been upgraded Use the mysql_upgrade command to upgrade the system database 8. If there is no error, restart the library. 9. Go through the main database according to the process of standby database 10, and finally confirm whether the main database and standby database are consistent. Partial content # mysql_upgrade-uroot-pmysql_upgrade: [Warning] Using a password on the command line interface can be insecure.Checking if update is needed.Checking server version.Running queries to upgrade MySQL server.Checking system database.mysql.columns_priv OKmysql.db OKmysql.engine_cost OKmysql. Event OKmysql.func OKmysql.general_log OKmysql.gtid_executed OKmysql.help_category OKmysql.help_keyword OKmysql.help_relation OKmysql.help_topic OKmysql.innodb_index_stats OKmysql.innodb_table_stats OKmysql.ndb_binlog_index OKmysql.plugin OKmysql.proc OKmysql.procs_priv OKmysql.proxies_priv OKmysql.server_cost OKmysql.servers OKmysql. Slave_master_info OKmysql.slave_relay_log_info OKmysql.slave_worker_info OKmysql.slow_log OKmysql.tables_priv OKmysql.time_zone OKmysql.time_zone_leap_second OKmysql.time_zone_name OKmysql.time_zone_transition OKmysql.time_zone_transition_type OKmysql.user OKFound outdated sys schema version 1.5.1.Upgrading the Sys schema.Checking databases.sys.sys_config OKUpgrade process completed successfully.Checking if update is needed.mysql > status-mysql Ver 14.14 Distrib 5.7.28 For linux-glibc2.12 (x86 / 64) using EditLine wrapperConnection id: 2Current database: Current user: root@localhostSSL: Not in useCurrent pager: stdoutUsing outfile:''Using delimiter: Server version: 5.7.28-log MySQL Community Server (GPL) Protocol version: 10Connection: Localhost via UNIX socketServer characterset: utf8mb4Db characterset: utf8mb4Client characterset: utf8mb4Conn. Characterset: utf8mb4UNIX socket: / tmp/mysql.sockUptime: 27 sec

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.