Please check out “ How to install MySQL Community Server on macOS 12 Monterey (2021)” on installing MySQL server on your Mac M1. In this post, I will be using a local MySQL server as an example. It is either Database in your local system or it could be a remote database in your hosting server or even a cloud database such as AWS RDS. Before Installing the MySQL Workbench on macOS 12 Montereyīefore installing the MySQL Workbench, make sure you have access to the database.
If you are more of a visual person who needs to deal with databases (MySQL), MySQL Workbench is a very powerful and useful tool. You can see the tables, records in the table, you can create a new schema, query, etc. MySQL Workbench is a GUI tool to manage your database. Before Installing the MySQL Workbench on macOS 12 Monterey.Here is a sample PHP file that connects to MySql server. Pankajs-MacBook-Pro:mysql root# ln -s /tmp/mysql.sock mysql.sock Pankajs-MacBook-Pro:var root# mkdir mysql The easier solution is to make a symbolic link pointing to the actual MySql socket sudo su. When we install MySql, its socket file is located at /tmp/mysql.sock but when PHP tries it locate it, it look at /var/mysql directory. Mysql> GRANT ALL ON *.* TO OK, 0 rows affected (0.00 sec) Mysql> create user identified by 'pwd123' Type '\c' to clear the current input statement. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Server version: 5.5.25 MySQL Community Server (GPL)Ĭopyright (c) 2000, 2013, Oracle and/or its affiliates. For easier access to MySql scripts, I have added MySql bin directory to my PATH and exported export mysql -h localhost -u root -p
You can download it from SequelPro Website.īefore I move forward to test MySql connectivity from PHP program, I will create a database and user.
There are so many Mac OS softwares that you can use for MySql database management but I liked SequelPro most, its easy to install and use and uses very less memory. Start the MySql server if its not running and optionally you can select the checkbox to automatically start MySql server on startup.Open the DMG file and install MySql server and Preference Pane for starting and stopping MySql server easily.Download the MySql DMG file from MySql Download Website.Lets move now to install MySql database server on Mac OS X. If the request is still going to the Internet, try flushing your DNS cache using command dscacheutil -flushcache.
Just put a simple HTML file (abc.html) in the server directory and try to access it in the browser. Our virtual hosts setup is done now, just restart the apache with command apachectl restart Pankajs-MacBook-Pro:~ root# vi /etc/hosts The next thing we need to do is add the server URL to known hosts file, else it will go to DNS server and the request will be redirected to Internet rather than loading it from the local machine. The Directory directive is added to avoid any permission issues.
Make sure to change the DocumentRoot, ServerName and Directory location according to your needs. ServerAlias ErrorLog "/private/var/log/apache2/-error_log"ĬustomLog "/private/var/log/apache2/-access_log" common Pankajs-MacBook-Pro:~ root# vi /etc/apache2/extra/nfĪdd following configuration for a new VirtualHost and save it. We can proceed now to HTTPD virtual hosts file. Now when Apache will load the configuration file, it will also load the virtual hosts configuration file. Pankajs-MacBook-Pro:~ root# vi /etc/apache2/nf To enable VirtualHosts, we need to make some changes in Apache Configuration file (nf). Default location for Apache web server project files is /Library/WebServer/Documents/ which is not a convenient place to keep our project files, also we will have to access it in browser with localhost, so I decided to create my own virtual host pointing to my development directory.