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

PHP

Posted by garrycohen
garrycohen
13,914 Points

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

Cheers

4 Answers

Michael Austin
PLUS
Michael Austin
Courses Plus Student 7,814 Points
Michael Austin
Michael Austin
Courses Plus Student 7,814 Points

Hi,

  • 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?

Thanks

garrycohen
garrycohen
13,914 Points
garrycohen
garrycohen
13,914 Points

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
PLUS
Michael Austin
Courses Plus Student 7,814 Points
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

garrycohen
garrycohen
13,914 Points
garrycohen
garrycohen
13,914 Points

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.