Can't select database - Wordpress

Question

When I download a new wordpress from wordpress.org and then paste it into my www folder of WAMP, then create a new database in phpmyadmin, then go to localhost and click the wordpress site, it asks to create the config file, and enter the database details, and i do that correctly, but when I click submit, it says "Can’t select database".

Any Idea why this is?

I already have a local wordpress site that started saying error connecting to database. The config settings are all correct so i tried to download a fresh wordpress site and use it and I cannot even set up a fresh one. I have never encountered a fresh wordpress site not working like this before.

I did a msqldump of my old site so that my boss could put it on his server. Not sure if that is relevant.

Cheers.

Is the wordpress database still available? Can you look at it's content without using wordpress (like using phpmyadmin)? — Simon, Jul 17 '14 at 11:49

score 12 · Answer 1 · answered May 14 '20 at 14:15

12

Please don't overcomplicate.

In the "Database Host" field add "localhost: e.g. in my case "localhost:3308" solved the problem.

answered May 14 '20 at 14:15

Rajwant

121
1
2

score 4 · Answer 2 · answered May 03 '17 at 13:22

For anyone who's still looking for solutions to this problem - please, check again your wp-config.php database credentials again. I had the same problem today and tried to over-complicate the matter by searching for advanced solutions, while I had a space in my DB_NAME field (was supposed to be 'wpdb' and was ' wpdb').

This space completely messed up my connection, I was even close to reinstalling the whole thing and losing all data.

score 2 · Answer 3 · answered Sep 27 '17 at 15:31

2

If using LAMP -

Make sure that all privileges are granted for that database to the created mysql user. Under your MYSQL shell use the below

GRANT ALL PRIVILEGES ON database_name.* TO database_user@localhost IDENTIFIED BY 'user_password';

Where,

database_name = your database name as per wp-config.php

database_user = your user name as per wp-config.php

userpassword = your user password as per wp-config.php

answered Sep 27 '17 at 15:31

Aakash

21
1

`ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'user_password'' at line 1` – Flair Nov 19 '18 at 21:59
That one liner is described as deprecated: https://stackoverflow.com/questions/31111847/identified-by-password-in-mysql – Flair Nov 19 '18 at 22:19

score 1 · Answer 4 · answered Aug 04 '18 at 14:42

1

By default

username : root

password : leave it blank

database host : localhost

table_prefix : wp_

answered Aug 04 '18 at 14:42

Shubham Agrawal

1,252
12
29

score 1 · Answer 5 · answered Mar 02 '20 at 18:53

1

please create your database with name 'wordpress' before installing wordpress

answered Mar 02 '20 at 18:53

Abdul Samad Nizamani

93
2
4

XIMRX · Answer 6 · 2014-07-17T11:20:14.613

0

It sounds like either you have not created a database or your wp-config file is not set up correctly. Have you edited wp-config.php file of wordpress and provided correct database name and user credentials. See Famous 5 minute installation of wordpress for details.

edited Jul 17 '14 at 11:20

answered Jul 17 '14 at 11:15

XIMRX

2,130
3
29
60

Yes thanks. On the last step of that installation (going to the url) it says "Error establishing a database connection". Is it connected to me cancelling my subscription? – user3164083 Jul 17 '14 at 11:21
1

Can you show your wp-config.php file code. (removing password) – XIMRX Jul 17 '14 at 11:24
First make sure database name is `the_commons`. Secondly root by default has empty password so make sure in wp-config.php your password is set like: `define('DB_PASSWORD', '');` – XIMRX Jul 17 '14 at 11:29
Just discovered that none of my databases work on any of my web sites any more. I have WAMP all services running including mysql – user3164083 Jul 17 '14 at 11:37
Before messing with databases create new user with all privileges and use it. – XIMRX Jul 17 '14 at 11:51
Have you recently installed something that comes with its own MySQL. In other words are you running two MySQL Server? – RiggsFolly Jul 17 '14 at 12:26

score 0 · Answer 7 · answered Jul 17 '14 at 12:50

0

It took me way too long to discover that my msql databases were not working on any other websites either. I reinstalled Wamp Server and it worked.

answered Jul 17 '14 at 12:50

user3164083

1,053
6
18
35

Daniel · Answer 8 · 2017-01-20T07:56:23.200

0

Verify the wp-config.php file. I had the same error and the problem was related with the quotes: ‘root’ vs 'root'

edit: the correct one is single quote

edited Jan 20 '17 at 07:56

answered Jan 14 '17 at 12:46

Daniel

1
3

score 0 · Answer 9 · answered Feb 02 '19 at 18:39

For me, the solution was giving wp_user all permissions on the wp_db database.

I achieved this using the command line interpreter (CLI):

$ mysql -uroot -p
MariaDB [(none)]> GRANT ALL ON `wp_db`.* TO `wp_user`@`localhost` IDENTIFIED BY 'pass';
MariaDB [(none)]> exit;

After these operations, I restarted the database:

$ systemctl restart mysql

Of course, the database name (wp_db), username (wp_user), and password of the user (pass) can be different.

score 0 · Answer 10 · answered Apr 23 '19 at 18:23

my problem was that when I granted permissions to the DB user the host did not match what was in the wp_config.php

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

I was granting rights with

GRANT ALL ON databaseName.* TO 'UserName'@'127.0.0.1';

This gave me access when I was connected to the local host through ssh but It did not match wp_config.php. so I had to Grant like this then it all worked.

GRANT ALL ON databaseName.* TO 'UserName'@'localhost';

For MariaDB yes it's 3306 and 3308 for MySQL. – Ususipse May 30 '20 at 21:57 — Ususipse, May 30 '20 at 21:57

score 0 · Answer 11 · answered Dec 14 '19 at 06:51

0

For Mariadb hostname should be localhost:3306 and for MySQL localhost:3308.this fixed my error.

answered Dec 14 '19 at 06:51

Ankita Shinde

11
1

score 0 · Answer 12 · edited Dec 15 '19 at 12:09

0

I had this issue when trying to transfer databases between WAMP server installations.

I tried opening PhpMyAdmin on new PC, then got the port of MySql server (:3308) and added this port into DB_HOST ('localhost:3308'). This worked for me.

edited Dec 15 '19 at 12:09

Avinash Dalvi

8,551
7
27
53

answered Dec 14 '19 at 17:35

Piotr Kucułyma

31
5

score 0 · Answer 13 · edited Aug 01 '21 at 16:28

0

You may need to create the database yourself. Visit http://localhost:8888/phpMyAdmin5 create a new database with the name you prefer. Don't add any table names, just use the name you choose for the database in the WordPress setup

edited Aug 01 '21 at 16:28

Libu Mathew

2,976
23
30

answered Jul 31 '21 at 12:15

Omar Embaby

1

score 0 · Answer 14 · answered Jun 13 '23 at 02:37

0

If anyone is still having this problem. The form fields auto-populate with placeholders. You have to type over the placeholder information to enter the data. Took me over an hour to figure this out.

answered Jun 13 '23 at 02:37

Angela Carter

1

score 0 · Answer 15 · answered Aug 18 '23 at 18:17

After doing an Acronis profile restore I encountered this same issue and I spent a long time trying to figure out what the issue could be I found that even though my user was appearing in the list of users it did not have any privileges set up.

I was able to check the privileges by going into phpMyAdmin and checking privileges on the db.

I was using cPanel and so I did the following:

Under the databases header I selected 'MySQL Databases'
Then scroll down to the heading 'Add User To Database'
Select the user that is in your wp-config file
Click 'Add User'
Give them the SELECT Privilege
Click 'Add/Edit User'

This does not provide an answer to the question. Once you have sufficient [reputation](https://stackoverflow.com/help/whats-reputation) you will be able to [comment on any post](https://stackoverflow.com/help/privileges/comment); instead, [provide answers that don't require clarification from the asker](https://meta.stackexchange.com/questions/214173/why-do-i-need-50-reputation-to-comment-what-can-i-do-instead). - [From Review](/review/late-answers/34863958) — Joe Niland, Aug 22 '23 at 10:46

Can't select database - Wordpress

15 Answers15

Linked