militarygasra.blogg.se - How to learn sql on mac

How to learn sql on mac mac os#
How to learn sql on mac install#
How to learn sql on mac code#
How to learn sql on mac download#

Udacity Prepares You for the Jobs of Today, Tomorrow, and Beyond

The downside is that this app only focuses on Swift, not any other programming languages or coding topics. New coding concepts are introduced with animatinos before you dive into the puzzles, and a glossary provides you with a comprehensive list of common terms. You can rotate with a finger and pinch to zoom to explore the world.

How to learn sql on mac code#

Here is a sample PHP file that connects to MySql server.With Swift Playgrounds, you can see your code run in a gorgeous, interactive three-dimensional world. 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.

How to learn sql on mac install#

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

How to learn sql on mac download#

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.

How to learn sql on mac mac os#

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.