Skip to main content

Posts

Showing posts from August, 2018

MySQL to 8.0.11 in place upgrade

MySQL in place upgrade from 5.6.11 to 8.0.11:   01. Install MySQL 5.7 latest version on MySQL database server such as 5.7.22. 02. Initialize MySQL     mysqld --defaults-file=/etc/my.cnf --initialize-insecure & 03. Start MySQL daemon     mysqld --defaults-file=/etc/my.cnf & 04. Configure systemd to start and stop Mysql daemon       * Shutdown mysqld           mysqladmin -uroot -S/var/lib/mysql/mysql.sock shutdown        * Edit file /usr/lib/systemd/system/mysqld.service and add following         [Service]         PIDFile=/var/lib/mysql/mysql.pid         ExecStart=/usr/sbin/mysqld --defaults-file=/etc/my.cnf --daemonize --pid-file=/var   /lib/mysql/mysql.pid $MYSQLD_OPTS       * sudo systemctl daemon-reload   ...