View Single Post
  #7  
Old 3rd November 2012, 11:06
SwOsHiE SwOsHiE is offline
HowtoForge Supporter
 
Join Date: Jun 2011
Location: Stockholm, Sweden
Posts: 82
Thanks: 8
Thanked 8 Times in 7 Posts
Send a message via Skype™ to SwOsHiE
Default

Phew.. just solved the problem, thanks falko!

What I did:

Login to MySQL:
Code:
mysql -u root -p -h 127.0.0.1
Create the root@localhost account:
Code:
use mysql;
create user root@localhost;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
commit;
FLUSH PRIVILEGES;
exit;
Restart the MySQL service to fix changes:
Code:
service mysql restart
Stop the service and start in safe mode:
Code:
service mysql stop
mysqld_safe --skip-grant-tables&
Login as root:
Code:
mysql -u root
Change password for root:
Code:
use mysql;
UPDATE user SET Password=PASSWORD('YourNewPassword') WHERE User='root';
FLUSH PRIVILEGES;
exit;
Stop the safe mode and restart the service:
Code:
service mysql stop
service mysql start
That worked for me Thanks for all the help!
Reply With Quote