Msgonlyone, vbinformation, HEADERExit SubEnd IfOn Error Resume NextFor each W1 in worksheets' Attempt clearance with PWord1W1. Unprotect PWord1Next W1On Error GoTo 0Shtag = FalseFor each W1 in worksheets' Checks for all clear shtag triggered to 1 if not.Shtag = Shtag Or W1. ProtectContentsNext W1If Shtag ThenFor each W1 in worksheetsWith W1If. ProtectContents ThenOn Error Resume NextDo ' Dummy do loopFor i = 66:for j = 66:for k = 66For L = 66:for m = 66:for I1 = 66For i2 = 66:for i3 = 66:for I4
. Under the new administrator open the system pre-account, open the bottom of the lock, ask the password, with the new Administrator's account password. You will see at least two accounts, a new admin account and your original account, the original account number in the point, the password-change password. You do not h
Some Windows XP system users will set up the system power-on login password for their computer to protect their privacy and to avoid the theft of important data in the computer. Usually this feature can also affect the user better use of the computer, but some XP users for a period of time did not use the computer forgot the login password, and itself does not ha
Host = ' localhost '; It's best to check the fields in the user table about the password before using the statement. Depending on the version, there are some authentication_string, some password mysql> flush Privileges;Mysql> quit;6. Restore the/etc/my.cnf file and restart Mysql:service mysql Restart, this time you can use Mysql-u root-p ' 123456 ' to enter the 7.mysql>set
Modify the MySQL configuration file my.cnf, the path is/ETC/MY.CNF
Write a line skip-grant-tables in the configuration file, save and exit after adding, as650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/79/74/wKioL1aR-HfzDOxdAAAZwP_l6kQ197.png "title=" Mysqld.png "alt=" Wkiol1ar-hfzdoxdaaazwp_l6kq197.png "/>
After the completion of the addition, restart the mysqld, after the restart is complete directly with the root user login, you can go directly into the, this time do not need
Tags: Pac authorization linu word root data start MySQL stepMySQL forgot the root of the password when the resolution steps,1:cd/etc/mysql/(go to MySQL configuration folder)2:vim my.cnf \skip-grant-tables (enter the MySQL configuration file, add the command to skip the "authorization table" in the configuration file)3:/etc/init.d/apache Restart (restart MySQL is possible)4: Command line input mysql (directl
Tags: forgot password mysqlIf one day you forget the root password, we can use--skip-grant-tables this parameter, specifically implemented as follows:[Email protected] bin]# mysql-uroot-pEnter Password:ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)[[email protected] bin]# ps-ef|grep MySQLRoot 7572 2398 0 00:58 pts/1 00:00
What is PHPCMS?
Phpcms is a website management software. The software is modular development, support a variety of classification methods, use it to facilitate the design, development and maintenance of personalized website. It supports a wide range of program combinations, easy to achieve site platform migration, and can be widely meet the needs of various scales of the site, high reliability, is a with articles, downloads, pictures, classified information, film and television, shopping m
destoon_member set password= ' Bb1aad6621657f367db7662ef7484b32 ', passsalt= ' abcd1234 ' where username= ' admin ';With the above operation, the administrator password will be set to: 123456Use password 123456 to log in to the background, modify the new management password can be.2, the site in the installation of th
Life, easy to forget the Oracle database system user password, how to do it, niche take you step by step back to Oracle, timely your password forgotten.1. Open cmd window, enter Sqlplus/as SYSDBA2, run CMD, enter the ALTER user username account unlock; (user name is the user you want to retrieve/change the password for, for example, System user)3. Alter user name
=.....# server_id = ...# socket = .....# Remove Leading # To set options mainly useful for reporting servers.# The server defaults is faster for transactions and fast selects.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2MSql_mode=no_engine_substitution,strict_trans_tables Modified MY.CNF # for advice The change settings# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html[Mysqld]#
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
DRUPAL7 founder Root forgot password solution, drupal7root
Drupal_bootstrap (Drupal_bootstrap_full) in index.php;
Require_once ' Includes/password.inc '; Echo user_hash_password (' 111111 ');d ie ();Run, get the encrypted ciphertext, and then update the Pass field of the database table users.
http://www.bkjia.com/PHPjc/948223.html www.bkjia.com true http://www.bkjia.com/PHPjc/948223.html techarticle DRUP
Forgot Mairadb's password under CENTOS7.As shownWith VI Editor or nanoCentos7 doesn't seem to have the nano installed with the yum-y install nano .Then openNano/etc/my.cnfAdd the following as shownSkip-grant-tables Save exit afterSystemctl Restart Mariadb.serviceRestart ServiceReset PasswordThen restart the login with the new passwordNote A problem may occur when you change your passwordThis time, I need to
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.