need help with install problem

some hosts reset servers daily at like 9 a.m. and that will be when changes take effect. Post back if problem not fixed.

I’m back again no joy with my ISP and they have updated their servers!

Here is the full story, only domain name and password changed. I’m attempting to install my WordPress Blog in a subdirectory called ‘news’ on my website https://www.mydomain.com the site is hosted by f2s. The sites login name is [email protected] and the password is ‘password.’ The password for the blog is passwordtwo.

The WordPress files were uploaded using Dreamweaver MX

Here is where I am at the moment. I’ve uploaded my blog into the subdirectory ‘news’ and this is the working part of my wp-config file:

<?php
// ** MySQL settings ** //
define('DB_NAME', 'db-f2s');    // The name of the database
define('DB_USER', 'abcdef_210081_1');     // Your MySQL username
define('DB_PASSWORD', 'password'); // ...and password
define('DB_HOST', 'db-f2s');    // 99% chance you won't need to change this value
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');

?>

I’ve checked the above with f2s and they say it is correct.

When I go to https://www.mydomain.com/news/wp-admin/install.php and select enter I get the following message error from 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 db-f2s database.
? Are you sure it exists?
? Does the user uworldw_210081_1 have permission to use the db-f2s database?
? 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?’

When I rang the ISP helpline the guy on the phone told me that he wasn’t really up on databases and suggested I submit a ticket to customer support (appoligized that the database guy was off today – he did help sort another problem) he told me that the database define(‘DB_NAME’, ‘db-f2s’); // is a gernic name. Could that be what is wrong.

I can access the database admin area through ‘database tools’ in my members area using the following ‘abcdef_210081_1’ and password

One final bit of information. This particular site hosted a blog on its own some months back in the main root directory but from what I can see everything is clean

Hope someone can suggest what might be wrong.

Kevin

I’ve been doing a bit of Googling and came across this suggestion: ‘move (not copy) the index.php file from the main folder of the WordPress install to the root of your website and open up it in a text editor and change line four from
<?php
/* Short and sweet */
define(‘WP_USE_THEMES’, true);
require(‘./wp-blog-header.php’);
?>

to

<?php
/* Short and sweet */
define(‘WP_USE_THEMES’, true);
require(‘./news/wp-blog-header.php’);
?>

or whatever your sub-directory name is: I’ve tried it went back to
https://www.mydomain.com/news/wp-admin/install.php but still get the same error message. Is this right? I’ve moved the file back into its original place until I find out a little more.

Kevin

Is it coincidence that your DB_NAME and DB_HOST are the same value.

Please see if your host can confirm DB_NAME, DB_USER, DB_PASSWORD, and DB_HOST if necesaary.

Almost always, a database connection problem means something’s wrong in wp-config.php or something wrong with the database server.