I’ve changed the path to “C:\MySql\” to keep it simple. You can see the default Paths selected by MySQL as “C:|Program files\MySQL\MySQL Server 5.5\”. Step 3: Change the Default Paths(Optional). Choose Custom(to change the defaults and control what exactly we need to be Installed) as shown below.
>Next -> Read the License agreement -> Next. Double Click on the msi file, you’ll be welcomed with the Installation screen as seen below. Step 2: I’ve downloaded 64-Bit Windows msi file. Choose your appropriate Operating System/X64/X86 as shown in the below Screenshot.
Step 1: Go to and download MySQL Community Server. Yeyyyy…….SQL Server is almost there leading the Market share ? Now Oracle acquired MySql, So…What would be my choice if i want to learn any RDBMS besides MS SQL Server? Ofcourse MySql ?Īnyways….If you are interested in Installing MySql, you can follow the rest from now on! Reason 5: Below is a screenshot from “Gartner Group” on trends/Market Share of RDBMS platforms. (You could get more benefited if you Install on a Unix Machine) I can download “MySQL Community Server” for absolutely free and Install on my Laptop and learn/Explore how things work with a very very less pain compared to Oracle, but I’ll be learning almost similar concepts as of Oracle. MySql has almost all the functionality very similar to Oracle. Reason 4: Why MySql? MySql is an open source, well, not 100%, since it was acquired by Oracle in year 2010. What is SQL Server Missing when compared to Oracle, What is Oracle missing when compared to SQL Server and So on…. Reason3: SQL Server Vs Oracle!!!….Personally I love SQL Server(May be because I’m administering SQL Servers, I did SQL 2000, 2005/2008/R2 and always carried the passion and Zeal and am totally into Microsoft), but I was always very curious to Know how things work in Oracle. Reason2: Gaining Knowledge is never a loss ? There’s no harm pushing it into our brains as much as we can. Reason 1: Well, exposure to other products besides SQL Server is an Obvious Reason to Explore other RDBMS Softwares.
In this Post, let’s see how to Install MySQL on a Windows Machine! Before doing that, let me tell you why/how one gets benefited knowing multiple RDBMS Platforms. Save the file by hitting CTRL + X.Well, Let’s deviate a little bit from SQL Server in this Blog Post.listen.owner = nobody to listen.owner = nginx.Open PHP-FPM configuration: nano /etc/php-fpm.d/www.conf
Root /var/index index.php index.html index.htm įastcgi_pass unix:/var/run/php-fpm/php-fpm.sock įastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name Īdd new user and give password useradd prabinĬreate folders mkdir -p /var/chown -R prabin:prabin /var/chmod 755 /var/www/ # note that these lines are originally from the "location /" block Systemctl status php-fpm Step 5: Configuring Nginx to work with PHPĬreate a new Nginx configuration file by running nano text editor: nano /etc/nginx/conf.d/.conf Yum install php php-mcrypt php-cli php-gd php-curl php-mysql php-ldap php-zip php-fileinfo -y To install PHP 5.6, you have to install and enable EPEL and Remi repository to your CentOS 7 system using the commands below. Mysql_secure_installation Step 5: Installing PHP 5.6 Your page should look like this: Step 3: Installing MySQL (MariaDB) yum install mariadb-server mariadb -y Step 2: Installing Nginx on CentOS 7 yum install epel-release -yĬheck whether Nginx is running or not by visiting your server’s public IP address. In this guide, we’ll discuss how to configure server blocks in Nginx in centos 7.