MySQL Issues and Resolution

1. Run MySQL Database without installation on Windows

     Here is the ZIP file that I had downloaded: mysql-8.0.30-winx64.zip

     Here are the steps to start MySQL Server (mysql-8.0.30-winx64) for the first time on Windows:
  1. Create a new folder named "data" in MySQL installation directory (i.e. in the same location as where "bin" directory is located. For me it is: C:\programs\mysql-8.0.30-winx64. This location will vary as per the location where you have extracted the MySQL zip file)
  2. From here I will use my MySQL folder location as reference. Go to: C:\programs\mysql-8.0.30-winx64\bin and execute the command: 
    mysqld --initialize-insecure
    or 
    mysqld --initialize
    depending on whether you want the server to generate a random initial password for the 'root'@'localhost' account.
  3. To start the DB, go to: C:\programs\mysql-8.0.30-winx64\bin and execute 
    mysqld --console
    You can see the start-up logs being printed.
  4. To connect to DB, go to: C:\programs\mysql-8.0.30-winx64\bin and execute 
    mysql -u root -p
    When prompted, Enter password if it has been set or else just hit "Enter" button to connect
     These steps work on Windows 10 and Windows 7.

Related Posts:


Comments

Post a Comment

Popular Posts

Elasticsearch, Logstash, Kibana Tutorial: Load MySQL Data into Elasticsearch

Image
Elasticsearch, Logstash, Kibana Tutorial: Load MySQL Data into Elasticsearch Introduction           I was searching for a tutorial online on all the elements of the "Elastic Stack" (formerly the "ELK stack") and all I found was either a tutorial on Elasticsearch only or a tutorial on Logstash only or a tutorial on Kibana only or a data migrate tutorial using Logstash and Elaticsearch. Hence I came up with this tutorial which gives a comprehensive overview of all the elements in the Elastic Stack. The use case that I am using in this post is a data load from MySQL DB into Elasticsearch using Logstash and visualizing this data using Kibana. Elasticsearch         Elasticsearch is a distributed, RESTful search and analytics engine that is based on Apache Lucene . It provides a distributed, multitenant-capable full-text search engine with an HTTP web interface and schema-free JSON documents. For more details on Elasticsearch, ...
Keep reading

REST API using Play Framework with Java

Image
REST API using Play Framework with Java Introduction           In the latest Play 2.6 release, they have decided not to support Activator. I was searching online for a basic application in the latest  Play 2.6 release . But I could not find any post or tutorial . Hence I decided to come up with this post.   In this post, we will be creating an Application using Play Framework in Java with GET, POST, PUT and DELETE APIs for CRUD operations on an Employee Entity class. To keep things simple, all data will be kept in memory in a simple map. Play as a framework does support UI as well, however in this tutorial we will be focusing only on the services part and not the UI. Play Framework                 Play Framework is built on Akka and is based on a lightweight, stateless, web-friendly architecture. Play provides predictable and minimal resource consumption (CPU, memory, threads) for highly-scalab...
Keep reading

Send Email in Java

Image
Send Email in Java Introduction         Sending an email is one of the most important and most frequently used functionalities in a technology organization. A software developer should know how this is done. This post will give you a comprehensive overview of sending emails using Java mail libraries. This post will give you an overview of the following: Send a plain text email in HTML format. Create an attachment and send an email. Use an existing file as an attachment and send an email.  As RESTful web services are commonly used today, I will be using Dropwizard for building out the email functionality as RESTful APIs. Hence here are what I will be using in this post: Java mail libraries: To connect to email service provider, compose and send emails Gmail: Email service provider Dropwizard: For developing Email functionalities as RESTful web services         Dropwizard is one of the most popular and most used frameworks ...
Keep reading