phpMyAdmin Error DANG!

[Heroid]

When I made a new database in phpMyAdmin, I was logged into root, Then I named it but didn't import my database yet so it was empty, Then I opened the SQL box thing and added "DROP USER 'pma'@'localhost';" clicked ok... "Are you sure you want to drop user pma?" "Yes." ~Click~ Then I been logged out immidiately and then I tried to login again with "root" and my password as ussual... But then the error came:

Error
#1045 - Access denied for user 'pma'@'localhost' (using password: NO)

So what the fuck should I do? Please help rly fast plix, Rep++ ofc ^^)...

 

[Slain]

mysql>UPDATE mysql.user
->SET Password=PASSWORD("*******")
->WHERE User="root";
mysql>FLUSH PRIVILEGES;

the stars are the password you need to type in.

 

[Heroid]

More explained please... I've never seen that text lmfao ... Where can I find it and what do I do then?! ;o

 

[RealSoft]

you need to restart MySQL server to reload the users.

 

[Heroid]

And how do I do that?! o,O...

 

[RealSoft]

if you're using Xampp control panel:
Click "MySQL Stop" wait 10 seconds, and then click "MySQL start".

If you use Xampp_Start.exe:
Run "Xampp_Stop.exe" and wait 10 seconds and the run "Xampp_Start.exe"

 

[Heroid]

Got maybe... Teamviewer, Something is fucking with me x]... PM

 

[Heroid]

K. This dosent work for me. What should i do? Maybe as Slain said? ;o

 

[Heroid]

I STILL DON'T KNOW WHAT I SHOULD DO GUYS... PLEASE HELP ME!... [And don't make it to advanced lmfao]...

I also added a Picture @ UP, And that's what happens when I try to login to root.

 

[RoHaN-OTs]

Just use navicat instead.

 

[Havocbringer]

just goto 127.0.0.1/phpmyadmin In your Web Browser at the top =) Or check your security and make sure in xampp , apache and mysql running

 

[Heroid]

Guys... This is solved... BY ZNOTE! He told me to delete everything with XAMPP and use Uniform Server instead, I did as he said, And now it works AWESOME again! I would recommend everyone to follow Znotes tutorial! http://otland.net/f479/nothing-full...niform-server-forgotten-server-0-3-6-a-77593/

It's safer and everything, Thanks Znote.