2021. 4. 25. 01:26ㆍ카테고리 없음
MySQL is the most popular open source database management system. It allows you to quickly download and install and run a powerful database system on almost any platform available including Linux, Windows, and Mac OS X etc. The MySQL download can be found here. Download the Mac OS X 10.10 (x86, 64-bit), DMG Archive. When download is complete, open the installation packages by double-clicking the package icon. There will be a pop-up window that provides a temporary password for MySQL’s “root” user. This password will be a slew of random characters that is crucial to getting MySQL up and running smoothly. Using you can get safe official Mac OS X Yosemite 10.10.1 offline installer.Yosemite update various improvements over earlier versions. It is the most prominent being the introduction of Face Time. Continuity package which allows users to accept, Which is part of the and send calls from their computers in Mac OS X 10.10. Apple did a great job.
Our popular MySQL Installer for OS X 10.8 Mountain Lion has been upgraded to support OS X 10.9 Mavericks. The installer script is a part of our Mac-Scripts Github repository. More information about the scripts can be found at code.macminivault.com. There are other great automation scripts available on that page as well.
In addition to the core installation, the Package Installer also includes Chapter 3, Installing a MySQL Launch Daemon and Chapter 4, Installing and Using the MySQL Preference Pane, both of which simplify the management of your installation.
We encourage users and customers to join github, request features, report bugs, fork the repo and tweak our code. Ultimately we are trying to save everyone time and frustration with these scripts.
bash <(curl -Ls http://git.io/eUx7rg)The script performs the following tasks:
This script creates a modified my.cnf file named mmv.cnf. The performance settings will not be perfect for every MySQL server. The intention was to give a small performance boost in a generic way. This script gives the option to copy over the mmv.cnf file to /etc/my.cnf and restart MySQL. We encourage you to further tune your MySQL server after it is running for awhile. You can do so by running this command in your terminal and it will display stats and recommendations. (Credit Major Hayden for MySQLTuner)
Copy and paste this into terminal to run MySQLTuner:perl <(curl -Ls https://raw.github.com/major/MySQLTuner-perl/master/mysqltuner.pl)
Update: We have an updated post that shows how to install MySQL 5.7 on macOS Sierra.
Apple recently phased out MySQL in favor of PostgreSQL. There are still valid reasons why we might prefer MySQL, such as compatibility with legacy code.
Here are my instructions on how to install MySQL as a permanent service on OS X. These instructions work with or without OS X Server installed. For the most part, installation is straightforward, but read this carefully because there are gotchas where it comes to file permissions.
I’ve tested these instructions several times on OS X 10.11 El Capitan and 10.10 Yosemite. I think these instructions will probably work on 10.8 Mountain Lion and 10.9 Mavericks.
Backup your MySQL databases.
You want to back up your MySQL databases before doing a OS X upgrade. The easiest way is to create a mysqldump file. Databases can also be restored from data files, but this is harder and I don’t recommend it.
Install or upgrade OS X.
According to your plan.
Download Xcode from the App store and install the command line tools.
Xcode is a dependency for Homebrew, which uses Xcode’s gcc compiler to compile everything from source. Once you have Xcode installed, you need to install the command line tools for the gcc compiler to work. From Terminal:
Check the systemwide PATH variable.
Open a Terminal window:
Make sure that /usr/local/bin occurs before /usr/bin. If they don’t, then you need to change this order. Edit /etc/pathsusing vi or your favorite text editor. I love and use TextWrangler. Close your Terminal window and open a new Terminal window for this change to take effect.
Obtain Homebrew.
Homebrew is a great package manager for OS X that installs everything in /usr/local/binand does not require sudo.It then symlinks to the expected locations so that the packages can find one another. Because the packages are centralized in the Cellar, they are easily updated and removed.
Fix any problems that Homebrew detects.
Follow brew doctor‘s instructions. brew doctor usually complains about Xcode. If I’m guessing the error correctly, here is the solution that brew doctor will suggest (assuming OS X 10.10 – note the version since this affects what you will type into Terminal):
Run brew doctor again. Continue to follow brew doctor‘s instructions until it tells you that “Your system is ready to brew.”
Install MySQL.
Homebrew has just installed MySQL to run under the current user, which is not what we want for our server, but we will get to that in a moment. First, we will test the mysqld service to see if it launches. In newer versions of MySQL, the command to launch the service is $ mysql.server start.
Modify the .plist file to improve logging.
Using vi or your favorite text editor, modify the .plist file.
Add these lines within the <dict> block:
Set up the MySQL service to launch at boot time as part of a server.
Homebrew’s instructions, which I asked you to ignore, would have installed a LaunchAgent for your current user account, so that the mysqld service would start whenever you logged in. This would work great for a personal development machine, but it’s not not ideal for a server.
For a server, what we want is for mysqld to start up at boot time by the root account. So, we need to make two changes:
- the .plist must link into
/Library/LaunchDaemonsand have the appropriate permissions to be launched byroot. - the mysql database files in
/usr/local/var/mysqlmust all be owned by_mysql. You might wonder why the owner must be_mysql, since the server starts up asroot. This is because whenevermysqlddetects that it is being run asroot, the process steps down to user_mysqlas a security measure. This is typical behavior for services. Apache, for example, steps down to user_www.
Open a Terminal window, and enter:
Important: Now that mysql belongs to root, do not run the $ mysql.server command again! Don’t do it. This will result in an aborted launch with permissions errors. You will need to delete the resulting .pid files in /usr/local/var/mysql before mysqld will be able to run again, even as root. Again, don’t do it.
Verify that the MySQL service starts up at boot time.
We will reboot the server machine. At boot time, launchctl should load our modified .plist and run mysqld. We will then run the mysql command from Terminal to interface with the mysqld service and verify that it’s running.
After the machine restarts, re-enter Terminal and type:
If the mysql command fails, then we know that either the LaunchDaemon didn’t kick in, or that mysqld failed to start successfully. Again, if this happens it is usually because of a permissions issue. To troubleshoot, check the log files at:
Restore your MySQL databases.
Download Mysql For Mac Os X Yosemite
A full dump from a recent version of MySQL should successfully restore all databases plus the privilege table, which controls users. If there are problems with the privilege table after restoring, then edit out the privilege table from your mysql dump file, and re-create your users manually using a tool like phpmyadmin.
Mysql Download Mac Os X 10.100 Download
I hope this post helped someone. Happy monkeying!