Turn Your Vehicle Into a Smart Earning Asset

While you’re not driving your car or bike, it can still be working for you. MOTOSHARE helps you earn passive income by connecting your vehicle with trusted renters in your city.

🚗 You set the rental price
🔐 Secure bookings with verified renters
📍 Track your vehicle with GPS integration
💰 Start earning within 48 hours

Join as a Partner Today

It’s simple, safe, and rewarding. Your vehicle. Your rules. Your earnings.

How to Reset or Recover Forgotten mySql root Password

Recover Forgotten mySql root Password in Linux

  • Step 1 – Locate my.ini or my.cnf in mysql server.
  • Step 2 – Edit my.ini or my.cnf and insert ‘skip-grant-tables’ below [mysqld]
  • Step 3 – Restart MySQL
  • Step 4 – Set new password for your root user by running
$ mysql -u root
mysql> UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root';
mysql> UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE USER='root' AND Host='localhost';


in phpMyAdmin in the mysql database (or just leave it like this if MySQL cannot be accessed from remote hosts)Code language: JavaScript (javascript)
  • Step 5 – Remove the skip-grant-tables in the my.ini or my.cnf file
  • Step 6 – Restart MySQL

Resetting MySQL Root Password with XAMPP on Localhost

How to change a mysql user password?

$ mysql -u root -p
mysql> use mysql;

- The syntax is as follows for mysql database server version 5.7.5 or older:
mysql> SET PASSWORD FOR 'user-name-here'@'hostname' = PASSWORD('new-password');

- For mysql database server version 5.7.6 or newer use the following syntax:
mysql> ALTER USER 'user'@'hostname' IDENTIFIED BY 'newPass';

- You can also use the following sql syntax:
mysql> UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE USER='user-name-here' AND Host='host-name-here';

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'sjh643#22SLKhaA2%';
mysql> FLUSH PRIVILEGES;
Code language: JavaScript (javascript)

Subscribe
Notify of
guest
0 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments

Certification Courses

DevOpsSchool has introduced a series of professional certification courses designed to enhance your skills and expertise in cutting-edge technologies and methodologies. Whether you are aiming to excel in development, security, or operations, these certifications provide a comprehensive learning experience. Explore the following programs:

DevOps Certification, SRE Certification, and DevSecOps Certification by DevOpsSchool

Explore our DevOps Certification, SRE Certification, and DevSecOps Certification programs at DevOpsSchool. Gain the expertise needed to excel in your career with hands-on training and globally recognized certifications.

0
Would love your thoughts, please comment.x
()
x