Some times It might just enter “hung state” annoyingly!!! In that case, try disabling Windows Firewall/Firewall from any Antivirus Software temporarily and try to run MySQL Configuration Wizard again or even Uninstall/Re-Install(with the exact same options/paths what you have chosen earlier) sometimes. Step 12: Click Execute and Keep your Fingers Crossed □ If everything goes well, it should be pretty quick and you will be getting the below Screen! Choose a very strong and Secure Password. Step 10: Choose Install MySQL as a Windows Service and Check “Include BIN Directory in Windows Path” checked as shown below. Leave it to default unless you really understand what you are trying to do by changing character set!! You can see below. You can change it if needed, make sure that you’ve checked “Add an exception to this Port” Button as shown below. By default MySQL TCP Port for communications is 3306(Remember, it’s 1433 for SQL Server). You can choose either DSS(OLAP) or OLTP or also you can define your Own number. Step 7: Now, choose how many concurrent connections you would want to allow to connect to your MySql Instance. Step 6: Now, Choose where you want your InnoDB TableSpace (Data files) to be Placed. This is a huge huge difference from Installing MS SQL Server Database Engine! If you want both, with no exceptions/issues, Choose “Multi Functional Database”. If you want truly ACID Database, you can choose “Transactional Database Only” (This will make InnoDB Storage Engine as the Main Storage Engine). Step 5: This is a crucial decision now! If you want only Databases, which are not necessarily needed to obey ACID Properties, you can choose “Non-Transactional Database only”.( With this Option, InnoDB Storage Engine will not be Installed). You can see this in the below Screenshot. It’s your choice, all it matters is how your CPU/Memory resources are consumed my MySql Server. Now, I selected “Developer Machine” considering many SQL Server Instances already I’ve on this machine!. Step 4: Now you will be welcomed with Instance Configuration Wizard as shown below.Ĭhoose “Detailed Configuration” as shown below Keep the “Launch the MySQL Instance Configuration Wizard” button checked as shown below. Now, you should be getting a window with “Next Button” as the only option to select as shown below.Ĭlick Next ->Next and now you should see “Completed MySQL Server 5.5 Setup Wizard” window. Make sure that you changed both for MySQLServer and Server Data Files. 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. Well, Let’s deviate a little bit from SQL Server in this Blog Post.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |