keropwireless.blogg.se - Getting started on mysql on mac

GETTING STARTED ON MYSQL ON MAC HOW TO
GETTING STARTED ON MYSQL ON MAC INSTALL
GETTING STARTED ON MYSQL ON MAC ARCHIVE
GETTING STARTED ON MYSQL ON MAC UPGRADE
GETTING STARTED ON MYSQL ON MAC PASSWORD

Copy the password to text file (or take a screenshot) and press okay.

Once you get to the end of the installation, you’ll see a popup that gives you your MySQL username (root) and password (8hxKsiIh?YMt).

Click on the downloaded file, double click the pkg file, and go through the installation which should look like this:.

Scroll down and click No thanks, just start my download.

GETTING STARTED ON MYSQL ON MAC ARCHIVE

Scroll down until you see three download buttons and click on the one next to DMG Archive.

Go back to Safari and refresh the localhost page and you’ll see Hello From Sites Folder! with PHP info that shows PHP 7 is being used.

Press Ctrl+O followed by Enter to save these changes.

Replace both occurrences of /Library/WebServer/Documents with /Users/david/Sites (instead of david use your name which can be found at the top of your terminal next to the home icon).

Go back to Terminal and enter sudo nano /etc/apache2/nf.

Save index.php in the Sites folder you created.

Open your favorite text editor and create a file called index.php with the following code:.

Create a new folder and name it Sites (The Safari icon shown below gets added automatically to the Sites folder as shown below).

This will take you to your home directory, which will also be whatever your computer is named in this case it's david.

Click on Finder at the bottom left corner of your screen and click on Go > Home the top navigation bar.

Type sudo apachectl restart and press enter.

Press Ctrl+O followed by Enter to save the change you just made.

Delete the # from #LoadModule php7_module libexec/apache2/libphp7.so.

Press Ctrl+W which will bring up a search.

Open Terminal and type sudo nano /etc/apache2/nf and press enter.

Thankfully High Sierra already comes with PHP 7.1!!!

GETTING STARTED ON MYSQL ON MAC UPGRADE

This caused users to get annoyed because it didn’t come with PHP 7, so you’d have to go through extra work to upgrade from PHP 5 to PHP 7. Before High Sierra (version 10.13), Mac came with PHP 5 installed.

GETTING STARTED ON MYSQL ON MAC INSTALL

Mac already comes with PHP, so you don’t need to install it from PHP.net.

Open Safari (or your browser of choice), type localhost in the address bar, and press enterĬan’t believe it’s that easy? It is! You should now see It works! in the browser.

Type sudo apachectl start and press enter.

Open Terminal by clicking on the magnifying glass at the top right corner of your screen and searching for Terminal.

See the MySQL Installation Guide on the MySQL website for more information. Or, you could use the compressed TAR archive, which uses a file packaged using the Unix tar and gzip commands. If you don’t want to use Homebrew, you can install it via the Native Package Installer, which uses the native macOS installer (DMG) to walk you through the installation of MySQL. Here’s an example of a quick command you can use to see a list of databases: show databases Ĥ rows in set (0.007 sec) Alternatives to Homebrew You can now go ahead and start using MySQL. Once connected, you should see something like this: MySQL > Once MySQL has started, we can go ahead and connect to it: mysql -uroot That should eventuate in a message like this: Successfully started `mysql` (label: ) Connect to MySQL Now that we’ve installed MySQL, let’s start it using the first method listed above: brew services start mysql That message provides useful information for getting started. opt/homebrew/opt/mysql/bin/mysqld_safe -datadir=/opt/homebrew/var/mysql Or, if you don't want/need a background service you can just run: MySQL is configured to only allow connections from localhost by default Once installed, the following message appears: We've installed your MySQL database without a root password. Wait patiently while it downloads and installs everything. Now that Homebrew is installed, let’s go ahead and install MySQL: brew install mysql If you’re already up to date, you’ll get a message to that effect.

GETTING STARTED ON MYSQL ON MAC HOW TO

While we’re at it, here’s how to update Homebrew: brew update Xcode and Homebrew should be installed once those commands have been run.īut before we move on, here’s how to check Homebrew: brew doctorįollow any prompts to fix any problems that may have been encountered. Install Homebrew: /bin/bash -c "$(curl -fsSL )" To install these prerequisites, open a Terminal window and run the following commands. You can skip this step if you’ve already got Homebrew installed. Seeing as I’m installing MySQL via Homebrew, it requires that Homebrew is installed. The current version (MySQL 8.0.26) supports the ARM architechure. Below are the steps that I used to install MySQL on my M1 Mac via the Homebrew package manager.Īs mentioned, this is an M1 Mac (which uses the ARM64 architecture) but that didn’t cause any issues.