How to Upgrade MySQL 5.6 server to MySQL 5.7 server on FreeBSD 

To upgrade MySQL Server on FreeBSD 10.3 , you can use ‘pkg’ tool.

root@localhost:~ # pkg install mysql57-server


Updating FreeBSD repository catalogue…
FreeBSD repository is up-to-date.
All repositories are up-to-date.
The following 2 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
mysql57-server: 5.7.10_3
mysql57-client: 5.7.10_4

The process will require 179 MiB more space.
15 MiB to be downloaded.

Proceed with this action? [y/N]: y
Fetching mysql57-server-5.7.10_3.txz: 100%   13 MiB  70.1kB/s    03:16
Fetching mysql57-client-5.7.10_4.txz: 100%    2 MiB  85.8kB/s    00:29
Checking integrity… done (2 conflicting)
Checking integrity… done (0 conflicting)
Conflicts with the existing packages have been found.
One more solver iteration is needed to resolve them.
The following 4 package(s) will be affected (of 0 checked):

Installed packages to be REMOVED:
mysql56-client-5.6.27
mysql56-server-5.6.27

New packages to be INSTALLED:
mysql57-client: 5.7.10_4
mysql57-server: 5.7.10_3

The process will require 60 MiB more space.

Proceed with this action? [y/N]: y
[1/4] Deinstalling mysql56-server-5.6.27…
==> You should manually remove the “mysql” user.
[1/4] Deleting files for mysql56-server-5.6.27: 100%
[2/4] Deinstalling mysql56-client-5.6.27…
[2/4] Deleting files for mysql56-client-5.6.27: 100%
[3/4] Installing mysql57-client-5.7.10_4…
[3/4] Extracting mysql57-client-5.7.10_4: 100%
[4/4] Installing mysql57-server-5.7.10_3…
===> Creating users and/or groups.
Using existing group ‘mysql’.
Using existing user ‘mysql’.
[4/4] Extracting mysql57-server-5.7.10_3: 100%
Message from mysql57-client-5.7.10_4:
* * * * * * * * * * * * * * * * * * * * * * * *

This is the mysql CLIENT without the server.
for complete server and client, please install databases/mysql57-server

* * * * * * * * * * * * * * * * * * * * * * * *
Message from mysql57-server-5.7.10_3:
*****************************************************************************

Remember to run mysql_upgrade the first time you start the MySQL server
after an upgrade from an earlier version.

Initial password for first time use of MySQL is saved in $HOME/.mysql_secret
ie. when you want to use “mysql -u root -p” first you should see password
in /root/.mysql_secret

*****************************************************************************
root@localhost:~ #

Restart the MySQL Service.

root@localhost:/ # service mysql-server onerestart
Stopping mysql.
Waiting for PIDS: 1173.
Starting mysql.

root@localhost:/ #

 Now Start the MySQL Server.

 root@localhost:/ # mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.10 Source distribution

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s