Jan 19, 2017 Like other users I am unable to install MySQL Utilities 1.5.6 or earlier; I also tried to install MySQL Connector/Python 2.1.3 (as suggested earlier in the thread on this issue OS X 10.11.1 (El Capitan) but that also failed. As of this writing, the latest version, 5.7.11 is labeled for OS X 10.10 but I was able to install it with no problems on El Capitan (10.11). During the installation, you will be asked to create a password for the root MySQL user – make sure to write this password down somewhere safe!
MySQL is a free relational database, now owned by Oracle.
Installing MySQL
Here are instructions for setting up a 64-bit MySQL on Mac OS X, tested Vst host mac free download.
August 2010 with 10.6.4 Snow Leopard (MySQL 5.1.49),
October 2012 with 10.8.2 Mountain Lion (MySQL 5.6.17),
April 2014 on 10.9.2 Mavericks (MySQL 5.6.25),
Oct 2015 on 10.10.5 Yosemite (MySQL 5.6.25),
May 2016 on 10.11.5 El Capitan (MySQL 5.7.13),
July 2017 on 10.12.6 Sierra (MySQL 5.7.19 and MySQL 5.7.24).
March 2018 on 10.13.3 High Sierra (MySQL 5.7.19 and MySQL 8.0.13).
January 2019 on 10.14.1 Mojave (MySQL 8.0.14).
Oracle does not list a recommended version for Catalina (10.15). Python generate an aes key.
August 2010 with 10.6.4 Snow Leopard (MySQL 5.1.49),
October 2012 with 10.8.2 Mountain Lion (MySQL 5.6.17),
April 2014 on 10.9.2 Mavericks (MySQL 5.6.25),
Oct 2015 on 10.10.5 Yosemite (MySQL 5.6.25),
May 2016 on 10.11.5 El Capitan (MySQL 5.7.13),
July 2017 on 10.12.6 Sierra (MySQL 5.7.19 and MySQL 5.7.24).
March 2018 on 10.13.3 High Sierra (MySQL 5.7.19 and MySQL 8.0.13).
January 2019 on 10.14.1 Mojave (MySQL 8.0.14).
Oracle does not list a recommended version for Catalina (10.15). Python generate an aes key.
(10 Jun 2018) Oracle provides version 8.0.11 for OS X 10.13 High Sierra and Mojave. Check the Release Notes for bug fixes and new features. I found that some queries that used to work failed with the new version: see below. Hp 1320 driver for mac os x. Download the OSX version DMG file of the MySQL Community Server from mysql.com. When I upgraded to 8.0.11, I flailed about because I did not read the upgrading directions carefully. Be smarter than I was. (Note that there are many features of MySQL that I don't exercise and have not tested; test it for your needs.)
Installing 8.0.13 on Mojave appeared to work. It asked me to supply a password for 'root'. However, there were problems installing DBD::mysql in CPAN. I was able to fix them. A later install on Mojave with 8.0.17 appeared to work.
Installing 5.7.21 on High Sierra was quick and did not encounter any problems.
I installed MySQL 8.0.11 on Sierra and it did not work: it got a linkage error. Had to install 5.7.24 instead.
- If you have a previous version of MySQL, dump its database to a .sql text file using mysqldump before installing.
- Rename $HOME/.my.cnf to something else if you have one.
- Stop MySQL before trying to install a new version.
- Download the correct x86-64 bit MySQL Community Server dmg file from the Community Server section of the Oracle MySQL site and install it. This will install the startup item and preference pane also. The Oracle installer sets the MySQL root password to a temporary value for MySQL 5.7. Write this down. Change this value after installation, before it expires (see below). The Oracle installer asks you for a strong MySQL root password for MySQL 8.0.11-17. Write this down.
- Put the MySQL commands on your PATH. One way to do this is to add export PATH=$PATH:/usr/local/mysql/bin to your .bash_profile
- Change your startup variables to export VERSIONER_PERL_PREFER_32_BIT=no or you will get a failure message about dyld when using DBD.
- Start the server using the ► System Preferences. ► MySQL pane.
- There were reports that under El Capitan and Sierra, MySQL puts a socket in the wrong place. Fix this with
- To change the root password, use mysqladmin -u root -p'temporarypassword' password NEWP
- Rename $HOME/.my.cnf back, or create one. If you are installing CPAN module DBD::mysql, read the directions and do that before setting up .my.cnf.
- To reload your database, do mysql < db.sql .
Setting up Auto Start
In El Capitan, Sierra, High Sierra, and Mojave, the MySQL preference pane works again, so you can use it to start MySQL on system restart. See below for Yosemite directions.
Cleaning Up
Your old MySQL database may still be on disk in a directory like /usr/local/mysql-VERSION/data/, and can be deleted at some point.
.my.cnf
If you make a file named .my.cnf in your home directory, then you can use the mysql command without giving a password. Mine contains
If you have only one database, you can put that value in the file also, with database=DBNAME.
Problems
Mojave
For Mojave, I downloaded and installed MySQL 8.0.13. This installed a System Preferences control panel. I clicked 'initialize database' (asked me to set root's database password) and then 'start MySQL' (required system admin password) and MySQL did not start. This may have been related to an antivirus product. I issued the Terminal command sudo launchctl load -w /Library/LaunchDaemons/com.oracle.oss.mysql.mysql.plist to start MySQL, and it started OK, and restarted after reboot just fine.
Sierra
For Sierra, see Neil Gee's page for instructions. (I do not install or use PHP or PHPMyAdmin, for security reasons, so I skipped those parts.) I also found a page that describes one user's process: https://weblog.rubyonrails.org/2009/8/30/upgrading-to-snow-leopard. I skipped the Ruby parts.
Hanging at Shutdown
When I initially installed Sierra, my machine inherited MySQL 5.7.13 from El Capitan, and it seemed to work. The only thing I noticed was that Sierra appeared to hang for about 30 minutes when shutting down. On a hunch, I opened the MySQL control panel and tried to stop the MySQL server; the control panel hung for about 30 minutes. Once MySQL had stopped, I could shut down the Mac quickly. I decided to install the latest MySQL.
Installation Problems
When I installed MySQL 8.0.11 on Sierra, I was unable to access MySQL from Perl via DBD::mysql. I got the message
In /usr/local/mysql-8.0.11-macos10.13-x86_64/lib/ I did ln -s libmysqlclient.21.dylib libmysqlclient.20.dylib because the .20 file did not exist. That worked better: I was able to use Perl to access MySQL.
Attempting to execute a SHOW TABLE STATUS command still failed, with the message
I did mysql_upgrade -u root -p and that fixed SHOW TABLE STATUS.
Default SQL Mode Changed Again
Executing queries that had worked on MySQL 5.7.13, I got failure messages from 8.0.1 like
Apparently MySQL had further strengthened the ONLY_FULL_GROUP_BY mode. I had to rewrite my queries to make them execute. My understanding is that MySQL was accepting ambiguous queries and executing somehow, not necessarily correctly. They changed to not accepting them. I couldn't find where this is documented, in the enormous list of changes.
El Capitan
Install problems
Under El Capitan the install appeared to fail, because the old version was running. Stop MySQL before installing with sudo launchctl unload -w /Library/LaunchDaemons/com.mysql.mysql.plist . Medal of honor for mac os x. This command will also stop MySQL from being started by the system, so that you can control it from the System Preferences pane.
Mysql Database For Os X El Capitan 10 11 6
Unable to Connect
I had trouble getting MySQL to work. It worked for a while but then after a reboot I kept getting a socket error.
Searching the web was little help. Finally I looked in /usr/local/mysql/data/mysqld.local.err and noticed the messages
This looked like a bad idea. I was not using IPV6 anywhere else. https://thingcelestial.weebly.com/loading-a-korg-poly-800-patches.html. In ► System Preferences. ► Network ► Ethernet ► Advanced I changed 'Configure IPV6' to link-local only and restarted. MySQL 5.7.13 was running and I could contact it.
Syntax Change
You can no longer say
mysql dbname --exec='source temppic.sql;'
and must change this to
mysql dbname --execute='source temppic.sql;'
so I had to modify all my shell scripts and Perl programs that used --exec. Hikvision ivms-4200 v1.02.03.02 for 10.11 mac os x newest update 2019.
mysql dbname --exec='source temppic.sql;'
and must change this to
mysql dbname --execute='source temppic.sql;'
so I had to modify all my shell scripts and Perl programs that used --exec. Hikvision ivms-4200 v1.02.03.02 for 10.11 mac os x newest update 2019.
Default SQL Mode Changed
Executing queries that had worked on older versions of MySQL, I got messages like
because MySQL has strengthened the ONLY_FULL_GROUP_BY mode and made it the default with version 5.7. (Basically, this was a MySQL-only feature that was not in standard SQL and whose interpretation was arguable.) A quick temporary fix is to execute the mysql command
omitting the ONLY_FULL_GROUP_BY mode (this will stick until you restart mysqld). You could also include this mode setting in the MySQL configuration to make it permanent.
A better long term fix is to recode the query that got the error: one way is to wrap the offending items with ANY_VALUE(), but this function is not backward compatible with older versions of MySQL. I recoded my queries to wrap the offending variables with an aggregation function such as MAX(), and that worked for most of them. For others, I actually had to think about what I was doing.
Yosemite
For Yosemite the Systen Preferences pane for MySQL did not work, so you had to set up a .plist file and point launchctl at it. See MySQL does not start in OSX Yosemite 10.10. This note is not quite accurate. follow these steps: set up the .plist file as described in the note, and set its access; then do sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysql.plist . BetterZip 4.2 (1435). MySQL should start, and restart after a system restart.
Mountain Lion
In Mountain Lion, I got a failure message about dyld when trying to install the Perl DBD module. Fixed with cd /usr/local; sudo mkdir lib; cd lib; ln -s/usr/local/mysql/lib/*.dylib .
(Gotcha:) With MySQL 5.6.17 on Mountain Lion, some of my database files would not load, because the mysql command fails, instead of warning, when a field value is too long for the field. This problem occurs because STRICT mode is now the default. The fix is to turn STRICT mode off, or fix the data.
Free El Capitan Os X
Home | FAQ© 2010-2019, Tom Van Vleckupdated 2019-10-13 17:06