error establishing database connection (WAMP + filezilla)

If everything is normal ( i.e., web server is working, ) you should care for only following things when creating new wordpress site. define(‘DB_NAME’, ‘db_name’); /** MySQL database username */ define(‘DB_USER’, ‘user_name’); /** MySQL database password */ define(‘DB_PASSWORD’, ‘db_password’); /** MySQL hostname */ define(‘DB_HOST’, ‘localhost’); db_name : name of the database that will hold your … Read more

WP website showing blank page after moving from subdomain to main domain

you need to see below post to move word-press site one server to other Ref :- WordPress link some simple steps follow and change site location you can update your database using following queries UPDATE wp_options SET option_value = replace(option_value, ‘https://www.oldurl’, ‘https://www.newurl’) WHERE option_name=”home” OR option_name=”siteurl”; UPDATE wp_posts SET guid = replace(guid, ‘https://www.oldurl’,’https://www.newurl’); UPDATE wp_posts … Read more

How to Add or Change Post Title

The first thing you want to do will be find the post you want to modify. To find the post named “beddu” which post_type is post, you can excute this query: SELECT * FROM wp_posts WHERE post_type=”post” AND post_title=”beddu”; After you test and find the condition is correct. Move to update part. UPDATE wp_posts SET … Read more

WordPress credentials not matched

If your database connection is wrong you will get an error says Error establishing database connection so if you seeing login form your connection is fine and wp-config has nothing to do in your issue. If you don’t remeber what’s your credentials are, go to your database manager like phpMyAdmin and look for _users table … Read more

Fastest way to display 5000 post titles?

In my opinion and from what i’ve seen on testing. Using any WordPress function will slow things down dramatically. The fastest way i found to do this is by querying MySQL directly and grabbing only the things needed. For example: $products = $wpdb->get_results( “SELECT post_title, post_name FROM `wp_posts` WHERE post_type=”products””, ARRAY_A ); echo ‘<ol>’; foreach … Read more