Installing and Configuration of MySQL Standalone Server | Relational Database Management System

-

 In this post I'm going to discuss how you can start working with relational databases in your own system practically. Database Management System is really a very important subject in terms of GATE,University exams, placement, jobs,etc. So, It is better to have practical knowledge of databases with SQL.

SQL stands for Structure Query Language , I have already discussed about SQL in one of my post. So, MySQL is a DBMS, to work with database and we are going to discuss about it.



Installing MySQL

1. Go to Download MySQL Installer . This link is for window users, other users can download it's latest release from www.dev.mysql.com.




2. Double click on downloaded setup, it will start installer . It will take only 3 minutes to download MySQL.Please make sure that you must have a good internet connection.





3. Select a setup type as seen in  image. You can choose as per your need but I would suggest that you should select Full because it contains all products needed for development including documentation. then , click on next.


4. This step list all products requirements. There is nothing you have to do if all requirements are satisfied by your system. If they are not available then simply click on  execute, it will install it for you. now, simply click next.




5. Now click execute in order to install all packages. This step will take some time to install these different tools/packages.



6. Downloading /Installing



7. In this step you have to configure your products as shown below in the image. You need to configure every product.



8. I will show configuration of MySQL Server and other configurations can be done by following instructions.


Configuring MySQL Server


1. Click on MySQL Server then press Next. Below given box appears. Now select Standalone MySQL Server and press Next.




2. Now configure Type and Networking as shown below and press Next.


3. Select authentication method as selected below and Click on Next.




4. Enter root password as per your choice and select roles or add users as done below. Click on Next.



5. Do as I did in below image then click on Next.

6. Change logging options as done below. Click on Next.


7. Enter following advanced options and Click on Next.



8. Click on Execute to apply configuration.



9. MySQL Server Configurations is completed! Click on Next.




Congratulations !!! You have successfully Installed MySQL.



Click Finish to finally complete your installation.


You get a MySQL terminal on installation from where you can write queries and get started working with DBMS.


It will be similar to following image- 




You can write your SQL Queries in this terminal and retrieve results. To know different SQL Commands you can view my previous blog on Structured Query Language


Comment down your doubts😋😋


                             THANK YOU!








Comments

Post a Comment

Popular posts from this blog

Coding tips for Developers

-
## Mastering Coding: Essential Tips for Developers In the world of software development, staying ahead requires continuous learning and improvement. Whether you're a novice programmer or a seasoned developer, refining your skills is crucial. In this blog, we'll explore essential coding tips that can elevate your development game. And don't forget to check out our YouTube channel, FTC Academy, for more in-depth tutorials and guides. ### 1. Write Readable and Maintainable Code **Clear and Consistent Naming Conventions**: Choose variable and function names that clearly describe their purpose. Consistency in naming conventions helps in understanding the code without much effort. **Comment Wisely**: Commenting on your code is crucial, but avoid over-commenting. Write comments to explain why a piece of code exists, not what it does. **Use Proper Indentation**: Proper indentation enhances the readability of the code. Follow the standard indentation practices for the language you&#
Read more

Master Data Structure & Algorithms in Python

-
Mastering Data Structures and Algorithms in Python Mastering Data Structures and Algorithms in Python Author: Vikas Welcome to our comprehensive guide on learning Data Structures and Algorithms (DSA) in Python! Whether you're a beginner or looking to brush up on your skills, this blog will provide you with a solid foundation in DSA, complete with code snippets and detailed explanations. Introduction to Data Structures and Algorithms Data Structures and Algorithms (DSA) form the backbone of computer science. They help in organizing data efficiently and solving problems quickly. Data Structures are ways to store and organize data. Examples include arrays, stacks, queues, linked lists, trees, and graphs. Algorithms are step-by-step procedures or formulas for solving problems. Examples include sorting algorithms, search algorithms, and dynamic programming. Arrays and Lists Arrays are collections of elements stored in contiguous memory locations.
Read more

How to Start with Coding: A Beginner's Guide

-
Image
Coding, the language of the digital age, has become an essential skill in today's tech-driven world. Whether you're looking to build a career in technology, develop your own applications, or simply understand how the devices around you work, learning to code is a valuable endeavor. As someone who has navigated this journey, I, Vikas, am here to guide you through the first steps of becoming a coder. ## Why Learn to Code? Before diving into the how, it's important to understand the why. Coding offers numerous benefits: 1. **Problem-Solving Skills**: Coding teaches you how to break down complex problems into manageable pieces and find solutions logically. 2. **Career Opportunities**: With the tech industry booming, coding skills can open doors to numerous job opportunities. 3. **Creativity**: Coding allows you to build and create anything you can imagine, from websites to mobile apps and more. 4. **Empowerment**: Understanding code gives you control over technology
Read more