How To Install MySQL

How To Install MySQL How To Install MySQL on Windows 10? Your One Stop Solution To Install MySQL Back Home Categories Online Courses Mock Interviews Webinars NEW Community Write for Us Categories Artificial Intelligence AI vs Machine Learning vs Deep LearningMachine Learning AlgorithmsArtificial Intelligence TutorialWhat is Deep LearningDeep Learning TutorialInstall TensorFlowDeep Learning with PythonBackpropagationTensorFlow TutorialConvolutional Neural Network TutorialVIEW ALL BI and Visualization What is TableauTableau TutorialTableau Interview QuestionsWhat is InformaticaInformatica Interview QuestionsPower BI TutorialPower BI Interview QuestionsOLTP vs OLAPQlikView TutorialAdvanced Excel Formulas TutorialVIEW ALL Big Data What is HadoopHadoop ArchitectureHadoop TutorialHadoop Interview QuestionsHadoop EcosystemData Science vs Big Data vs Data AnalyticsWhat is Big DataMapReduce TutorialPig TutorialSpark TutorialSpark Interview QuestionsBig Data TutorialHive TutorialVIEW ALL Blockchain Blockchain TutorialWhat is BlockchainHyperledger FabricWhat Is EthereumEthereum TutorialB lockchain ApplicationsSolidity TutorialBlockchain ProgrammingHow Blockchain WorksVIEW ALL Cloud Computing What is AWSAWS TutorialAWS CertificationAzure Interview QuestionsAzure TutorialWhat Is Cloud ComputingWhat Is SalesforceIoT TutorialSalesforce TutorialSalesforce Interview QuestionsVIEW ALL Cyber Security Cloud SecurityWhat is CryptographyNmap TutorialSQL Injection AttacksHow To Install Kali LinuxHow to become an Ethical Hacker?Footprinting in Ethical HackingNetwork Scanning for Ethical HackingARP SpoofingApplication SecurityVIEW ALL Data Science Python Pandas TutorialWhat is Machine LearningMachine Learning TutorialMachine Learning ProjectsMachine Learning Interview QuestionsWhat Is Data ScienceSAS TutorialR TutorialData Science ProjectsHow to become a data scientistData Science Interview QuestionsData Scientist SalaryVIEW ALL Data Warehousing and ETL What is Data WarehouseDimension Table in Data WarehousingData Warehousing Interview QuestionsData warehouse architectureTalend T utorialTalend ETL ToolTalend Interview QuestionsFact Table and its TypesInformatica TransformationsInformatica TutorialVIEW ALL Databases What is MySQLMySQL Data TypesSQL JoinsSQL Data TypesWhat is MongoDBMongoDB Interview QuestionsMySQL TutorialSQL Interview QuestionsSQL CommandsMySQL Interview QuestionsVIEW ALL DevOps What is DevOpsDevOps vs AgileDevOps ToolsDevOps TutorialHow To Become A DevOps EngineerDevOps Interview QuestionsWhat Is DockerDocker TutorialDocker Interview QuestionsWhat Is ChefWhat Is KubernetesKubernetes TutorialVIEW ALL Front End Web Development What is JavaScript â€" All You Need To Know About JavaScriptJavaScript TutorialJavaScript Interview QuestionsJavaScript FrameworksAngular TutorialAngular Interview QuestionsWhat is REST API?React TutorialReact vs AngularjQuery TutorialNode TutorialReact Interview QuestionsVIEW ALL Mobile Development Android TutorialAndroid Interview QuestionsAndroid ArchitectureAndroid SQLite DatabaseProgramming Your One Stop Solution To Install MySQL Published on Jul 12,2019 4.2K Views Sahiti Kappagantula Bookmark 2 / 6 Blog from Introduction To MySQL Become a Certified Professional There is no doubt in the fact that MySQL is one of the most popular relational database systems. This article is going to be a brief guide onHow to install MySQL, for beginners.MySQL is a database management system that is used extensively in todays industry. It comes with multi-user access to support many storage engines and is backed by Oracle.So, if you follow these few simple steps, you should be able to download and install MySQL on your Operating Systems, completely hassle-free.Now, to install MySQL, there are mainly three factors you must consider:Operating SystemWhat to use to install MySQL?Features you wish to installIn this article, I am going to install MySQL on Windows using the MySQL Installer.What is MySQL Installer?MySQL Installer makes it easy to install MySQL with the help of the wizard. Once you finish instal ling MySQL, you will see various other features installed, such as MySQL Server, MySQL Workbench, MySQL Shell and so on.Now, let us get started with the installation of MySQL.Installation of MySQL MySQL InstallerStep 1: Go to the official website of MySQL and scroll down. Then you will see an option to choose the Operating System. Here I will choose Windows.Step 2: After that, you will see two options to Download. If you have internet connectivity then you can go forward and choose the mysql-installer-web-community, else you can choose the other one. Refer below.Step 3: Once, you click on Download, you will be redirected to the following page:In the above page, just click on the option of No thanks, just start my download. Once, you click on this option, you will see that MySQL Installer is getting downloaded.Step 4: After MySQL Installer gets downloaded, double click on it, and you will see that the MySQL installer Community is getting installed. Once, it is downloaded you will se e the following screen.In the above dialog box, just check in in the radio button and accept the License Agreement. After that, click on Next.Step 5: In the next wizard, you have to choose the setup type. Basically, this is where you choose which features you wish to install. Here I will choose the option Full and click on Next.This option will MySQL Server, MySQL Shell, MySQL Router, MySQL Workbench, MySQL Connectors, documentation, samples and examples and much more.Step 6: Once you click on Next, you might see that some features may fail to install due to lack of requirements. So, either you can resolve them, or can skip them, by clicking on Next. Here I will click on Next.Step 6.1: Next, you will see a dialog box asking for your confirmation of a few products not getting installed. So, you can just click on Yes. Refer below.As soon as you click on Next, you will see the list of the products which will get installed. So, if you are fine with the products, go ahead and click onExe cute as below.Once you hit on Execute, you will see that the products are getting installed. Refer below:Now, once the installation is complete, click on Next.Server ConfigurationNext, you have to configure the Server and Router. Well, over here let me tell you that, I am not going to configure the Router now since it is not required to simply use MySQL. But, I will show you how to configure Server. So, in the below dialog box, click on Next.Step 7: In the below wizard, you can either choose the Standalone MySQL Replication or the InnoDB Cluster based on your requirement. Here I will choose, Standalone MySQL Cluster and then click on Next.Step 8: Once, you click on Next, you have to mention the server configuration. So, I will leave it as it is and then click on Next.Step 9: Now, you have to choose the authentication method. Here, I will choose the first option and click on Next. Refer below.Step 10: Next, you have to mention the MySQL Root Password and again click on Next.NOTE: Ple ase make a note of this password.Step 11: Finally, you have to choose whether you want to start the server or not. Here, I am going to leave it as it is. Then, click on Next.Now, the wizard will give you a list of the configurations which will be applied. So, if you agree with the configuration click on Execute.Once the execution is done, click on Finish. This will finish the configuration of Server.Step 12: In the next wizard that comes up, you can choose to configure the Router. So just click on Next and click on Finish.Step 13: Once, you click on Finish, you will see the following wizard, to Connect to server. Here mention the root password, which you had set in the previous steps. Refer below.Check if the connection is successful, by clicking on the Check button and then click on Execute. Now, once the configuration is complete click on Next.Step 14: Once, you click on Next, choose the configurations applied and click on Execute.After the configurations get applied, you will see the following screen. So, here just click on Finish. Refer below.Check Whether MySQL Is Installed Or NotStep 15: Now, to check whether MySQL is installed or not, you can open the MySQL Shell and mention the root password.The above output indicates that MySQL has been installed in your system. Now, that you know how to install MySQL if you wish to know about the GUI of MySQL, you can refer to my article on MySQL Workbench.If you wish to learn more about MySQL and get to knowthis open source relational database, then check out ourMySQL DBA Certification Trainingwhichcomes with instructor-led live training and real-life project experience.This training will help you understand MySQL in depth and help you achieve mastery over the subject.Got a question for us? Please mention it in the comments section of How To Install MySQL? and I will get back to you.Recommended videos for you Introduction to MongoDB Watch Now Build Application With MongoDB Watch NowRecommended blogs for you Top 30 S QL Query Interview Questions You Must Practice In 2019 Read Article SQL Commands A Beginners Guide To SQL Read Article Development and Production of MongoDB Read Article SQL Tutorial : One Stop Solution to Learn SQL Read Article How To Rename a Column Name in SQL? Read Article How to use Auto Increment in SQL? Read Article MongoDB Vs Cassandra Read Article INSERT Query SQL All You Need to Know about the INSERT statement Read Article PostgreSQL Tutorial For Beginners â€" All You Need To Know About PostgreSQL Read Article How to retrieve a set of characters using SUBSTRING in SQL? Read Article SQL Pivot â€" Know how to convert rows to columns Read Article Top 50 DBMS Interview Questions You Need to know Read Article Learn How To Use CASE Statement In SQL Read Article What are basic MongoDB commands and how to use them? Read Article DBMS Tutorial : A Complete Crash Course on DBMS Read Article PL/SQL Tutorial : Everything You Need To Know About PL/SQL Read Article SSIS Tutorial For Be ginners: Why, What and How? Read Article What is DBMS? A Comprehensive Guide to Database Management Systems Read Article Understanding SQL Joins â€" All You Need To Know About SQL Joins Read Article SQLite Tutorial: Everything You Need To Know Read Article Comments 0 Comments Trending Courses in Databases SQL Essentials Training Certification6k Enrolled LearnersWeekend/WeekdaySelf Paced Reviews 5 (2400)