1.
Stop MySQL: service mysql-server stop
2.
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
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 )
8.
Stop MySQL server: service mysql-server stop
9.
Remove the mysql_args
line from /etc/rc.conf
10.
Start MySQL server
service mysql-server start
11.
Done
