Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for solving problem of forgetting password of MySQL database administrator account in Windows

A technology for administrator accounts and forgetting passwords. It is used in electrical digital data processing, digital data authentication, instruments, etc. It can solve problems such as losses, affect development progress, and data loss, and achieve the effect of recovering huge losses and solving unnecessary troubles.

Inactive Publication Date: 2015-03-25
G CLOUD TECH
View PDF1 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] With the advent of the cloud era, big data (Big data) has also attracted more and more attention. Many data analyzes are based on big data. It can be seen that data is particularly important in today's highly developed information technology. The database is obviously the warehouse of these data; in actual work, software developers may maintain multiple databases. When a certain data management password is forgotten, if it is not handled properly, it will face two major problems: reinstalling the database or the data in the database Lost, which will seriously affect the development progress or some other greater loss

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for solving problem of forgetting password of MySQL database administrator account in Windows

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] like figure 1 Shown, the present invention closes MySQL service by closing by DOS command, enters safe mode, resets the password of administrator (root) user by command line, concrete steps are as follows:

[0019] Step 1. Enter the DOS command line window and execute: net stop mysql to close the MySQL service;

[0020] Step 2. Change the current path to enter the MySQL installation directory, for example: cd D:\Program Files\MySQL\MySQL Server 5.0\bin;

[0021] Step 3. Execute the command: mysqld-nt--skip-grant-tables to enter the MySQL security mode;

[0022] Step 4. Re-open a DOS command line window and switch to the MySQL installation directory, for example: cd D:\Program Files\MySQL\MySQL Server 5.0\bin;

[0023] Step 5. Enter the command: mysql-uroot-p to enter MySQL with an empty password, and enter the MySQL console after pressing Enter;

[0024] Step 6. Enter the SQL command to reset the root user password: update mysql.user set password=PASSWORD('admin123')...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to the technical field of software development, in particular to a method for solving the problem of forgetting the password of a MySQL database administrator account in Windows. According to the method, the MySQL service is stopped through a DOS order so as to get into the safe mode, and then the password of the administrator (root) account can be reset through a command line. By the adoption of the method, troubles caused by reinstallation of a database due to the fact that the administrator password is forgotten can be effectively avoided, and more importantly, huge losses caused by loss of original data in the database due to the fact that the administrator password is forgotten can be avoided.

Description

technical field [0001] The invention relates to the technical field of software development, in particular to a method for solving the forgotten password of the MySQL database administrator account in the Windows environment. Background technique [0002] With the advent of the cloud era, big data (Big data) has also attracted more and more attention. Many data analyzes are based on big data. It can be seen that data is particularly important in today's highly developed information technology. The database is obviously the warehouse of these data; in actual work, software developers may maintain multiple databases. When a certain data management password is forgotten, if it is not handled properly, it will face two major problems: reinstalling the database or the data in the database Lost, this will seriously affect the development progress or some other greater loss. Contents of the invention [0003] The technical problem solved by the present invention is to provide a ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F21/45
CPCG06F21/45G06F2221/2131
Inventor 齐兆勇徐震宇孙傲冰季统凯
Owner G CLOUD TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com