However, I could not see anything in Applications. Mysql-5.5.28-osx10.6-x86_64.pkg -> I double-clicked it to run, after clicked buttons a few times it's said to be successfully installed. Then I double clicked mysql-5.5.28-osx10.6-x86_64.dmg, it's mounted, and shows
Here is a sample PHP file that connects to MySql server.My Mac runs Mac OS X, version 10.7.5., so it's a 64 bit system.įirst, I downloaded mysql-5.5.28-osx10.6-x86_64.dmg. 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.
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.