Adrians-macbook-pro: ama$ mysql -version mysql Ver 14.14 Distrib 5.7.9, for osx10.9 (x8664) using EditLine wrapper Install MySQL Workbench. If you want to have also a GUI on top of it I recommend you install the MySQL Workbench that can be also found in the downloads section. Installation instruction is the same as the MySQL server installation.

Mysql Workbench Download For Macbook Pro Zoom

1 Tag;Count 2 c#;101811 3 java;62386 4 php;53884 5.net;49639 6 javascript;46608 7 asp.net;45444 8 c;38691 9 jquery;38321 10 iphone;35754 11 python;31852 12 sql;25316 13 mysql;23236 14 html;21936 15 sql-server;18360 16 ruby-on-rails;18181 17 c;17256 18 objective-c;17250 19 css;16429 20 wpf;15950 21 android;15614 22 asp.net-mvc;15034 23 windows. Db2 is a line of data management products from IBM. It includes a well-known relational database management system (RDMS) that IBM introduced in 1983 to run on its MVS (Multiple Virtual Storage) mainframe platform.

I have been always playing with the Apache, PHP, and MySQL every time but since when I switched to Mac and wanted to make a web development environment on my Mac. So the first step is to install Apache, PHP, and MySQL.

Install Apache for Mac OS

Since Mac OS is ultimately built on Unix so it is very to install any Unix supporting software. The most interesting part is that Mac OS comes with the Apache web server and we just need to start it and make some changes to setup our development environment.

Mysql Workbench Download For Macbook Pro 2020

Now, We need to start the apache server with root privileges to avoid permission issues.

Therefore, just launch the terminal type the command as follows:-

After starting Apache – test to see if the webserver is working in the browser – http://localhost – you should see the “It Works!” text.

Creating Apache VirtualHosts

The default location for Apache webserver project files is /Library/WebServer/Documents/. In this location, you all can create your application in order to host your web applications.

For

To enable VirtualHosts, we need to make some changes in the Apache Configuration file (httpd.conf).

Make sure that you change your DocumentRoot, ServerName and Directory location according to your needs.

Now your VirtualHosts setup is done now, just restart the apache with command

Install PHP on Mac OS X

In order to install PHP, in Mac OS you will just need to enable PHP support for Apache, i.e, to need to make changes in its (httpd) configuration file.

Open httpd.conf file with the command as follows:-

Uncomment below the line and save it.

LoadModule php7_module libexec/apache2/libphp7.so

Now restart the server and it should be able to process PHP files. To test it we can create a simple PHP file as below.

Create test.php file in the /Library/WebServer/Documents/ directory with the following lines of code as shown below and save it.

Load the PHP file in browser with URL http://localhost/test.php and you should see a huge page with all the PHP configurations as shown below:-

Congrats now you have successfully installed PHP on your Mac OS.

Installing MySql on Mac OS

Installing MySQL in Mac OS is very simple you will just have to download MySQL dmg file from the MySQL website and just press next, next in order to install.

Download the MySql DMG file from MySql Download Website.

Open the DMG file and install MySql server

Start the MySql server if it’s not running and you can find MySQL in system preferences.

Click on MySQL and you will see the screen as below:-

If you want to control MySQL through your terminal then you will have to add MySQL directory to your shell path, this is done in your “.bash_profile” file in your home directory if you don’t have that file just create it using vi or nano:

open that “.bash_profile” and add the following line and save it.

export PATH=${PATH}:/usr/local/mysql/bin/

Now, you can access MySQL through your terminal, in order to check just type the command as follows:-

Mysql workbench download for macbook pro zoom

Now, you have successfully connected your MySQL server through your terminal.

If you want to change the MySQL root password then just login to MySQL and the query as follows:-

Change the lowercase ‘MyNewPass’ to what you want – and keep the single quotes.

Now you have successfully installed all your web development environment. If you want to GUI to manage MySQL then you can install MySQL workbench.

Mysql Workbench Download For Macbook Pro 10 11 6

If you have any queries do post your questions in the comment section below: 🙂