Symptom: Gestix is working before the computer is shut down however. Once the computer is restarted, Gestix stops with the following message.
(It seems there is a problem with the database server.Jul 06, 2021 (mysql-installer-web-community-8.0.26.0.msi) MD5: eaddc383a742775a5b33a3783a4890fb Signature Windows (x86, 32-bit), MSI Installer: Jul 6, 2021: 450.7M.
Although the MySQL Startup item seems to no longer work on OS-X 10.10, it’s possible to start it from the command line.
1. Open Finder Applications Utilities Terminal
2. Paste this command and press Enter
3. Close the Terminal application.
If the problem persists there may be need for a remote technical intervention to the server by MySQL system specialists. Order technical support here.
It is always easy to have a quick list of commands instead of bunch of notes lingering between line. So here is what I have for setting up MySQL in Mac –
brew install mysql
brew services start mysql
Now the MYSQL files must be existing in /usr/local/bin
sudo /usr/local/bin/mysql -u root -p
Use Mac root password / login password here and then you may need to enter the mysql root password for the first time login. If you wish to change this password later use below command –
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘newpassword’;
Now you can use either terminal or any SQL UI editor to run and maintain database.
If getting authentication issues connection MYSQL via editor like sequelpro then you may need to reset the encryption feature which must be blocking the authentication.
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root_password';