Can't select database error in WordPress localhost on WAMP Server
up vote
0
down vote
favorite
I’m following this Lynda.com tutorial (WordPress – Building Themes from Scratch Using Underscores (2017)) and haven’t gotten very far. I’ve installed a blank WordPress install on localhost using WAMP Server and I downloaded and installed the underscores theme. But for some reason when I am trying to launch the website I am getting this error:
Can’t select database
We were able to connect to the database server (which means your username and password is okay) but not able to select the lynda_under17_040518 database.
Are you sure it exists?
Does the user root have permission to use the lynda_under17_040518 database?
On some systems the name of your database is prefixed with your username, so it would be like username_lynda_under17_040518. Could that be the problem?
If you don’t know how to set up a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.
Here is what i know
- The database exists and I can run SQL commands on it in phpMyAdmin.
- My user is root
- Host is localhost
- Database is lynda_under17_040518
- root has all privileges to database (as verified in phpMyAdmin)
- Other local websites on the same WAMPServer work just fine
This Stack Overflow post says to put define( 'WP_DEBUG_LOG', true ); in wp-config.php which I’ve done. It also says:
“the debug.log file will be in wp-content.”
I don't see any debug log even though I’ve restarted all services in WAMP and refreshed the browser.
Other Links I Consulted
I reviewed the info on these pages, but they didn't really help for my situation.
- can't select database wordpress error
- Can't select database - Wordpress
- https://acloud.guru/forums/aws-certified-solutions-architect-associate/discussion/-KP4_87InltfL9P6rf-J/cant-select-database-wordpress-error
- https://chartio.com/resources/tutorials/how-to-grant-all-privileges-on-a-database-in-mysql/
- https://serverfault.com/questions/263868/how-to-know-all-the-users-that-can-access-a-database-mysql/263936
Where is my debug log and how can i get my local website running?
mysql wordpress debugging localhost wampserver
asked 2 days ago
Eric Hepperle - CodeSlayer2010
1,29962134
add a comment |
up vote
0
down vote
favorite
I’m following this Lynda.com tutorial (WordPress – Building Themes from Scratch Using Underscores (2017)) and haven’t gotten very far. I’ve installed a blank WordPress install on localhost using WAMP Server and I downloaded and installed the underscores theme. But for some reason when I am trying to launch the website I am getting this error:
Can’t select database
We were able to connect to the database server (which means your username and password is okay) but not able to select the lynda_under17_040518 database.
Are you sure it exists?
Does the user root have permission to use the lynda_under17_040518 database?
On some systems the name of your database is prefixed with your username, so it would be like username_lynda_under17_040518. Could that be the problem?
If you don’t know how to set up a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.
Here is what i know
- The database exists and I can run SQL commands on it in phpMyAdmin.
- My user is root
- Host is localhost
- Database is lynda_under17_040518
- root has all privileges to database (as verified in phpMyAdmin)
- Other local websites on the same WAMPServer work just fine
This Stack Overflow post says to put define( 'WP_DEBUG_LOG', true ); in wp-config.php which I’ve done. It also says:
“the debug.log file will be in wp-content.”
I don't see any debug log even though I’ve restarted all services in WAMP and refreshed the browser.
Other Links I Consulted
I reviewed the info on these pages, but they didn't really help for my situation.
- can't select database wordpress error
- Can't select database - Wordpress
- https://acloud.guru/forums/aws-certified-solutions-architect-associate/discussion/-KP4_87InltfL9P6rf-J/cant-select-database-wordpress-error
- https://chartio.com/resources/tutorials/how-to-grant-all-privileges-on-a-database-in-mysql/
- https://serverfault.com/questions/263868/how-to-know-all-the-users-that-can-access-a-database-mysql/263936
Where is my debug log and how can i get my local website running?
mysql wordpress debugging localhost wampserver
asked 2 days ago
Eric Hepperle - CodeSlayer2010
1,29962134
Some apps have difficulty with database names over 16 characters (yours is). If you shorten the database name, do you still get the same error?
– Michael W.
2 days ago
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I’m following this Lynda.com tutorial (WordPress – Building Themes from Scratch Using Underscores (2017)) and haven’t gotten very far. I’ve installed a blank WordPress install on localhost using WAMP Server and I downloaded and installed the underscores theme. But for some reason when I am trying to launch the website I am getting this error:
Can’t select database
We were able to connect to the database server (which means your username and password is okay) but not able to select the lynda_under17_040518 database.
Are you sure it exists?
Does the user root have permission to use the lynda_under17_040518 database?
On some systems the name of your database is prefixed with your username, so it would be like username_lynda_under17_040518. Could that be the problem?
If you don’t know how to set up a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.
Here is what i know
- The database exists and I can run SQL commands on it in phpMyAdmin.
- My user is root
- Host is localhost
- Database is lynda_under17_040518
- root has all privileges to database (as verified in phpMyAdmin)
- Other local websites on the same WAMPServer work just fine
This Stack Overflow post says to put define( 'WP_DEBUG_LOG', true ); in wp-config.php which I’ve done. It also says:
“the debug.log file will be in wp-content.”
I don't see any debug log even though I’ve restarted all services in WAMP and refreshed the browser.
Other Links I Consulted
I reviewed the info on these pages, but they didn't really help for my situation.
- can't select database wordpress error
- Can't select database - Wordpress
- https://acloud.guru/forums/aws-certified-solutions-architect-associate/discussion/-KP4_87InltfL9P6rf-J/cant-select-database-wordpress-error
- https://chartio.com/resources/tutorials/how-to-grant-all-privileges-on-a-database-in-mysql/
- https://serverfault.com/questions/263868/how-to-know-all-the-users-that-can-access-a-database-mysql/263936
Where is my debug log and how can i get my local website running?
mysql wordpress debugging localhost wampserver
asked 2 days ago
Eric Hepperle - CodeSlayer2010
1,29962134
I’m following this Lynda.com tutorial (WordPress – Building Themes from Scratch Using Underscores (2017)) and haven’t gotten very far. I’ve installed a blank WordPress install on localhost using WAMP Server and I downloaded and installed the underscores theme. But for some reason when I am trying to launch the website I am getting this error:
Can’t select database
We were able to connect to the database server (which means your username and password is okay) but not able to select the lynda_under17_040518 database.
Are you sure it exists?
Does the user root have permission to use the lynda_under17_040518 database?
On some systems the name of your database is prefixed with your username, so it would be like username_lynda_under17_040518. Could that be the problem?
If you don’t know how to set up a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.
Here is what i know
- The database exists and I can run SQL commands on it in phpMyAdmin.
- My user is root
- Host is localhost
- Database is lynda_under17_040518
- root has all privileges to database (as verified in phpMyAdmin)
- Other local websites on the same WAMPServer work just fine
This Stack Overflow post says to put define( 'WP_DEBUG_LOG', true ); in wp-config.php which I’ve done. It also says:
“the debug.log file will be in wp-content.”
I don't see any debug log even though I’ve restarted all services in WAMP and refreshed the browser.
Other Links I Consulted
I reviewed the info on these pages, but they didn't really help for my situation.
- can't select database wordpress error
- Can't select database - Wordpress
- https://acloud.guru/forums/aws-certified-solutions-architect-associate/discussion/-KP4_87InltfL9P6rf-J/cant-select-database-wordpress-error
- https://chartio.com/resources/tutorials/how-to-grant-all-privileges-on-a-database-in-mysql/
- https://serverfault.com/questions/263868/how-to-know-all-the-users-that-can-access-a-database-mysql/263936
Where is my debug log and how can i get my local website running?
mysql wordpress debugging localhost wampserver
mysql wordpress debugging localhost wampserver
asked 2 days ago
Eric Hepperle - CodeSlayer2010
1,29962134
asked 2 days ago
Eric Hepperle - CodeSlayer2010
1,29962134
asked 2 days ago
Eric Hepperle - CodeSlayer2010
1,29962134
asked 2 days ago
Eric Hepperle - CodeSlayer2010
1,29962134
asked 2 days ago
Eric Hepperle - CodeSlayer2010
1,29962134
1,29962134
Some apps have difficulty with database names over 16 characters (yours is). If you shorten the database name, do you still get the same error?
– Michael W.
2 days ago
add a comment |
Some apps have difficulty with database names over 16 characters (yours is). If you shorten the database name, do you still get the same error?
– Michael W.
2 days ago
Some apps have difficulty with database names over 16 characters (yours is). If you shorten the database name, do you still get the same error?
– Michael W.
2 days ago
Some apps have difficulty with database names over 16 characters (yours is). If you shorten the database name, do you still get the same error?
– Michael W.
2 days ago
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53402470%2fcant-select-database-error-in-wordpress-localhost-on-wamp-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Some apps have difficulty with database names over 16 characters (yours is). If you shorten the database name, do you still get the same error?
– Michael W.
2 days ago