Install Mysql Mac Catalina

How to Install MySQL 8.0 and Get Started with SQL Programming. I want you to install MySQL on your own machine, because I want you to learn how to install, customize and operate complex industrial software system. Installation could be the hardest part in this exercise. Step 0: Create a directory to keep all your works.
Installing MySQL on your own Mac. There are several different ways to install MySQL on Mac OS X. We have provided links to the most common installation methods for Mac OS X. Using the official.pkg installer. This is the fastest method for installing MySQL on your Mac, but only available for Intel processors.

Description: MySQL v.8.22 does not run on MAC 10.5 Catalina: We attempted to install on IMac 10.5 we found that a known bug exists which states that the installed version is outdated. This is actually not true, as v. Is in actual fact the latest version.

Welcome back to another SecuringNinja tutorial. No cyber security researcher should be with out a database to practice their skills on, or just to store tons of relational data. Today we will show you how to install MySQL on a Mac. Having a local database is perfect for running websites locally, or for providing persistent storage for another application.

In this article we cover how to:

MySQL is very straight forward to install on a Mac. If you do not already have the Homebrew package manager for Mac you’ll need to install that first. If you would rather not install Homebrew you can also install MySQL using the DMG file available on the MySQL site.

Installing Homebrew on Mac

Lets start by opening up Terminal and installing Homebrew. Homebrew is a macOS package manager that makes installing packages on macOS a breeze.

To install Homebrew on Mac run the following command:

Once the install is complete go ahead and run an update to test that everything is working correctly.

With Homebrew installed it is a simple matter to install MySQL.

Installing MySQL on Mac with Brew

Installing MySQL with Brew is a breeze. All it takes is:

This will install the most recent version of the package available on Brew. As of this writing it is MySQL version 8.0. To install a different version simply append the version to the end of the package with an @ symbol. For example, to install MySQL 5.7 use:

If you don’t want to install Homebrew you can also install MySQL with the DMG file available for download as described below.

Installing MySQL with a DMG file

You can also install MySQL via the DMG file on the MySQL downloads page. This will add a MySQL preference pane in System Preferences as well. You can start and stop your server from here too.

First begin by downloading and mounting the DMG file available from the MySQL Community downloads page. Make sure you grab the appropriate DMG for your OS version.

Mount the DMG and double click the .pkg file to begin the installation.

Step through the installer installer and make a note of your temporary root password. You will need this for the initial connection to the server. DO NOT LOSE IT!

The server will require that you update your password on the first login. MySQL server is now installed. To start the server use launchctl or the MySQL preference pane in System Preferences. The server uses very few resources while running in the background so there really is no need to start and stop the server each time.

To start the server via launchctl:

This instructs MySQL to start when the system boots up.

You can also start and stop MySQL through the System Preferences pane. Open System Preferences and select MySQL:

And finally, start or stop the server as needed.

From this preference pane you can also edit the MySQL server configuration, re-initialize the database, and uninstall MySQL server entirely. We cover how to uninstall MySQL on Mac in the next section.

Uninstalling MySQL on Mac

If you installed MySQL via the DMG file method then uninstalling is extremely straight forward. Navigate to the MySQL preference pane in System Preferences, and click Uninstall. Thats it! MySQL has been uninstalled.

If you however installed MySQL using the Brew method described above, then there are a couple of extra steps.

Uninstalling MySQL on Mac with Brew

The steps below show how to uninstall MySQL installed with Brew. Begin by finding any running MySQL processes and stopping them. Then uninstall MySQL and remove all files.

What to do with your new database

Now that you’ve got a local database up and running you may want to take a look at how a SQL injection attack works. Your new database will be great for practice! If you have any issues getting your database up and running, please reach out in the comments below. We would love to assist you!

Getting Started with 'Terminal' - MUST READ Before You Start Programming

Programmers use 'Terminal' to issue commands, instead of the graphical user interface - which is meant for common users.

You MUST have some basic knowledge on using the Terminal and the file system. Read 'Unix Survival Guide for Mac & Ubuntu - Terminal, File System and Users'.

How to Install JDK and Get Started with Java Programming on Mac

Read HERE.

Programming Text Editors for Mac

TextEdit for Mac

TextEdit (the default text editor in Mac OS X) is NOT a programming text editor, as it lacks features like syntax highlighting. I strongly suggest you install a programming text editor.

To use TextEdit to write source file, you need to open a new file ⇒ choose 'Format' ⇒ 'Make Plain Text'.

You can open an existing file in TextEdit from Terminal by issuing:

nano (or pico) Command-line Text Editor

nano is a GNU text editor that is available for Unix Systems (including Mac OS X), that is suitable for creating/editing small files. To start nano, open a Terminal and issue:

You can run nano with superuser (for accessing restricted directories), as follows:

JEdit for Mac

jEdit is a popular open-source cross-platform (Mac, Windows, Linux) programming text editor. The mother site is http://www.jedit.org.

Step 1: Download and Install jEdit for Mac

Download jEdit package from http://www.jedit.org ⇒ Download ⇒ Select Mac OS X package (stable version).
Double click the downloaded Disk Image ('.dmg') file. Drag the 'jEdit' icon to 'Applications' folder.
Eject the Disk Image 'jedit.dmg'.

Step 2: Install 'Console' plugins

Launch jEdit (from 'Applications').
Open plugin manager: From 'Plugins' menu ⇒ Plugin Manager.
Select 'Install' tab.
Search and select 'Console' plugin. 'ErrorList' plugin will selected automatically ⇒ Install.

Step 3: Write a Hello-World Java Program

Open a new file by selecting 'File' menu ⇒ 'New'.
Enter the following Java source code and save the file as 'Hello.java'.

Step 4: Compile and Run the Hello-World Java Program

You can start a 'Terminal' to compile and run your Java program as described in the above JDK section.

You can also use the 'Console' plugin:

To compile: From Plugins ⇒ Console ⇒ Compile Current Buffer. Click on the 'Console' button to view the console. If message 'Process javac exited with code 0' appears, the program is compiled successfully.
To run: From Plugins ⇒ Console ⇒ Run Current Buffer.

gedit for Mac

gedit is the official text editor of the GNOME desktop environment. The mother site for gedit is http://projects.gnome.org/gedit/.

Download gedit for Mac (DMG version) from http://projects.gnome.org/gedit/ ⇒ 'gedit mac os x' ⇒ Choose your specific Mac OS version.
To install:
1. Double-click the downloaded Disk Image ('.dmg') file.
2. Drag the 'gedit' icon to the 'Applications' folder.
3. Eject the Disk Image 'gedit.dmg'.

Notes: To use 'gedit' commands in Terminal, you need to add '/Applications/gedit.app/Contents/MacOS/' to PATH environment variable.

Sublime

@ http://www.sublimetext.com.

How to Install Eclipse on Mac

Read 'How to Install Eclipse for Mac OS'.

How to Install NetBeans on Mac

Read 'How to Install NetBeans on Mac'.

How to Install MySQL 5.6 on Mac OS X 10.7 Lion

Install MySQL using the DMG Package

Reference: 'Installing MySQL on Mac OS X' @ http://dev.mysql.com/doc/refman/5.6/en/macosx-installation.html.

Step 1: Download and Install MySQL

Download the MySQL 'DMG Archive':

Go to http://dev.mysql.com/downloads/mysql/. In platform, select the 'Mac OS X'.
Select the appropriate 'DMG Archive' for your specific Mac OS version:
- Click the Apple logo ⇒ 'About this Mac' to check your Mac OS version.
- Read http://support.apple.com/kb/ht3696 to check if your OS is 32-bit or 64-bit.
For example, Choose 'Mac OS X ver. 10.7 (x86, 64-bit), DMG Archive (117.5M)' for Lion and Core i7 processor.
Click 'No thanks, just start my download'.

To install MySQL:

Go to 'Downloads' ⇒ Double-click '.dmg' file downloaded.
Double-click 'mysql-5.5.{xx}-osx10.x-xxx.pkg' ⇒ Follow the instructions to install MySQL. Click continue if 'unindentified developer' warning dialog appeared.
MySQL will be installed in '/usr/local/mysql-5.5.{xx}-osx10.x-x86_xx' directory. A symbolic link '/usr/local/mysql' will be created automatically to the MySQL installed directory.
Eject the '.dmg' file.

Step 2: Configuring MySQL - Change TCP Port Number for MySQL Server

The default TCP port number used by MySQL Server is 3306.
[For novices: SKIP THIS STEP to run the MySQL Server on port 3306. Goto Step 3.]
You can change the port number by editing the configuration file 'my.cnf' at directory '/usr/local/mysql'. To create this file, open a new 'Terminal' and run the 'nano' editor using this command: Modify the lines in green and add in the lines in red; and press ctrl-X to exit. (We use the 'nano' editor in this case, you can use any text editor, but run in superuser.)

Notes: On Unix/Mac, the MySQL read the options file in this order: '/etc/my.cnf', 'SYSCONFDIR/mf.cnf', '$MYSQL_HOME/my.cnf', '~/.my.cnf'.

Step 3: Start/Shutdown the MySQL Server

Open a new 'Terminal' and issue these commands to start the MySQL server:

To shutdown the server, start a new terminal and issue:

Step 4: Start/Stop a MySQL Client

Open a new 'Terminal' and issue this command to start a MySQL client with superuser root:

To terminate the client, issue command 'exit' (or 'quit') from the 'mysql>' prompt:

Notes:

You can use 'Activity Monitor' (under Applications/Utilities) to check if the MySQL Server is running. Look for process starting with mysqld.
The log messages are written to /usr/local/mysql/data/xxx.err, where xxx denotes your machine name. Issue 'sudo cat /usr/local/mysql/data/xxx.err' to view the messages.
If you get the following error message when starting a client: 'Can't connect to local MySQL server through socket '....', check your 'Activity Monitor' to see if the MySQL server has been started.

Step 5: (For Java Programmers) Install MySQL JDBC Driver

Download the latest JDBC driver from http://www.mysql.com/downloads ⇒ MySQL Connectors ⇒ Connector/J ⇒ Compressed TAR archive (e.g., mysql-connector-java-{5.x.xx}.tar.gz, where {5.x.xx} is the latest release number).
Double-click on the downloaded TAR file to expand into folder 'mysql-connector-java-{5.x.xx}'.
Open the expanded folder. Copy the JAR file 'mysql-connector-java-{5.x.xx}-bin.jar' to JDK's extension directory at '/Library/Java/Extension'.

How to Uninstall and Remove MySQL 5

Open a Terminal ⇒ Run the 'nano' editor to edit /etc/hostconfig, as follows: Delete this line if present: 'MYSQLCOM=-YES-'. Press cntl-x to exit 'nano' and enter 'Y' to save the file. The line 'MYSQLCOM=-YES-' starts MySQL automatically during startup.
Make sure that MySQL is not running (Open the 'Activity Monitor' under the 'Applications/Utilities', and check for the process 'mysqld'). Open a Terminal and issue 'rm -r' to remove these directories and their sub-directories (with 'f' indicating no confirmation prompt).

That's all!

(Advanced) Install MySQL using Tarball

Reference: http://dev.mysql.com/doc/refman/5.5/en/macosx-installation-pkg.html.

[TODO]

How to Install Tomcat 7 on Mac

Step 1: Download and Install Tomcat

Goto http://tomcat.apache.org ⇒ Download ⇒ Tomcat 7.0 ⇒ 7.0.{xx} (where {xx} denotes the latest release) ⇒ Binary distribution ⇒ Core. Download the 'tar.gz' package (e.g., 'apache-tomcat-7.0.{xx}.tar.gz').
To install Tomcat:
1. Goto '~/Downloads', double-click the downloaded TAR file (e.g., 'apache-tomcat-7.0.{xx}.tar.gz') to expand it into a folder (e.g., 'apache-tomcat-7.0.{xx}').
  (Notes for Advanced Users) Alternatively, you can use the tar command to expand the tarball as follow:
2. Move the extracted folder (e.g., 'apache-tomcat-7.0.{xx}') to '/Applications'.
3. Rename the folder 'tomcat', for ease of use.

(Notes for Advanced Users):

It is probably better to keep the tomcat in '/usr/local' or '/Library'.
Instead of renaming the tomcat's folder, it it better to create a symlink called tomcat as follows:
For security reason, you should not run Tomcat as root user. Instead, assign Tomat to user nobody (of group nobody):

Step 2: Configure Tomcat Server

Read 'Configure Tomcat Server'.

Step 3: Start the Tomcat Server

To start the Tomcat server, open a new 'Terminal' (Go ⇒ Utilities ⇒ Terminal) and issue:

Check for the Tomcat server's TCP port number from the console messages. The default is 8080.

To verify if the Tomcat server is started, start a browser (Safari) and issue URL http://localhost:8080, suppose that Tomcat is running on the default TCP port number of 8080.

Also try URL http://localhost:8080/examples which shows the Servlet/JSP examples.

Step 4: Shutdown the Tomcat Server

To shutdown the Tomcat server, you can simply press control-c (NOT command-c) on the tomcat console, or issue command:

Step 5: Servlet API

To write Java servlets, you need to COPY the Servlet API JAR file ('servlet-api.jar') from '/Applications/tomcat/lib' to the JDK's extension directory at '/Library/Java/Extension'.

Installing GCC and Get Started with C/C++ Programming on Mac

To install

Goto http://connect.apple.com, and login with your AppleID.
Download 'Command Line Tools (OS X xxxx) for XCode' Disk Image (DMG).
Double-click the download disk image (DMG) ⇒ Open 'Command Line Tools (xxx).mkpg' ⇒ Follow the instructions to install.
Eject the disk image.

To verify:

Installing XCode & Get Started

XCode is the development toolset for Mac, iPhone/iPad, which includes the Mac OS SDK (for Mac) and iOS SDK (for iPhone/iPad).

To install:

Goto http://connect.apple.com, and login with your AppleID.
Download 'XCode 4.x' Disk Image (DMG) - It is HUGE!
Double-click the download disk image (DMG) ⇒ Open 'XCode' ⇒ Follow the instructions to install.
XCode will be installed in '/Developer/Applications/Xcode'.
Eject the disk image.

To start Xcode, launch 'XCode' from '/Developer/Applications'.

Install Mysql Workbench Mac Catalina

[TODO] Getting Started

More on Terminal & Bash Shell

Goto 'Terminal & Bash Shell'.

Mac's Tips & Tweaks

Install Mysql Mac Catalina

Root (or Superuser, or Administrator)

In some cases (such as installing software and starting server), you need to be the so-called root user (or superuser or administrator) of your machine to complete some commands that require high privilege. Put 'sudo' (superuser do) in front of your command to run the command as root user, and provide the your password. Only authorized user can issue sudo command. For example, to start the MySQL server:

How to View All Files in Finder

Open a terminal and enter this commands:
Stop the Finder via:
Re-start the Finder. You shall see all the files (including the dot files and dot folders) now.

Install Apache Php Mysql Mac Catalina

Miscellanous

The equivalent of Windows' 'Task Manager' in Mac is called 'Activity Monitor' under 'Applications/Utilities'.
The page-up, page-down, home and end keys are fn-up-arrow (or command-up-arrow), fn-down-arrow (or command-down-arrow), fn-left-arrow and fn-right-arrow, respectively.

Install Mysql 5.7 Mac Catalina

Contributed by Wang Qiang (WANG0586@e.ntu.edu.sg).