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.
Please don’t overcomplicate.
In the “Database Host” field add “localhost: e.g. in my case “localhost:3308” solved the problem.
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.
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
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
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.
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.
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
By default
username : root
password : leave it blank
database host : localhost
table_prefix : wp_
For me, the solution was giving
wp_user
all permissions on thewp_db
database.I achieved this using the command line interpreter (CLI):
After these operations, I restarted the database:
Of course, the database name (wp_db), username (wp_user), and password of the user (pass) can be different.
my problem was that when I granted permissions to the DB user the host did not match what was in the wp_config.php
I was granting rights with
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.
For Mariadb hostname should be localhost:3306 and for MySQL localhost:3308.this fixed my error.
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.please create your database with name ‘wordpress’ before installing wordpress
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