Has anyone had any issues running mysql2 on the latest version of MacOS (10.15.1)? Recently, updated my laptop to Catalina and rebuilt all my gems successfully. MySql2 seems to be crashing every time I start the rails server using Puma. Here's the problem: Unable to start an any Rails project using MySQL2 gem. The laptop is running MySQL 5.6. This tutorial will go through the process of getting Apache, MySQL, PHP (or otherwise known as the 'AMP' stack) and phpMyAdmin running on the new mac OS Big Sur. This guide will also work on macOS Catalina and Mojave. This tutorial sets up the AMP stack in more of a traditional way using the loaded Apache and PHP and downloading MySQL.
Navicat for MySQL, DBeaver, and TablePlus are probably your best bets out of the 15 options considered. 'Excellent choice of import/export options' is the primary reason people pick Navicat for MySQL over the competition. This page is powered by a knowledgeable community that helps you make an informed decision. SQLPro for MySQL is the Premier application for editing and viewing MySQL databases on mac os x. SQLPro for MySQL. But still supporting Catalina and Mojave.
Recently I came across a very strange issue on my MAC OSX Catalina 10.15.0 where MySQL server wouldn't start. I've tried so many options and solutions but failed every single time. What i investigated while solving the fix for this issues as it seems like some sort of a conflict between the old MySQL versions.
In this short article, we’ll go through the commands to fix this issues.
What we’ve done is used brew’s remove & cleanup commands, unloaded the launchctl script, then deleted the mysql directory in /usr/local/var, deleted my existing /etc/my.cnf and launchctl plist
Take Databases Dumps
Its always a better practice to take your Databases dumps before removing any of mySQL files.
Removing MySQL
Please note that your plist will be based on the version of mySQL you’ve used.
Reinstall MySQL
Now we’ll try to reinstall MySQL using Homebrew
Start the server to able to log on to it
For mysql_secure_installation, use the alternative script and follow the instructions and set your secure password
Launchctl libraries
Followed the launchctl section from the brew package script output such as
To Startlaunchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
To Stoplaunchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
Boom!
Your MySQL must be back up now and ready to go. Hope this helps.
In this tutorial we will learn to install Apache, MySQL, PHP on macOS Mojave 10.14.
macOS Mojave
Apple released the new macOS Mojave 10.14 on 24th September 2018 and it includes Apache and PHP.
We will be using the pre-installed Apache and PHP and we will download and setup MySQL database.
Lets go ahead and configure our LAMP stack development environment on macOS Mojave.
Apache
The new macOS Mojave comes with Apache pre-installed. All we have to do is switch it on.
Open Terminal using macOS Spotlight or go to /Applications/Utilities and open Terminal.
To check the version of Apache installed run the following command in the Terminal.
macOS Mojave comes with Apache/2.4.34.
To start Apache web server run the following command.
This command will start Apache server.
When you use sudo in the terminal then you will be prompted to enter your admin password to proceed.
If you want to stop the Apache server then run the following command.
And to restart Apache server run the following command.
After starting Apache server go ahead and test it by opening a browser like Safari or Chrome and visit http://localhost.
You will get to see the following output in your browser.
In case you don't get to see the above output then run the following command to check the error.
Document Root
This is the location in the computer file system from where the files are accessed when we visit the localhost in a browser.
Document Root is a directory where we put our website files.
On Mac we have two document root. One is at the system level and the other is at the user level.
System level document root
The system level document root in macOS Mojave is located in the following directory.
User level document root
For the user level we can create a directory called Sites in user directory.
Creating Sites directory
Run the following command to switch to the user home directory.
Now, run the following command to create the Sites directory.
For me the user document root path is the following.
Creating username.conf file
Now, its time to create a username.conf file which will help in configuring our document root.
Note! Replace the username with your username.
For example, my username is yusufshakeel so, my file is yusufshakeel.conf.
Type the whoami command in the terminal and it will tell you your username.
Open terminal and go to the following directory.
Now create the configuration file username.conf inside the users directory.
In the following example I am using vi editor. You can use other editors like vim or nano.
Press the i key to enter into INSERT mode. Now, type the following inside the file.
Don't forget to replace YOUR_USER_NAME with your username.
Here is what I have written in my yusufshakeel.conf file.
Now, to come out of the INSERT mode press the Esc key. And to save the file and exit type the following :wq and hit Enter.
The permission of this file should be the following.
If not, then use the following command to change its permission.
Where, username is your username that you have set earlier.
Configuring the httpd.conf file
Mysql Download Mac Catalina
Type the following command in the terminal and go to apache2 directory.
Inside this directory we have the httpd.conf file.
As a good practice we will make a backup copy of the httpd.conf file by typing the following command in the terminal.
Now open the httpd.conf file using vi and uncomment the following lines.
To uncomment the following lines remove the # from the start of the line.
Uncomment the following line for User home directories.
Now change the DocumentRoot.
Find the following lines and comment them by adding # at the beginning of the line.
And add the following two lines below the commented lines.
Mysql For Mac Catalina
Don't forget to replace YOUR_USERNAME with your username.
And set the AllowOverride None to AllowOverride All.
Your DocumentRoot should now look something like the following.
Now, come out of the INSERT mode by pressing the Esc key. And save and exit the file by typing :wq key and then Enter.
Configuring the httpd-userdir.conf file
Now, we will make some changes in the httpd-userdir.conf file.
Type the following command in the terminal to go to the extra directory.
As a good practice we will first create a backup copy of the httpd-userdir.conf file. Type the following command to create a backup copy.
Now open the file using vi.
Uncomment the following line.
Now check that everything is configured properly by typing the following command in the terminal.
And then restart Apache using the following command.
PHP
macOS Mojave comes with PHP 7.1.x pre-installed.
To check the version of PHP in the Terminal type the following command.
Alright, type the following command in the terminal to go to apache2 directory.
Open the httpd.conf file.
Enter into INSERT mode by pressing the i key and uncomment the following line to run PHP 7 by removing the # sign from the start of the line.
Now, save the changes and exit the file by typing :wq keys and hit Enter.
You can now restart Apache by running the following command.
Start Mysql Mac Catalina
Printing phpinfo
Create index.php file inside the Sites directory by running the following command.
Now open this file in your favourite text editor or PHP IDE and write the following code.
Now, visit http://localhost and you will get to see a similar output.
Download MySQL community server
Mysql Workbench Mac Catalina
Head over to mysql.com website and download the latest version of the MySQL Community Server.
Download and run the installer and follow the steps to install MySQL database on your Mac.
Set the root password when prompted and note it down.
To run MySQL server open System Preferences and go to MySQL.
Click on the Start MySQL Server button to start the server.
You will be asked to enter your admin password. Enter the password and the MySQL server will start running.
Extra
To access your MySQL database tables you can either use phpMyAdmin, MySQL Workbench or Sequel Pro.
Alright, this brings us to the end of this tutorial. Hope this helped. Please share if you find this website useful. Have fun developing. See you in the next tutorial.