Trouble logging into Wordpress wp-config

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Trouble logging into Wordpress wp-config

Postby woodcycl » 13. October 2011 01:54

###### ApacheFriends XAMPP version 1.7.7 ######
+ Apache 2.2.21
+ MySQL 5.5.16 (Community Server)
+ PHP 5.3.8 (VC9 X86 32bit thread safe) + PEAR
WinXP Pro SP3

Being new to xampp and somewhat new to Wordpress, I'm having trouble logging in to Wordpress. Here's my setup ...

wp-config.php
Code: Select all
// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'bhp_wordpress');

/** MySQL database username */
define('DB_USER', 'wordpress');

/** MySQL database password */
define('DB_PASSWORD', '');

/** MySQL hostname */
define('DB_HOST', 'localhost');

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');


Folder name for wordpress on xammp
Code: Select all
C:\xampp\htdocs\wordpress


DB User at Home Level
Image

DB User at wordpress db Level

Image

URL I'm using to login to xampp's installed wordpress
Code: Select all
http://localhost/wordpress/wp-login/


Here's what I get when going to http://localhost/wordpress/wp-admin/ and logging in with user=wordpress and password=''
Image

Any help is appreciated!

Thanks,
Brian
woodcycl
 
Posts: 17
Joined: 10. October 2011 19:08
Location: Southern Indiana
Operating System: WinXP Pro SP3

Re: Trouble logging into Wordpress wp-config

Postby Sharley » 13. October 2011 02:09

Brian, you need to add a password for user wordpress in phpMyAdmin.

Click on the user in the Privileges tab.

Try and follow this click path:
Privileges>User>wordpress>Edit Privileges>Global Privileges>uncheck all>Database privileges>Select bhp_wordpress>select all>Change password>Password>add your password>Re-type>add password>GO

Enter the password you created above in your wp-config.php - try again.

Good luck. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Trouble logging into Wordpress wp-config

Postby woodcycl » 13. October 2011 02:21

Thanks Sharley,

I had my password as blank in my wp-config.php. But, just in case there is a problem with blank passwords, I set it to 1234.

I then followed your steps as best I understood and set the password to 12334 in phpmyadmin for user=wordpress.

Now, when I go to http://localhost/wordpress/wp-admin/, I get the following error
Image

Thoughts?
woodcycl
 
Posts: 17
Joined: 10. October 2011 19:08
Location: Southern Indiana
Operating System: WinXP Pro SP3

Re: Trouble logging into Wordpress wp-config

Postby Sharley » 13. October 2011 02:29

Brian, I think the error message says it all, don't you? :shock:

woodcycl wrote:...I set it to 1234.
Is this the problem?
woodcycl wrote:...and set the password to 12334 in phpmyadmin for user=wordpress.

Make sure MySQL is running in CP3.

Please check and double check every setting and if you still have problems then search the WP forums and post this issue there.

woodcycl wrote:Now, when I go to http://localhost/wordpress/wp-admin/, I get the following error
BTW, you don't log in to WP admin using the database user/pass but rather the user/pass set for the admin user.

Good luck. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Trouble logging into Wordpress wp-config

Postby Altrea » 13. October 2011 05:27

Hi Brian,
woodcycl wrote:DB User at Home Level
Image


A little bit tricky:
Host localhost or 127.0.0.1 is NOT included with the wildcard %.
Create another MySQL wordpress user for localhost or change the existing MySQL wordpress users host if you just need to use it with your local host.


[Edit] technically it is a little bit different.
MySQL serves authentification by precision. The more precise a login account is the more priority it has.

Example:
user@192.168.2.5 is very precise. No wildcards.
%@192.168.2.5 one wildcard for user.
user@% minor priority than the wildcard for user

By Default MySQL creates an anonymous account for localhost, so this anonymous account does have a higher priority than any on the % Wildcard accounts which comes from localhost

for further reading: http://dev.mysql.com/doc/refman/5.5/en/ ... users.html
MySQL Manual wrote:It is necessary to have both accounts for monty to be able to connect from anywhere as monty. Without the localhost account, the anonymous-user account for localhost that is created by mysql_install_db would take precedence when monty connects from the local host. As a result, monty would be treated as an anonymous user. The reason for this is that the anonymous-user account has a more specific Host column value than the 'monty'@'%' account and thus comes earlier in the user table sort order. (user table sorting is discussed in Section 5.4.4, “Access Control, Stage 1: Connection Verification”.)
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Trouble logging into Wordpress wp-config

Postby Sharley » 13. October 2011 05:56

Ah, didn't get those phpMyAdmin screen caps in the OP's first post, either the they were added later to the server or the image server was down when I read the post - only the error message in the second post was displayed hence my reply - now the problem is much clearer.

Note
One image is too big and should conform with the forum How To Post instructions max 800x600 and so Brian please resize the oversized image on your server - 600x400 preferred.
Thanks.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Trouble logging into Wordpress wp-config

Postby woodcycl » 13. October 2011 22:17

Thanks Altrea. I have reset user=wordpress with Host=localhost, YES to password (1234) and Global Privileges to All Privileges. Then, I confirmed that All Privileges are set for my database specific privileges. See screenshots below. The wordpress admin login now comes up, but will not take the credentials: wordpress / 1234. I receive the "Error, Invalid username" message. But, you can see my setup below ... both in wp-config as well as phpmyadmin ... my username is: wordpress

Funny thing is ... this all worked when I first set it up. The next day, it stopped working. Not sure what the difference was though.

Thoughts?

Image

Image

Image
woodcycl
 
Posts: 17
Joined: 10. October 2011 19:08
Location: Southern Indiana
Operating System: WinXP Pro SP3

Re: Trouble logging into Wordpress wp-config

Postby Altrea » 14. October 2011 00:07

woodcycl wrote:The wordpress admin login now comes up, but will not take the credentials: wordpress / 1234. I receive the "Error, Invalid username" message.


Sure! MySQL User for wordpress Database is not the same thing as Wordpress backend user!!!
That are two absolute diferent authentification methods. MySQL database user is needed to access the database generally. Without this nothing work.
The Backend Users are defined inside one of the wordpress database tables.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Trouble logging into Wordpress wp-config

Postby woodcycl » 14. October 2011 01:10

Thanks Altrea -- gotcha. I'll lookup the default login and try that. When installing on a shared server, all this is done for you behind the scenes ... learning the long way trying it locally via xampp and mysql.
woodcycl
 
Posts: 17
Joined: 10. October 2011 19:08
Location: Southern Indiana
Operating System: WinXP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 63 guests