#MYSQL DOWNLOAD FOR MAC OS X HOW TO#
#MYSQL DOWNLOAD FOR MAC OS X INSTALL#
#MYSQL DOWNLOAD FOR MAC OS X UPGRADE#
#MYSQL DOWNLOAD FOR MAC OS X PASSWORD#

#MYSQL DOWNLOAD FOR MAC OS X PASSWORD#

Once the root user and password is set, you have to interact with mysql with the username and password, so access via command line is (note that there is no space between -p and the password) mysql -u root -p If this is a new installation you can just answer yes to the questions.Go ahead and just hit enter if this is a new installation and no password currently exists, follow the prompts to set up a new root password вЂ“ this is a root password just for mysql separate from the root password of OS X you should set this. You havenвЂ™t set the root password yet, the password will be blank,Д®nter current password for root (enter for none): In order to log into MySQL to secure it, weвЂ™ll need the current

SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL Secure Way sudo mysql_secure_installation Then when login to mysql to test your password mysql -u root -pyourpasswordhere Regular Way mysqladmin -u root password 'yourpasswordhere' Set the master MYSQL password, there are 2 ways to do this one is a regular way and the other provides additional security and disables all other access However you need to copy your data directory to new location to make sure your existing databases are intact post upgrade.

#MYSQL DOWNLOAD FOR MAC OS X UPGRADE#

*Please note /usr/local/mysql is only symlink to /usr/local/mysql-5.5.14-osx10.6-x86_64 which means when you upgrade to new version symlink will be changed to point to new version but wonвЂ™t be deleting the older version. Then add this line below export PATH =/usr/local/mysql/bin: $PATH Optionally you can edit the ~/.profile file to make your aliases (This should be done as root) pico ~/.profile alias mysql /usr/local/mysql/bin/mysqlДЄlias mysqladmin /usr/local/mysql/bin/mysqladmin Sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock Create your alias, this is important so that you can run MYSQL queries through the terminal. This command will circumvent the dreaded mysql 2002 socket error. Replace вЂњ/tmp/mysql.sockвЂќ with вЂњ/var/mysql/mysql.sockвЂќ at two places near the top.Д¬reate a folder called вЂњmysqlвЂќ (if you donвЂ™t already have one) in the /var directory with the right permissions: cd /var Run the following commands cd /usr/local/mysqlД¬p /usr/local/mysql/support-files/my-small.cnf /private/etc/my.cnf Then mysql was not started, go back to the System Preference and start the database. If you got the error: ERROR 2002 (HY000): CanвЂ™t connect to local MySQL server through socket вЂ/tmp/mysql.sockвЂ™ To find the MySQL version from the terminal, type at the prompt /usr/local/mysql/bin/mysql -v Once the installs are done you can start the mysql server right from the System Preferences which has a new preference in the вЂњOtherвЂќ category called вЂњMySQLвЂќ click start and now it is running.

Open the DMG and you will see that the first item is the MySQL software, the 2nd item allows MySQL to start when the Mac is booted and the third is a System Preference that allows start/stop operation and a preference to enable it to start on boot.

#MYSQL DOWNLOAD FOR MAC OS X INSTALL#

( It will ask for Master password, as it installs MySQL server in /usr/local )Д¬urrent latest version is 5.5.14 which IвЂ™ll be using to install on my server. Mount the Disk Image (I mean open/double-click the DMG file) and install MySQL server by double-clicking the PKG file (in my case mysql-5.5.14-osx10.6-x86_64.pkg) and follow onscreen instructions.Download and install the 64-bit 10.6+ version of MYSQL installer package together with the startup files here.

#MYSQL DOWNLOAD FOR MAC OS X HOW TO#

Lets get started with a brief walkthrough of how to install MYSQL on an OSX Lion Server. On the contrary installing and configuring MYSQL to run on an OSX Lion server is moderately easy and gives greater insight as to how MYSQL works (If your a novice to intermediate MYSQL user like me).

Just because it is not endorsed or pre-configured by Apple however does not mean that it can not be used. It is also a fact that most people who continue to buy Apple Servers have been using MYSQL for some time and have websites or other content that sill relies on this technology. It is a fact that Apple has migrated itself away from MYSQL.

Mysql download for mac os x