MySQL pisses me off!
#2

- Stop MySQL
- Restart it manually with the skip-grant-tables option: mysqld_safe --skip-grant-tables
- Now, open a new terminal window and run the MySQL client: mysql -u root
- Reset the root password manually with this MySQL command: UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root'; If you are using MySQL 5.7 (check using mysql --version in the Terminal) then the command is:
UPDATE mysql.user SET authentication_string=PASSWORD('password') WHERE User='root';
- Flush the privileges with this MySQL command: FLUSH PRIVILEGES;
Reply


Messages In This Thread
MySQL pisses me off! - by bgedition - 11.07.2016, 21:46
Re: MySQL pisses me off! - by Naruto_Emilio - 11.07.2016, 21:50
Re: MySQL pisses me off! - by WhiteGhost - 11.07.2016, 21:57
Re: MySQL pisses me off! - by bgedition - 11.07.2016, 22:01
Re: MySQL pisses me off! - by WhiteGhost - 11.07.2016, 22:02
Re: MySQL pisses me off! - by bgedition - 11.07.2016, 22:06
Re: MySQL pisses me off! - by bgedition - 11.07.2016, 22:16
Re: MySQL pisses me off! - by Parallex - 15.07.2016, 06:15

Forum Jump:


Users browsing this thread: 1 Guest(s)