sammymocha

I just went through this yesterday. Make a screen shots of your database setup page (database name, user, etc) and your config file. Compare the two and make sure the names are identical. Also be sure you hit “submit” button on the database setup page when you add a user. Anne

WAHOOOOOO!! Thanks so much!!

truckeed_blog not working either – here is new 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 truckeed_blog database.

* Are you sure it exists?
* On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem?

If you don’t know how to setup a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.

Here is a screenshot of the bluehost sql setup page:

https://truckeedonnerphotos.com/Picture%203.png

It’s not finding the database name. I have tried truckeed_blog, blog, anne_blog, no avail. Here is error:

WordPress

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 blog database.

* Are you sure it exists?
* On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem?

If you don’t know how to setup a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.

Yup, I printed out and read all topics. You are correct, this should be a piece of cake. All I’m doing is changing the config file and running install. So.. it will find the database by the name in the config file alone, doesn’t need any path.

Ran install.php and same error – can’t find DB. Have checked config file over and over and it appears fine. This must be something really dumb since there are only 3 pieces of text to change in config. Below is config file. I tried my DB_NAME as “truckeed_blog” as well as “blog”. Tried DB_USER as “truckeed_anne” as well as “anne”. Config and install files are in right places.

Any more steps I can take to troubleshoot? Thanks again!!

<?php

// ** MySQL settings ** //

define(‘DB_NAME’, ‘truckeed_blog’); // The name of the database

define(‘DB_USER’, ‘truckeed_anne’); // Your MySQL username

define(‘sam123’, ‘yourpasswordhere’); // …and password

define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

define(‘DB_CHARSET’, ‘utf8’);

define(‘DB_COLLATE’, ”);

// You can have multiple installations in one database if you give each a unique prefix

$table_prefix = ‘wp_’; // Only numbers, letters, and underscores please!

// Change this to localize WordPress. A corresponding MO file for the

// chosen language must be installed to wp-content/languages.

// For example, install de.mo to wp-content/languages and set WPLANG to ‘de’

// to enable German language support.

define (‘WPLANG’, ”);

/* That’s all, stop editing! Happy blogging. */

define(‘ABSPATH’, dirname(__FILE__).’/’);

require_once(ABSPATH.’wp-settings.php’);

?>

I’m used to seeing databases as files like .dbf or .mdb which reside in some directory somewhere and I can type in the path to. You know, with tables you can query. So this concept is new to me. How do you define it then?

My host, BlueHost, allows me to create a sql database and name it and add users, but does not give the sql server name. Any idea where to get that? I am sure this is super easy and I’m not getting it! Thanks for your help!

I have a screen shot of what I’m seeing with the database setup. Can I attach it to this post? Thanks again..

Anne