![]() ![]() In the field below, select delete the old one from the user tables, and click the Go button to push the changes:Īfter doing this, I was able to navigate to localhost/wordpress and enter my credentials as normal, resulting in a successful local installation of Wordpress. The old, broken user account is deleted for the sake of tidiness.įor the user account in question, change the drop down in the Host name field to Local - this will automatically set the host name to localhost: When you are ready, you can then move it onto your website, ready for all to see. This way, it is totally isolated from public exposure and all your mistakes are hidden. This is now easily solved by creating a new user account with the same permissions as the current one, while changing its host name of localhost. With the help of XAMPP, you can install WordPress directly on your computer and play with it to your heart’s content. ![]() This is because % doesn't include localhost or 127.0.0.1, as explained in this Stack Overflow answer. However, what Wordpress' documentation fails to make mention of is that the % hostname doesn't allow for local development, despite the fact that this is probably the most common way to develop with Wordpress. Here, there'll be a field called Host name with a dropdown menu and a text field:īy default this dropdown is set to Any host, and the host name itself as %. The issue was the user's Host name field.įrom the PHPMyAdmin dashboard, go to User accounts, select Edit privileges for the user that you previously created, and select the Login Information tab. What could I possibly be doing wrong here? phpMyAdmin lists my server as 127.0.0.1, but I've also tried localhost. My database name is hashim_wordpress, my user account is Hashim, and my password is definitely correct. However, this can't be the case as that user account definitely has a password set. We were able to connect to the database server (which means your username and password is okay) but not able to select the hashim_wordpress database.ĭoes the user Hashim have permission to use the hashim_wordpress database? On some systems the name of your database is prefixed with your username, so it would be like username_hashim_wordpress. I also discovered through a fluke that when I enter no password at all in the password field, I get a different, more specific error that claims my credentials are correct: Can’t select database However, when navigating to localhost/wordpress to begin the Wordpress installation and enter my credentials into the relevant fields, I get the error: Error establishing a database connection The localhost environment is working fine, and I've successfully followed the steps here to create a database and user account for Wordpress using phpMyAdmin. I'm just getting started with Wordpress, and currently using an XAMPP server to try and get a local installation working. ![]()
0 Comments
Leave a Reply. |