MySQL 8
MySQL 8 simplifies Password setup.
(7105)
To Update:
1. Download an installer DMG from mysql.com.
2. Run the installer to replace MySQL.
3. Choose Legacy Password Encryption.
4. Enter a Password
5. Set up remote access (Copy and Paste into Terminal):
/usr/local/mysql/bin/mysql -u root -p
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: