DigitalOcean Kubernetes: new control plane is faster and free, enable HA for 99.95% uptime SLA

Related

MySQL "describe/explain/show columns from" Problem on Fedora: "ERROR 1 (HY000): Can't create/write to file"
Question
How to set up my cloud/vps server using Ubuntu 12.04 LTS, Apache, MSQL, Phpmyadmin, PHP
Question

Question

Need help to solve Mysql Reset Password

  • Posted March 18, 2016
  • MySQL

Hi Friends,

I have installed MYSQL 5.7 centos 7

I have restore my old MYSQL.DB from version 5.5.46 to MYSQL 5.7 Now I am not able to login or even not able to reset password.

Getting Below error.

[root@database ~]# mysqld_safe --skip-grant-tables & [1] 18417 [root@database ~]# -bash: mysqld_safe: command not found

Please help to solve this error. Thanks Ranjeet Ranjan

Subscribe
Share
keyone • March 19, 2016

Visit http://keyonelab.weebly.com/phpmyadmin--mysql-on-centos-7-installation.html see E: phpMyAdmin : reset mysql password

olavamjelde • March 19, 2016

Hello, check out this tutorial: http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html

Scroll down to unix

keyone • March 19, 2016

This comment has been deleted

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Rajkishore J • October 21, 2021

Hi,

The below documentation can guide you with resetting the MySQL root password :

https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password-on-ubuntu-20-04

Regards, Rajkishore

keyone • March 19, 2016

This comment has been deleted

Join the DigitalOcean CommunityCommunity

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner

Related

MySQL "describe/explain/show columns from" Problem on Fedora: "ERROR 1 (HY000): Can't create/write to file"
Question
How to set up my cloud/vps server using Ubuntu 12.04 LTS, Apache, MSQL, Phpmyadmin, PHP
Question

Try DigitalOcean for free

Click below to sign up and get $100 of credit to try our products over 60 days!

Sign up