To be able to install and run MySQL Workbench on Windows your system needs to have libraries listed below installed. The listed items are provided as links to the corresponding download pages where you can fetch the necessary files. Microsoft.NET Framework 4.5.
For a list of macOS versions that the MySQL server supports, see https://www.mysql.com/support/supportedplatforms/database.html.
MySQL for macOS is available in a number of different forms:
- I just installed MySQL on Mac OS X. The next step was setting the root user password, so I did this next: Launch the terminal app to access the Unix command line. Under the Unix prompt I executed these commands: $ cd /usr/local/mysql/bin $./mysqladmin -u root password 'password'.
- MySQL Workbench is available for Mac OS X and is distributed as a DMG file. The file is named mysql-workbench-oss-version-osx10.5-i686.dmg, where version is the MySQL Workbench version. To install MySQL Workbench on Mac OS X, simply download the file. Double-click the downloaded file.
- This includes the following releases, containing bug fixes and minor enhancements: MySQL Administrator 1.1.7 for Windows MySQL Administrator 1.1.6 for Linux MySQL Administrator 1.1.3 for Mac OS X MySQL Query Browser 1.1.19 for Windows MySQL Query Browser 1.1.18 for Linux MySQL Query Browser 1.1.18 for Mac OS X MySQL Administrator is a GUI.
- MySQL Workbench is available for Mac OS X and is distributed as a DMG file. The file is named mysql-workbench-oss-version-osx10.5-i686.dmg, where version is the MySQL Workbench version. To install MySQL Workbench on Mac OS X, simply download the file. Double-click the downloaded file.
- Native Package Installer, which uses the native macOS installer (DMG) to walk you through the installation of MySQL. For more information, see Chapter 2, Installing MySQL on macOS Using Native Packages. You can use the package installer with macOS. The user you use to perform the installation must have administrator privileges.
- Compressed TAR archive, which uses a file packaged using the Unix tar and gzip commands. To use this method, you will need to open a Terminal window. You do not need administrator privileges using this method, as you can install the MySQL server anywhere using this method. For more information on using this method, you can use the generic instructions for using a tarball, Installing MySQL on Unix/Linux Using Generic Binaries.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.
For additional information on using MySQL on macOS, see Chapter 5, General Notes on Installing MySQL on macOS.
To interact with MySQL by instead of using the command line, phpMyAdmin comes to the rescue, to get it running as part of your local development set up on OS X, a couple of steps need to be done. phpMyAdmin is a browser application that interacts with the underlying mysql data.
These steps will work on Mac OS X 10.9 Mavericks, OSX 10.8 Mountain Lion, 10.7 and 10.6 Snow Leopard.
Preparing for phpMyAdmin
Download the latest version now at version 4.something phpMyAdmin, the english.zip should be sufficient, after the file is downloaded unzip it and move it to your personal web sharing folder, this will either be “/Users/username/Sites” directory or other web root folder such as “/Library/WebServer/Documents/“.
Rename the folder from “phpMyAdmin-4.0.0-english” to “phpmyadmin“.
The rest of the tutorial assumes that you have already mysql set up with a mysql root user and password enabled if not then please follow that process first.
The rest of the tutorial assumes that you have already mysql set up with a mysql root user and password enabled if not then please follow that process first.
The login address for phpMyAdmin is going to be http://localhost/~username/phpmyadmin/ or http://localhost/phpmyadmin/ depending on your web root directory, but before this will work correctly a few steps need to be done namely addressing the MySQL socket error and configuration file set up:
a) Launch /Applications/Utilities/Terminal to fix the mysql 2002 socket error by entering the following commands:
Basically this is making an alias to where phpmyadmin thinks the mysql.sock is and where it actually is.
b) In the phpmyadmin folder in your web root make a new directory named “config”.
c) Give Others “write“permissions to the “/phpmyadmin/config” folder either through Get Info or a ‘chmod o+w‘ in Terminal.
Installing phpMyAdmin
Older Safari browser currently has issues with the installation, blank screens?? Upgrade to Safari 6 or use either Chrome or Firefox. https://tsbrown622.weebly.com/download-iskysoft-youtube-downloader-for-mac.html.
Now we are ready to run the set up in the browser by going to:
http://localhost/~username/phpmyadmin/setup/
or
http://localhost/phpmyadmin/setup/
The new server to be configured is the localhost, click new server and then the only other configurations are the local mysql root user and the password in the Authentication tab.
Add in the username, by default “root” is assumed, add in the mysql root password (this is the password for mysql not https://tsbrown622.weebly.com/mac-os-x-emoji-font-download.html. for the OSX admin account) , click on save and you are returned to the previous screen.
Make sure you click on save, then a config.inc.php is now in the /config directory, move this file to the root level of /phpmyadmin and then remove the now empty /config directory.
Now going to http://localhost/~username/phpmyadmin/ or http://localhost/phpmyadmin/will now allow you to interact with your MySQL databases.
Mac Os Mysql Gui
Mcrypt missing extension – If your applications don’t require the mcrypt extension there is no need to worry about it missing as reported in phpMyAdmin, if you do need to install it follow the guide here on mcrypt extension in Mavericks.
Mysql Administrator Mac Os X Download 10 8
Upgrading phpMyAdmin is an easy task just grab the latest version from the phpmyadmin website and replace your older phpMyAdmin directory in your web shared folder apart from the “config.inc.php” file – make sure the config.inc.php is kept and put it back in the new directory.