1. Manage to upgrade mysql 56 to 57 a. Stop MySQL: service mysql-server stop b. Add to /etc/rc.conf: Code: mysql_args="--explicit_defaults_for_timestamp=true --skip-grant-tables --skip-slave-start --thread_stack=256K" These are needed, it prevents the slave process from starting, skips grant tables (so you always have access), the thread stack seems to be required, I ran out of it a couple of times
c. Install MySQL 5.7: pkg install mysql57-server d. Start it: service mysql-server start e. Note, this starts MySQL with the arguments we added above. f. Run the upgrade script: mysql_upgrade (But For number (f) - > mysql_upgrade -u root –p ) g. Stop MySQL server: service mysql-server stop h. Remove the mysql_args line from /etc/rc.conf i. Start MySQL server service mysql-server start j. Done
i)SET GLOBAL innodb_fast_shutdown = 1; -- fast shutdown
ii)Shut down the old MySQL server. For example: mysqladmin -u root -p shutdown
iii) Upgrade the MySQL binaries or packages. If upgrading a binary installation, unpack the new MySQL binary distribution package. See Obtain and Unpack the Distribution. For package-based installations, install the new packages. (pkg install mysql80-server)
iv)Start the MySQL 8.0 server, using the existing data directory. For example: mysqld_safe --user=mysql --datadir=/path/to/existing-datadir &
Failed: with error uppercase characters.
i) lower_case_table_names=1, change in /usr/local/etc/mysql/my.cnf
error uppercase
ii) lower_case_table_names=1,change in /usr/local/etc/mysql/my.cnf
2020-02-17T06:04:32.646839Z 2 [ERROR] [MY-013140] [Server] BLOB/TEXT column 'FileSystem' used in key specification without a key length
2020-02-17T06:04:50.345066Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables.
These
are needed, it prevents the slave process from starting, skips grant tables (so
you always have access), the thread stack seems to be required, I ran out of it
a couple of times
3.Remove MySQL 5.5 server: pkg delete mysql55-server
4.Install MySQL 5.6: pkg install mysql56-server
5.Start it: service
mysql-server start
6.Note, this starts MySQL
with the arguments we added above.
7.Run the upgrade script: mysql_upgrade(But For number (6) - > mysql_upgrade -u root –p )
·I prefer to move,
rather than delete, in case something goes wrong and you wish to restore the
files.
When you remove cloud-init following
those steps, your machine stops booting and there is apparently a service that
is waiting for network to be up. This would normally be just an inconvenience,
but the boot hangs indefinitely waiting for said network. Odd choice of
configuration out of the box, but anyway, you can fix this by:
List the services which depend on
network being online.
osudo systemctl show -p WantedBy
network-online.target
This will list the culprits as
some iscsi services that you probably don’t need.
7.Restore Database: mysql -uroot
-p --default-character-set=utf8 <191128iwpress_db .sql="" span="">191128iwpress_db>
8.Grant privileges: grant all privileges on
namadb.* to 'namadb_admin'@'localhost' identified by 'password';
After iwpress.contoso.com available, you can access wp-admin and update
the wordpress, plugin and themes. After get the latest version of Wordpress
(version 5.3 – on date 29/11/2019), then you can upgrade the php5.6 to php7.3
By default, WordPress uses wp_ as the prefix for all tables
in your WordPress database. If your WordPress site is using the default
database prefix, then it makes it easier for hackers to guess what your table
name is. This is why we recommend changing it. You can change your database
prefix by following our step by step tutorial on how to change WordPress
database prefix to improve security.
Note: This can
break your site if it’s not done properly. Only proceed, if you feel
comfortable with your coding skills.