Friday, February 22, 2019

Uninstall MySql on a Mac OS X

Summary

To completely uninstall MySql OS X it is neccessary to remove numerous files.

Symptom

You unable to install an older version of MySql even though you thought you have removed everything.

Resolution

To uninstall MySQL and completely remove it (including all databases) from your Mac do the following:
  • Open a terminal window
  • Use mysqldump to backup your databases to text files!
  • Stop the database server
  • sudo rm /usr/local/mysql
  • sudo rm -rf /usr/local/mysql*
  • sudo rm -rf /Library/StartupItems/MySQLCOM
  • sudo rm -rf /Library/PreferencePanes/My*
  • edit /etc/hostconfig and remove the line MYSQLCOM=-YES-
  • rm -rf ~/Library/PreferencePanes/My*
  • sudo rm -rf /Library/Receipts/mysql*
  • sudo rm -rf /Library/Receipts/MySQL*
  • sudo rm -rf /private/var/db/receipts/*mysql*
The last three lines are particularly important as otherwise, you can't install an older version of MySQL even though you think that you've completely deleted the newer version!

Taken from: https://community.jaspersoft.com/wiki/uninstall-mysql-mac-os-x

Installing Heidisql on macOS

1. First, install wine:

brew cask install java xquartz
brew install wine

2. Now, install winetricks:

brew install winetricks


3. Now, install Microsoft Data Access Components

winetricks dlls mdac28

4. Download Heidisql.
http://www.heidisql.com/download.php

5. Install Heidisql with wine command:
wine HeidiSQL_10.1.0.5464_Setup.exe

6. Start the application from from:
"/usr/local/bin/wine ~/.wine/drive_c/Program\\ Files/HeidiSQL/heidisql.exe"

or create an icon for your docker with the apple script editor

tell application "Terminal"
do script "/usr/local/bin/wine ~/.wine/drive_c/Program\\ Files/HeidiSQL/heidisql.exe"
end tell

Open up the Script Editor. You should see a window with a large area you can type in near the top: this is where you write your AppleScript. In that area, type the following text:

tell application "Terminal"
    do script "/usr/local/bin/wine ~/.wine/drive_c/Program\\ Files/$PATH_TO_PROGRAM.exe"
end tell

You'll need to replace $PATH_TO_PROGRAM with the path from the Program Files directory to your program executable. You can see that you're simply telling the AppleScript to run a line of code in the Terminal: the same line of code that you could run to start your Windows program.

Next, press the Compile button at the top of the window. The text should become colored to indicate that Script Editor understands what you wrote. You can also try pressing the Run button to run your script: it should open the Windows program successfully.

Lastly, save your script. You can give it whatever name you'd like, but be sure to select File Format: Application in the save options, and leave Startup Screen unchecked.

Open up the Finder, go to where you saved your script, and drag that file to your Dock. It should stay there, just like a real application -- because it is a real application! However, all it does is run that launcher command for you, so you can move the application around, rename it, or even delete it, and it won't affect the Windows program that you're running.

More details: https://www.davidbaumgold.com/tutorials/wine-mac/


Taken from: https://myridia.com/dev_posts/view/1620