![]() 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. ![]() ![]() Migration also supports migrating from earlier versions of MySQL to the latest releases.Well, Let’s deviate a little bit from SQL Server in this Blog Post. Developers and DBAs can quickly and easily convert existing applications to run on MySQL both on Windows and other platforms. MySQL Workbench now provides a complete, easy to use solution for migrating Microsoft SQL Server, Microsoft Access, Sybase ASE, PostreSQL, and other RDBMS tables, objects and data to MySQL. ![]() Plus, with 1 click, developers can see where to optimize their query with the improved and easy to use Visual Explain Plan. Performance Reports provide easy identification and access to IO hotspots, high cost SQL statements, and more. DBAs can quickly view key performance indicators using the Performance Dashboard. MySQL Workbench provides a suite of tools to improve the performance of MySQL applications. Learn more » Visual Performance Dashboard Developers and DBAs can use the visual tools for configuring servers, administering users, performing backup and recovery, inspecting audit data, and viewing database health. MySQL Workbench provides a visual console to easily administer MySQL environments and gain better visibility into databases. The Object Browser provides instant access to database schema and objects. The Database Connections Panel enables developers to easily manage standard database connections, including MySQL Fabric. The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort. MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |