This should be really straightforward, but I found myself googling around. I wrote a recent post about how to create a web app with the Laravel PHP framework but connecting to the database was tricky.
First step, find out what version of OS X you are running. Click the apple icon in the top right corner of your screen and click “About This Mac”. I got something like this:
Next step, head over to the MySQL downloads page. Rosetta stone english for mac download free version.
Install Mysql Server Mac
So with my computer I am running 10.11 and we want the .dmg file. Download Mac OS X 10.10 (x86, 64-bit), DMG Archive. Then you get to this lame screen:
MySQL is free and open source software (FOSS), you do not need to sign up or create an account. Click “No thanks, just start my download”. I let the download go directly to my “Downloads” folder when prompted, though you could place it anywhere. The download will take some time because it is 350mb, go get a coffee. Once the download is complete. Double click the file and a screen like this will open
MySQL client can be started from the terminal or command prompt by navigating to the directory as mentioned below for Mac/Linux or Windows. MAC - /usr/local/mysql/bin WINDOWS - C:Program FilesMySQLMySQL Server 8.0. The MySQL command-line client can be started by running the MySQL executable in the above directories. For using a GUI based. MySQL Workbench is available for Mac OS X and is distributed as a DMG file. The file is named mysql-workbench-oss-version-osx10.5-i686.dmg, where version is the MySQL Workbench version. To install MySQL Workbench on Mac OS X, simply download the file. Double-click the downloaded file. The MySQL Shell is an interactive Javascript, Python, or SQL interface supporting development and administration for the MySQL Server and is a component of the MySQL Server. You can use the MySQL Shell to perform data queries and updates as well as various administration operations. The MySQL Shell provides: Both Interactive and Batch operations. The first step is to download MySQL server. Go to the MySQL web site and select the version that matches your version of Mac OS. Archive version. After the DMG file finishes downloading click on it to open. Then open the installer inside and follow the installation steps. Mysql terminal free download - ZOC Terminal, Toad for MySQL, MySQL Database Server, and many more programs.
Double click it and go through the install process.
When I did it I got an alert box:
Add to path. This went in ~/.zshrc because I am using ZSH. If you are using bash for terminal (the default on OS X) this will be the ~/.bashrc file or ~/.bash_profile. This post explains the difference between the two files.
Add the mysql download to your path so that you can use the “mysql” command from the command line.
Then test it out: Disk installer not opening after download mac.
Now that we have MySQL installed and accessible from the Terminal, it’s time to connect to the database and start the MySQL server. Let’s log in as root user (root@localhost) and use that funky password that popped up in the alert window after our install. In the above case it’s
#fW&tYe?<8?w
Great! Now we can create databases and run SQL queries right from the command line. That’s an awesome start, but there’s no way anyone is going to remember that password, nor is it enjoyable to type in every time we want to run MySQL. The full docs on changing passwords are here. For OSX you can run the command:
How To Install Mysql In Mac Os
The
PASSWORD('root') sets my password to “root”. Easy to remember right? You can set your password to anything you like, such as PASSWORD('myN3wp@Ssw0rd') .
Free mp3 download mac. To stop the server in the terminal run
control + D . Congratulations! You’ve installed MySQL on OSX, made it accessible from the command line and updated your password for the root user.
To start setting up a Laravel application and connect to a database using Sequel Pro you can follow my next tutorial:
Thanks for reading!
Update (9/16/17): Expired passwords
When trying to login to MySQL on OSX recently I ran into the following error:
There are a lot of StackOverflow threads and articles about this, many require writing SQL commands, though that was difficult for me without access to the terminal. In order to alleiviate this I found this SO answer that saved me:
Update 03/29/18:
Update 05/14/19:
I found the solution in this homebrew issue. Create an empty directory for this path:
mkdir /usr/local/etc/my.cnf.d
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |