Ease of use with '3 minutes from download to development' installation and configuration. Low administration with very little database maintenance required. Replication providing flexible topologies for scale-out and high availability. Partitioning to improve performance and management of very large database environments. Go to the MySQL Community Site and Download version 5.6 instead. This will install fine and hopefully soon, an Oracle technician will knock on my door and tell me that they got version 5.7 working and I can upgrade. Actually please don’t do that Oracle, do not knock on my door. That would be creepy.
15 4 likes 54,062 views Last modified Nov 24, 2013 4:14 PM
This User Tip describes how to download, install, and setup MySQL for use on OS X. It includes an optional section for Perl support. Please read through the entire User Tip before starting.
Requirements:
Optional:
Xcode (with command line tools) is required for the MySQL Perl driver.
Lines in bold are what you will have to type in at the Terminal.
Replace <your local host> with the name of your machine. Ideally, it should be a one-word name with no spaces or punctuation. It just makes life easier.
Replace <your short user name> with your short user name.
Download Mysql 5 7 22 For Mac Os
Download MySQL from a local mirror. You want the Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive. At the time of writing this User Tip, the current version is 5.5.34. By the time you read this, there may be a newer version to use instead. Open the archive mysql-5.5.34-osx10.6-x86_64.dmg.
Download Mysql 5 7 22 For Mac 64-bit
Install only the mysql-5.5.34-osx10.6-x86_64.pkg package. Ignore everything else.
Mysql 5 7 28 Download
MySQL comes with a Preference Pane and Startup Item that are based on technologies that Apple deprecated years ago. If you install the Preference Pane or Startup Item, your MySQL installation could fail at some point in the future when Apple removes support for Startup Items. This was reported to MySQL a long time ago. Until MySQL gets around to fixing this bug, we will have to do it ourselves.
Create a launchd config file for MySQL:
sudo vi /Library/LaunchDaemons/com.mysql.mysql.plist
Use the following content:
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE plist PUBLIC '-//Apple//DTD PLIST 1.0//EN' 'http://www.apple.com/DTDs/PropertyList-1.0.dtd'>
<plist version='1.0'>
<dict>
<key>KeepAlive</key>
<true/>
<key>Label</key>
<string>com.mysql.mysqld</string>
<key>ProgramArguments</key>
<array>
<string>/usr/local/mysql/bin/mysqld_safe</string>
<string>--user=mysql</string>
</array>
</dict>
</plist>
(if you are new to vi, type 'i' to enter insert mode. Then ⌘-v to paste the above content. Press escape to get back to command mode. Then type 'ZZ' to save and exit.)
The default path for the MySQL socket is not appropriate for MacOS X. Until it is changed, MySQL will not be able to communicate with PHP should you choose to enable that. Let's fix this now.
Create a config file for MySQL that matches the Apple PHP build:
sudo vi /etc/my.cnf
Use the following content:
[client]
socket=/var/mysql/mysql.sock
Open office download mac os x.
[mysqld]
socket=/var/mysql/mysql.sock
Visual studio 2017 community mac download. Start MySQL:
Mysql Server 5.7 Download
sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysql.plist
MySQL is now up and running. Don't forget to set a root password and configure your users if this is all you need.
If you need to configure Perl support for MySQL, don't setup a root password just yet. Having no password will make testing the Perl module easier. Keep reading..
You will need Xcode and command line tools for this part.
Download the MySQL Perl driver.
Extract the archive with:
tar zxvf DBD-mysql-4.020.tar.gz
Move into the directory:
Download Mysql 5 7 22 For Mac Download
cd DBD-mysql-4.020
First, fix the MySQL client library. (credit)
For Lion, type:
sudo install_name_tool -id /usr/local/mysql-5.5.34-osx10.6-x86_64/lib/libmysqlclient.18.dylib /usr/local/mysql-5.5.34-osx10.6-x86_64/lib/libmysqlclient.18.dylib
Download norton antivirus 12 for mac os.
Next, build DBD::mysql with:
perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config --testsocket=/var/mysql/mysql.sock --testuser=root
make
make test
sudo make install
Now you can set a root password and configure your users.
Posted by: Glen McAllister Date: April 20, 2018 08:54PM
Hi, I’ve got a bash installer for MacOS which basically does a bit of pre- and post- install actions and runs the .pkg installer from the command line. With this latest (5.7.22) version, I’ve found that the installer will give you a temporary root password, but it seems to not be used, in that: 1 - attempting to change the password with either the mysql client or mysqladmin fails using that temporary password 2 - after the installation (and the post-installation actions my script performs) I can log in with the previous root password. After literally *hours* of trying to alter my script to cope with this 5.7.22 installation, I just ignored the temporary password and everything seems ok - I can log in with the existing root password and I’m using 5.7.22. The only way I can make sense of this is that the installer is issuing a temporary password and not using it - to change the root user’s password anyway. This is not as silly as it sounds as with previous versions of the installer, a temporary password was not always issued and, because this was an incremental upgrade (from 5.7.21) I was not expecting it to be this time, either. I was going to lodge a bug report for this version of the installer (Mac OS .dmg 10.13 5.7.22), but thought I would ask here if anyone had experienced anything similar? Regards, GAM (Glen A McAllister)
Options:Reply•Quote
Written By
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |