How to recovery mysql root password if you forgot it.

One of the recovery methods for a .MySQL passwordIf you forget the MySQL root password, you can use the following methods to re-set:1. Switch to rootSu root2. KILL out of the system in the MySQL process;Killall -TERM mysqld3. Start MySQL with the following command to start without checking the permissions;Safe_mysqld --skip-grant-tables &4. Then use the empty password to use the root user login to MySQL;Mysql -u root5. Modify the root user's password;Mysql> update mysql.user set authentication_string= PASSWORD ('123456') where User = 'root';Mysql> flush privileges;Mysql> quitRestart MySQL, you can use the new password login.Second, the MySQL password recovery method IIThere may be no system safe_mysqld procedures (ubuntu operating system, apt-get installed mysql), the following method can be restored1. Switch to rootSu root2. stop mysqld;
   /etc/init.d/mysql stop3. Start MySQL with the following command to start without checking the permissions;Mysqld --skip-grant-tables &4. Then use the empty password to use the root user login to MySQL;Mysql -u root4. Modify the root user password 123456 (of course, you need to 123456 into the password you want to set);Mysql> update mysql.user set authentication_string= PASSWORD ('123456') where User = 'root';Mysql> flush privileges;Mysql> quitReboot MySQL/etc/init.d/mysql restartYou can use the new password 123456 login.

Mysql have changed the column "password" to "authentication_string"

Comments

Post a Comment

Popular posts from this blog

How to fix error : no module named sendgrid when try to use sendgrid python lib in PHP.

Image
"no module named sendgrid" error reported with below codes: <?php system("/usr/bin/python sendmail.py 2>&1"); system("/usr/bin/python --version 2>&1", $ret); ?> sendmail.py import sendgrid import os from sendgrid.helpers.mail import * sg = sendgrid.SendGridAPIClient( apikey = os.environ.get( ' SENDGRID_API_KEY ' )) from_email = Email( " test@example.com " ) to_email = Email( " test@example.com " ) subject = " Sending with SendGrid is Fun " content = Content( " text/plain " , " and easy to do anywhere, even with Python " ) mail = Mail(from_email, subject, to_email, content) response = sg.client.mail.send.post( request_body = mail.get()) print (response.status_code) print (response.body) print (response.headers) ....
Read more

react-native run-android : sun.security.provider.cert path.SunCertPathBuilderException : unable to find valid certification path to req uested target

Image
F:\webrowser>react-native run-android Scanning folders for symlinks in F:\webrowser\node_modules (73ms) Starting JS server... Building and installing the app on the device (cd android && gradlew.bat install Debug)... Downloading https://services.gradle.org/distributions/gradle-4.1-all.zip Exception in thread "main" javax.net.ssl.SSLHandshakeException: sun.security.val idator.ValidatorException: PKIX path building failed: sun.security.provider.cert path.SunCertPathBuilderException: unable to find valid certification path to req uested target at sun.security.ssl.Alerts.getSSLException(Alerts.java:192) at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1959) at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:302) at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:296) at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker. java:1514) at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.jav a:216) at s
Read more

react-native run-android : do not build/update modified code(App.js)

Solution react-native bundle --platform android --dev false --entry-file index.js --bundle-output android/app/src/main/assets/index.android.bundle --assets-dest android/app/src/main/res c:\Users\lenger\Desktop\webrowser>react-native bundle --platform android --dev false --entry-file index.js --bundle-output android/app/src/main/assets/index.android.bundle --assets-dest android/app/src/main/res Scanning folders for symlinks in c:\Users\lenger\Desktop\webrowser\node_modules (43ms) Scanning folders for symlinks in c:\Users\lenger\Desktop\webrowser\node_modules (38ms) Loading dependency graph, done. bundle: start bundle: finish bundle: Writing bundle output to: android/app/src/main/assets/index.android.bundle bundle: Done writing bundle output Run react-native run-android again, you will find your modification work.
Read more