MySQL 5.7


MySQL 5.7.11 fixes compatibility with Mac OS X allowing it to autostart. When Yosemite was released MySQL would not autostart, requiring you to click the start button in System Prefs if the computer was rebooted.

Big Business 10.3 includes a fix for compatibility with MySQL 5.7.8 and higher. Changes to Date formatting in MySQL can block earlier versions of Big Business from making some updates. (6585)






To Update:

1. Download an installer DMG from mysql.com.

2. Run the installer to replace MySQL.

3. Note the Password that is automatically assigned (Shift-Command-4, then Space bar, then click to capture the window).

4. Reset password (Copy and Paste into Terminal):
/usr/local/mysql/bin/mysql -u root -p
(enter the password displayed in step 3)
set password=password('newpassword');

5. Re-create remote access:
create user 'root'@'%' identified by 'newpassword';
grant all on *.* to 'root'@'%';

Of course you can create other users to control access by UPS, FedEx, or your web store or other service.

And you can rely on Unlimited Setup Support included with Big Business for any help needed.

If needed you can check the port MySQL is using with:
SHOW VARIABLES WHERE Variable_name = 'port';



Related:

  Chapter 24 Middleware

Return to Help