Tags: text data 5.7 Start log reset class where stringMySQL 5.7.13 reset root password: 1.my.nin file in [mysqld] under Add skip-grant-tables 2.cmd:net start mysql-mysql-use MySQL; -update user SET Authentication_string=password (newpassword) WHERE user=root; -flush privileges; -quit; 3. LoginMySQL 5.7.13 reset root password:
1.my.nin file added "Skip-grant-tab
): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (111) [[email protected] ~]# ps-ef|grep MySQLRoot 28279 1 0 12:55? 00:00:00/bin/sh/usr/local/mysql//bin/mysqld_safe--datadir=/data/mysql/data--pid-file=/data/mysql/data/ Mysql.pidMySQL 29059 28279 0 12:55? 00:00:01/usr/local/mysql/bin/mysqld--basedir=/usr/local/mysql/--datadir=/data/mysql/data--plugin-dir=/usr/ Local/mysql//lib/plugin--user=mysql--log-error=/data/mysql/data/mysql-error.log--pid-file=/data/mysql/
directory.Or, more simply, create a new text document in the MySQL installation directory and enterCmd.exeSave, and then change the document's suffix name to a. bat batch file, double-click open to switch directly to the directory. And that's where the problem lies, and we follow this step"Enter mysqld--skip-grant-tables carriage return. If the message does not appear, then the "What is the reason for the prompt "mysqld is not an internal command or external command" after entering Mysqld--skip
Tags: permissions otherwise auth get step TPS Remove pass Grant1. Turn off the MySQL service2. Locate the MySQL installation path find my.ini open under [mysqld] add skip-grant-tables skip password check3. Login to MySQL mysql-uroot-proot (here root is the password, can also be entered freely)4. Go to MySQL to change passwordmysql> Update Mysql.user Set Authentication_string=
Tags: login multi-instance Color tab client change fill flush password loginForgot MySQL Password:(1) Suspension of service: /etc/init.d/mysqld Stop (2) Skip Grant table authorization, enter Safe mode, and run in the background: Mysqld_safe--skip-grant-tables
--skip-grant-tables--defoults-file=/data/3306 /my.cnf #多实例
jobs
[ 1]+ Running Mysqld_safe- -skip-grant-tables (3) Enter Saf
Locate the MySQL configuration file My.ini
Add Skip-grant-tables under [mysqld]
Win+r shortcut key Input cmd then enter the command net stop MySQL finally make the directory point to the bin directory in the MySQL installation directory
Input command mysqld-nt--skip-grant-tables (local test hint a waring doesn't seem to affect)
Win+r the shortcut key again enter CMD and enter the command mysql-u root return, this time should enter MySQL
Select Database user mysql;
Change
Lt; spanstyle = quot; color: rgb (0, 0, 0); font-family: Tahoma, 039; M
I haven't played LINUX for a long time. Today, my company's server is down, so I went in and checked it out. The bad thing is that I forgot the password of my company's server or LINUX. I am in trouble, what should we do? I studied it and found out how to find it one morning. The following describes how to find it in three ways:
Break
, set up an administrator user (and forget the password of the difference), and then use the new administrator login, modify the original administrator password, restart, you can use the original administrator user login.Questionnaireviewcontroller * view = [[Questionnaireviewcontroller alloc] init]; view.hidesbottombarwhenpushed = YES; View.seciondid = SectionID; View.sectionstatus = S
System: centos6.6, forget the power-on password, enter the single-user mode to reset, the following is the operation process.1. Reset (restart) The Linux system, in the appearance of the interface, please click Enter to ensure that must be fast, only for a few seconds.2. Click Enter to enter:3. Select the second item and click on the "E" key on the keyboard to enter:4. Using the kernel of the black logo in the upper and lower key selection, click on "
/0, changed state-to-down Lc/0/0/cpu0:oct 14 03 : 38:42.850:ifmgr[210]:%pkt_infra-link-3-updown:interface TENGIGE0/0/2/1, changed state to down Lc/0/0/cpu0:oct 14 03: 38:42.851:IFMGR[210]:%pkt_infra-link-3-updown:interface TENGIGE0/0/2/2, changed state-to-down lc/0/0/cpu0:oCT 03:38:42.979:ifmgr[210]:%pkt_infra-link-3-updown:interface tengige0/0/2/0, changed state to up LC/0/0/CPU0:OCT 03:38:42.984:IFMGR[210]:%pkt_infra-link-3-updown:interface TENGIGE0/0/2/1, changed state to up Lc/0/0/cpu0:oct 1
Landing Https://kyfw.12306.cn/otn/login/init website, and then we entered
Then in the login interface I "forgot username/password" Details as shown in the following figure.
And then in the password to retrieve the interface we fill in the registration time when the mailbox and verification code, click to submit.
will prompt the message, th
1. Double-click the Internet Explorer browser icon for your desktop. (other browsers can also use it)2. Enter "Http://www.live.com" in the Address bar and search.3. Click on the bottom right of "Unable to access your account."4. Select "I forgot my password" and click "Next".5. Fill in your "Microsoft account", then "enter the characters you see" and click "Next".6. Choose the way to get secure code, take "
Narrator" in the open window, which starts with the CMD window (which is opened as System identity). Naturally have Administrator rights ~), in the CMD enter the following command to open the Administrator account, restart can use the administrator:
Netuseradministrator/active:yes (Explanation: Forced open Administrator account)
Netuseradministrator123456/add (Explanation: Force the User Administrator password to 123456)
Fourth Step:
Since the Ad
Tags: date sql with user color start IV update here1, serviceMySQL stop # mysql5.1 version is mysqld, and the service name of the mysql5.6 version of the binary package is MySQL.2, /etc/init.d/mysql start--skip-grant-tables3,MySQL> Now you can change the root password in MySQL.mysql> Update mysql.user set password= password (' 123456 ') where user= ' root ';4,/
/mysqlsocket=/var/lib/mysql/mysql.sockskip-grant-tables# Disabling symbolic-links is recommended to prevent assorted security risks"/etc/my.cnf" 29L, 979C written
After saving the configuration file, restart the MySQL service.
[[emailprotected] ~]# systemctl restart mysqld.service
Log in to the MySQL database using the MySQL command.
[[emailprotected] ~]# mysql
Use the following statement to modify the root password
Tags: sock mon new warnings root password com dir match class1. Modify the MySQL login settings: Add a sentence to the paragraph in [mysqld]: Skip-grant-tablesFor example: [mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
Skip Save and exit 2, restart Mysqld # service mysqld Restart
stopping mysql: [OK]
starting mysql: [OK] 3. Log in and modify the root password of MySQL # mysql Welcome
Tags: = = Enter an open ant mysq command line interface to stop rootWindows======================net stop MySQL #先停止mysqlor stop in service management Open the Command Prompt window in the Win7 flagship PC directly, then open the Command Line window (run as Administrator) and enter the following command:c:\> mysqld--defaults-file= "C:\Program Files (x86) \mysql-5.6.24\mysql\my-default.ini"--console-- Skip-grant-tables Also open a command line window and enter the command:Mysql-u root-p #回车即可进入my
Tags: Service tor sdn Execute Connect database system restart 1.2Directory1 run the cmd window as an administrator 2 starting sqlplus and typing a series of commands 3 Special attention 1 run the cmd window as an administratorI installed the oracle11.2 version, Sqlplus.exe is located in the directory is: I:\app\Administrator\product\11.2.0\dbhome_1\BIN To start the cmd command with the administrator, and then use the CD command to go to the bin directory in the Oracle installation root, in my c
Tags: img blog net href mysq input IDT blank technology shareAfter installing Oracle 9i, incredibly changed the database administrator password to forget, and do not reinstall, too much trouble, tried for a long time, finally modified successfully.1. Run to C packing directory2. Input: SET oracle_sid = your SID name3. Input: Sqlplus/nolog4, Input: Connect/as sysdba5. Input: altre user sys identified by SYS6. Input: Altre user system identified by syst
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.