migrated Strictlyhonest.com to X10hosting - DB connection problem

Status
Not open for further replies.

strict99

New Member
Messages
36
Reaction score
0
Points
0
Hi,

I've uploaded the website (wordpress) to my add-on domain (strictlyhonest.com) and imported the database.
I've editted wp-config.php to the right details but still I get a database connection error.
I don't have a clue about what's wrong.

Thanks in advance,

greetings,
Tyrone
 

descalzo

Grim Squeaker
Community Support
Messages
9,373
Reaction score
326
Points
83
Try running the following test script with your info filled in.
Make sure the user has been added to the DB with ALL PRIVILEGES

Code:
<?php

define('DB_DATABASE', 'igor_wp2011');

define('DB_USER', 'igor_wp2011');

define('DB_PASSWORD', 'Viaduct'); 

define('DB_HOST', 'localhost');

$mysqli = new mysqli('localhost', DB_USER, DB_PASSWORD, DB_DATABASE);

if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error);
}

$q = "SHOW TABLES";

$result = $mysqli->query( $q );

while($n = $result->fetch_row(  )){

echo $n[0];
echo "\n<br />";

}

$result->free();
$mysqli->close();

 ?>
 

strict99

New Member
Messages
36
Reaction score
0
Points
0
I get this reult now:

Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user 'strict99_wp273'@'localhost' (using password: YES) in /home/strict99/public_html/strictlyhonest.com/wp-config.php on line 11
Connect Error (1045) Access denied for user 'strict99_wp273'@'localhost' (using password: YES)

---------- Post added at 07:04 PM ---------- Previous post was at 06:58 PM ----------

I get this result now:

Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user 'strict99_wp273'@'localhost' (using password: YES) in /home/strict99/public_html/strictlyhonest.com/wp-config.php on line 11
Connect Error (1045) Access denied for user 'strict99_wp273'@'localhost' (using password: YES)

I've also tried to add a new db user with all rights and changed yur test script to the new user, this was the new result:

wp_blc_filters
wp_blc_instances
wp_blc_links
wp_blc_synch
wp_bp_activity
wp_bp_activity_meta
wp_bp_friends
wp_bp_groups
wp_bp_groups_groupmeta
wp_bp_groups_members
wp_bp_messages_messages
wp_bp_messages_notices
wp_bp_messages_recipients
wp_bp_notifications
wp_bp_xprofile_data
wp_bp_xprofile_fields
wp_bp_xprofile_groups
wp_commentmeta
wp_comments
wp_gdsr_data_article
wp_gdsr_data_category
wp_gdsr_data_comment
wp_gdsr_ips
wp_gdsr_moderate
wp_gdsr_multis
wp_gdsr_multis_data
wp_gdsr_multis_trend
wp_gdsr_multis_values
wp_gdsr_templates
wp_gdsr_votes_log
wp_gdsr_votes_trend
wp_kaltura_widgets
wp_links
wp_liveshoutbox
wp_liveshoutbox_useronline
wp_liveshoutboxarchive
wp_options
wp_pollsa
wp_pollsip
wp_pollsq
wp_postmeta
wp_posts
wp_sfdefpermissions
wp_sfforums
wp_sfgroups
wp_sflinks
wp_sflog
wp_sfmembers
wp_sfmemberships
wp_sfmessages
wp_sfmeta
wp_sfnotice
wp_sfoptions
wp_sfpermissions
wp_sfpostratings
wp_sfposts
wp_sfroles
wp_sfsettings
wp_sftagmeta
wp_sftags
wp_sftopics
wp_sftrack
wp_sfusergroups
wp_sfwaiting
wp_statpress
wp_term_relationships
wp_term_taxonomy
wp_terms
wp_usermeta
wp_users
wp_yarpp_keyword_cache
wp_yarpp_related_cache

Fatal error: Call to undefined function wp() in /home/strict99/public_html/strictlyhonest.com/wp-blog-header.php on line 14

---------- Post added at 07:10 PM ---------- Previous post was at 07:04 PM ----------

yes :)

After using the original script again , but now with the NEW db user I had created, it suddenly works!!
I'm happy, many many thanks

Please check if something is prohibited here so I can fix it immediately to avoid problems.

many thanks in advance
 
Status
Not open for further replies.
Top