Skip to main content

Mysql logging in even without providing password [Solved]

Mysql logging in even without providing password


Setp 1

Command  SELECT User,Host FROM mysql.user;


mysql> SELECT User,Host FROM mysql.user;
+------------------+-----------+
| User             | Host      |
+------------------+-----------+
| root                        | %         |
| debian-sys-maint   | localhost |
| mysql.session        | localhost |
| mysql.sys              | localhost |
| phpmyadmin         | localhost |
| ubuntu                  | localhost |
+------------------+-----------+

Then
DROP USER 'root'@'localhost';

 FLUSH PRIVILEGES;

Comments

Post a Comment

Popular posts from this blog

How to make money from instagram

 How to make money from Instagram  As one of the most popular social media platforms, Instagram has become a hub for influencers and businesses to make money. With over 1 billion active monthly users, there’s no doubt that Instagram is a powerful tool for those looking to monetize their social media presence. If you’re wondering how to make money from Instagram, here’s a step-by-step guide on how to get started. Choose your niche: Before you start to monetize your Instagram account, you need to choose a niche that you’re passionate about. This could be anything from fashion, beauty, food, or travel. Choose a niche that you’re knowledgeable and passionate about, as it will make it easier for you to create engaging content. Create a compelling Instagram profile: Your Instagram profile should showcase who you are and what you’re all about. It’s important to have a clear and concise bio, along with high-quality profile and cover photos. Your profile should reflect your niche and ...
Post a Comment
Read more

How to make money on amazon without selling

 While selling products on Amazon is one of the most popular ways to make money on the platform, there are several other ways you can earn money without actually selling products. Here are some ideas: Amazon Affiliate Program: You can earn a commission by promoting other people's products on Amazon through the Amazon Associates program. You can create content on your blog, website or social media channels, and include links to products on Amazon. If someone clicks on the link and makes a purchase, you earn a commission. Amazon Mechanical Turk: Mechanical Turk is a platform that connects businesses and individuals who need tasks done with people who are willing to do them. The tasks can be simple like data entry, image recognition, or tagging, and you can get paid for completing them. Amazon Kindle Direct Publishing: If you enjoy writing, you can self-publish your books on Amazon through the Kindle Direct Publishing program. You can earn up to 70% royalty on your book sales. Amazo...
Post a Comment
Read more

How to make first Spring boot application with example

Set up the development environment: a. Install the latest version of Java Development Kit (JDK) b. Download and install an Integrated Development Environment (IDE) like Eclipse or IntelliJ IDEA c. Install the Spring CLI tool by following the instructions from the official Spring website. Create a new Spring Boot project using Spring CLI or using the Spring Initializer website: a. Using Spring CLI: i. Open the command line or terminal window ii. Type “spring init –dependencies=web my-first-spring-boot-app” to create a new project with web dependency b. Using Spring Initializer: i. Open the Spring Initializer website ii. Choose the required dependencies and click on Generate Project. Import the project into your IDE: a. If you used Spring CLI, import the project as a Maven project b. If you used Spring Initializer, extract the ZIP file and import it into your IDE as a Maven project. Write the code: a. Go to the main class file and add the following code: typescript Copy code import org.s...
Post a Comment
Read more