Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial


phpmyadmin complete reset?

Is there a way to completely reset phpmyadmin on a local host?

I'm not sure what I have done - but it will not allow me to create any new databases.I think its because I deleted all users from some old Wordpress installs and wanted to remove them with their users but now there is no 'root' user?

it gives me the following error when trying to create a new database :

#1044 - Access denied for user ''@'localhost' to database 'wordpress1'

Hoping there is an easy fix


4 Answers

Michael Austin
Michael Austin
Courses Plus Student 7,814 Points


  • How are you logging into PhpMyAdmin? Are you logging into PhpMyAdmin directly or going in via a control panel such as cPanel/Plesk?
  • Do you have SSH access to the server/a windows login to the server?


I'm logging in to it using WAMP on localhost so no cpanel. i've restared the wamp server and now it doesn't log in at all giving this error -

#2002 - No connection could be made because the target machine actively refused it.

Michael Austin
Michael Austin
Courses Plus Student 7,814 Points

As trivial as it sounds, try a reboot for the second error. If this doesn’t solve the second error, have a look in the log folder in the WAMP directory for mysql. Then do a search for the specific errors it lists.

Typically the Phpmyadmin root login for WAMP is user: root pass: (empty). If still no luck, you’ll need to login to mysql itself. For windows: http://bmehla.wordpress.com/2011/04/30/run-mysql-command-line-with-wamp/, for macOs: http://blog-en.mamp.info/2009/08/using-mysql-command-line-with-mamp.html

Still didn't work after restarting it - I've managed to completely uninstall wamp and reinstall it and it now works.

Thank you for your help anyway.