MySQL Administrator is a GUI management console for MySQL, with support for tasks such as managing users, configuring MySQL, performing backups, editing table definitions etc. There are fully native versions for Linux/Gtk, Windows and now Mac OS X. This is the first public Beta release of MySQL Administrator for that platform. I was waiting the official release of Mavericks since about half a year. I was positively surprise to find out the update came free of charge. So I updated my Mac OS the moment the update was made available on AppStore. It was no surprise to see the upgraded versions of PHP, Ruby, Python, mysql. Mac Os X 10 10 free download - Apple Mac OS X Mavericks, Apple Mac OS X Snow Leopard, R for Mac OS X, and many more programs.
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.
In this tutorial, I am going to explain how to download and install MySQL on Mac OS X in a few easy steps.
Download latest stable version of MySQL server for your OS X version and architecture. Link: http://dev.mysql.com/downloads/mysql/. Please make sure you download the .dmg file.
Click on the downloaded .dmg file and unpack it. Click on the mysql server package from unpacked files.
Install MySQL server by clicking on the mysql package to open up the installer. If you want to install the startup script to automatically start MySQL server at the time of system startup, you should also install the start up package of mysql now (included in the unpacked MySQL package that you just downloaded and unpacked as a separate file).
Once the installer has finished successfully, all MySQL related files should be installed under /usr/local/mysql-VERSION directory. A link /usr/local/mysql (pointing to the MySQL installation directory) should also have been created for your convenience.
If you had installed the automatic startup package at the time of installation, you should now be able to start MySQL running the following command in OS X Terminal window or by restarting the operating system: Kirk cousins.
As soon as you run the command above, your system might ask for permission to allow MySQL server to accept incoming connections. You must give the permission to listen on port 3306 (or change it later to run on a different port).
In case, you did not install the startup script, you have to run mysqld_safe under /usr/local/mysql/bin/mysqld_safe script.
If you want to disable automatic MySQL starts at the time of system startup, you can change the value of MYSQLCOM in /etc/hostconfig to '-NO-' (without quotes).
You should also consider including /usr/local/mysql/bin/ in your system PATH variable.
In order to connect to MySQL using command line client, do the following from OSX terminal:
This will connect you to mysql server. Please make sure that you run mysql_secure_installation after finishing installation to secure your MySQL installation.
Did this tutorial help a little? How about buy me a cup of coffee?
Please feel free to use the comments form below if you have any questions or need more explanation on anything. I recommend thoroughy testing on aproduction-like test system first before moving to production.
Welcome to part 2 of the MAMP tutorial. In this part we will go over setting up Mysql on your Mac’s localhost. Part 1 goes over everything you need to do to setup PHP on a Mac
What green means: any lines that you need to replace in this tutorial will be in green.
You need to download and install Mysql on your mac.
1. Go to the MySQL site, scroll down the page and look for version Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive. Click the blue download button.
This will take you to a page that asks you to login or signup. You don’t have to signup, instead there is a link right below these buttons. Click the link “No thanks, just start my download.” This will start the download.
2. After downloaded you will need to install all 3 of the components in the package.
Double-click on each package to install them.
mysql-5.6.10-osx10.6-x86_64.pkg – MySQL software
MySQL.prefPane – Allows mysql to stop/start
MYSQLStartupItem.pkg – Allows mysql to start when booted
To start MySQL via the command line
Or you can click Start MySQL Server when the dialog opens after installing the 2nd package.
Set MySQL root password:
That’s it. You have MySQL installed and running on your localhost.
In part 3 I will be going over setting up phpMyAdmin
Part 1: How to install Apache and PHP on a Mac with OSX 10.8 + (MAMP Part 1)
Part 3: How to setup phpMyAdmin on a Mac with OSX 10.8 + (MAMP Part 3)
Part 4: How to enable and setup php.ini on a Mac with OSX 10.8 + (MAMP Part 4)
Part 5: How to host multiple sites on your Mac (MAMP Part 5)