Download Mysql Administrator For Mac
Mac OS X Mountain Lion (10.8.) need to install XCode and Command Line Tools before installing MySQL. You can refer to for those steps. You can for the Mac OS X. I downloaded the Mac OS X, Version 10.6 (x86, 64-bit) version for this installation. There were a couple shell syntax tricks beyond the instructions and then you need to configure database. That’s required because the database is installed with an unsecured anonymous and root account. After the step-by-step installation instructions, you’ll find the configuration steps to enable you to access the MySQL Monitor from a terminal session.
It also configures your $PATH environment to enable you to start and stop the MySQL Daemon. After the download completes, open the file folder in the download directory. The open file folder and it will look like the following. Launch the mysql-5.5.9-osx 10.6-x8664.pkg file, which installs the product. After launching the executable, you are now on the first page of the Install MySQL 5.5.9 installation application. Click the Continue button. This page contains the instructions, you can pause to read them or continue with these instructions.
Click the Continue button to proceed. This page contains the General Public License (GPL).
You agree or stop the installation. Click the Continue button to proceed.
The following overlay dialog contains your agreement. Click the Agree button to proceed. There are fewer options in this installation than the Windows installation. While you can change the installation location, the software installs by default in the /usr/local/mysql directory. The installation requires that you have a mysql user account on the operating system, and you don’t need to do anything because one exists as part of the default Mac OS X installation. Click the Install button to proceed.
This dialog requires the system administrator’s password. Enter the valid password and click the OK button to proceed. Depending on the system, this could take more than a minute.
All you can do it wait. This page tells you that you’ve completed the installation.
Click the Close button to proceed. This step requires that you return to the download folder, shown in Step #2 above.
Launch the MySQLStartupItem.pkg and you’ll see the following MySQL Startup Item Installer dialog. Click the Continue button to proceed. This page contains the instructions for the MySQL Startup software, you can pause to read them or continue with these instructions. Click the Continue button to proceed. This page asks if you want to change the directory. I’d recommend you leave it as the default because it requires the System Administrator’s password to start and stop the database.
It should also start for you every time you boot the machine. Click the Continue button to proceed. Like Step #8, this dialog requires the system administrator’s password. Enter the valid password and click the OK button to proceed. You could see a progress dialog box but generally it happens so fast you should land at the Installation was Successful dialog.
Register taylormade drivers for mac. Click the Close button to proceed. This step requires that you return to the download folder, shown in Step #2 above. Launch the MySQL.prefPane and you’ll see the following MySQL Preferences dialog. Click the Install button to proceed. Like Step #8 and #14, this dialog requires the system administrator’s password.
Enter the valid password and click the OK button to proceed. Don’t click in the automatic start button unless you’re sure. Otherwise, there’s a lot of cleanup to be able to return to this point and start or stop the server as required. This is the last screen, you should click the Start MySQL Server button to start MySQL.
While installing MySQL 5.5.18 I discovered that the service menu is no longer installed in the Preferences, and you must start it manually. You can start and stop the service by opening your System Preferences, where you’ll find them in the bottom Other row. If the intent was to have it start automatically, sometimes the permissions are incorrect. You’ll get the following error in MySQL 5.5.9 but not in MySQL 5.5.16 because the MySQL DMG file is fixed. You can skip the instructions until you get to Configure User’s Shell Environment below. '/Library/StartupItems/MySQLCOM' has not been started because it does not have the proper security settings. '/Library/StartupItems/MySQLCOM' has not been started because it does not have the proper security settings.
You can fix this by changing the permissions manually in a Terminal Session. Launch a Terminal Session from your Utilities folder inside your Applications folder. Change directory to the /Library/StartupItems/MySQLCOM directory. Then, list the files. These commands should do the trick for you. Sudo chown root:wheel MySQLCOM cd.
Sudo chown root:wheel MySQLCOM Now you need to configure your shell environment and harden the database. Hardening means securing accounts with passwords. They’re covered in the next two sections. Configure User’s Shell Environment Assuming you accepted the defaults, you should be able to copy the required instructions directly into a.bashlogin file if one exists.
Unless you’ve created one before there won’t be a file. Mac OS X doesn’t automatically create the file. If you don’t have the file, you can create one with the following syntax.
# Set the MySQL Home environment variable to point to the root directory of the MySQL installation. Export set MYSQLHOME= /usr /local /mysql-5.5.16-osx10.6-x8664 # Add the /bin directory from the MYSQLHOME location into your $PATH environment variable. Export set PATH= $PATH: $MYSQLHOME /bin # Create aliases that make it easier for you to manually start and stop the MySQL Daemon. Alias mysqlstart= 'sudo /Library/StartupItems/MySQLCOM start' alias mysqlstop= 'sudo /Library/StartupItems/MySQLCOM stop' # Set the MySQL Home environment variable to point to the root directory of the MySQL installation. Export set MYSQLHOME=/usr/local/mysql-5.5.16-osx10.6-x8664 # Add the /bin directory from the MYSQLHOME location into your $PATH environment variable.
Export set PATH=$PATH:$MYSQLHOME/bin # Create aliases that make it easier for you to manually start and stop the MySQL Daemon. Alias mysqlstart='sudo /Library/StartupItems/MySQLCOM start' alias mysqlstop='sudo /Library/StartupItems/MySQLCOM stop' Changes between MySQL 5.5.16 and 5.5.18 introduce a new directory structure, you need to use the following in the.bashlogin file (added sudo and status per Don McArthur’s comments). # Set the MySQL Home environment variable to point to the root directory of the MySQL installation. Export set MYSQLHOME= /usr /local /mysql-5.5.18-osx10.6-x8664 # Add the /bin directory from the MYSQLHOME location into your $PATH environment variable. Export set PATH= $PATH: $MYSQLHOME /bin # Create aliases that make it easier for you to manually start and stop the MySQL Daemon.
Alias mysqlstart= 'sudo /Library/StartupItems/MySQLCOM/MySQLCOM start' alias mysqlstop= 'sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop' alias mysqlstatus= 'ps aux grep mysql grep -v grep' # Set the MySQL Home environment variable to point to the root directory of the MySQL installation. Export set MYSQLHOME=/usr/local/mysql-5.5.18-osx10.6-x8664 # Add the /bin directory from the MYSQLHOME location into your $PATH environment variable. Export set PATH=$PATH:$MYSQLHOME/bin # Create aliases that make it easier for you to manually start and stop the MySQL Daemon.
Alias mysqlstart='sudo /Library/StartupItems/MySQLCOM/MySQLCOM start' alias mysqlstop='sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop' alias mysqlstatus='ps aux grep mysql grep -v grep' As pointed out by Shashank’s comment, you should now use the following aliases. Alias mysqlstart= 'sudo /usr/local/mysql/support-files/mysql.server start' alias mysqlstop= 'sudo /usr/local/mysql/support-files/mysql.server stop' alias mysqlstart='sudo /usr/local/mysql/support-files/mysql.server start' alias mysqlstop='sudo /usr/local/mysql/support-files/mysql.server stop' You need to save the file and close and restart a new Terminal session to place these environment variables in scope. You could also run the following to put them in scope without closing and opening the terminal. /usr/local/mysql-5.5.16-osx10.6-x8664/bin/mysql /usr/local/mysql-5.5.16-osx10.6-x8664/bin/mysql Secure the Database This is presently necessary because of the different file structure in a Mac OS X MySQL install, which disables the mysqlsecureinstallation file from running successfully. You can manually edit the file or follow these steps. You need to connect to the database as the privileged super user, root user. This is simple because the installation doesn’t set any passwords.
You open another Terminal session to make these changes or you could install MyPHPAdmin or MySQL Workbench. The tools work as well in fixing the majority of issues. 1. Row.
user: root password: host: localhost. 2. Row. user: root password: host: MacPro.local.
3. Row. user: root password: host: 127.0.0.1.
4. Row.
user: root password: host:::1. 5. Row.
Using Mysql On Mac
user: password: host: localhost. 6. Row. user: password: host: MacPro.local.
1. Row. user: root password: host: localhost. 2. Row. user: root password: host: MacPro.local. 3.
Row. user: root password: host: 127.0.0.1. 4. Row. user: root password: host:::1. 5. Row.
user: password: host: localhost. 6. Row. user: password: host: MacPro.local You now need to change the password for the root user. I would suggest that you do this with the SQL command rather than a direct update against the data dictionary tables.
Download Mysql Administrator For Mac Mac
The syntax to fix the root user account require you enter the user name, an @ symbol, and complete host values, like. SET PASSWORD FOR 'root'@ 'localhost' = password ( 'cangetin' ); SET PASSWORD FOR 'root'@ 'MacPro.local' = password ( 'cangetin' ); SET PASSWORD FOR 'root'@ '127.0.0.1' = password ( 'cangetin' ); SET PASSWORD FOR 'root'@ '::1' = password ( 'cangetin' ); SET PASSWORD FOR 'root'@'localhost' = password('cangetin'); SET PASSWORD FOR 'root'@'MacPro.local' = password('cangetin'); SET PASSWORD FOR 'root'@'127.0.0.1' = password('cangetin'); SET PASSWORD FOR 'root'@'::1' = password('cangetin'); You should be able to drop both anonymous user rows with the following syntax, but I did encounter a problem. Assuming you may likewise encounter the problem, the fix follows the first commands you should try. Recent Posts. Things Written About Things Written About Pages. Blogroll.
Archives.