Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

PHP

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

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

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

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.