chimi

It takes much time to understand it, can you tell me how to do it in short time without reading all that ? like Dreamweaver can i draw table and adjust set the post??

/** MySQL database username */
define(‘DB_USER’, ‘wordpress’);

and in wp-config.php

/** MySQL database username */
define(‘DB_USER’, ‘wordpress’);

same i did ….. check the text above as i pasted*

i m patiently waiting for your reply

Regards chimi

my dear the same problem … check here .. i did the same as you said sir,

// ** MySQL settings – You can get this info from your web host ** //
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘wordpress’);

/** MySQL database username */
define(‘DB_USER’, ‘wordpress’);

/** MySQL database password */
define(‘DB_PASSWORD’, ‘password’);

/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);

/** Database Charset to use in creating database tables. */
define(‘DB_CHARSET’, ‘utf8’);

/** The Database Collate type. Don’t change this if in doubt. */
define(‘DB_COLLATE’, ”);

======================================

and this is my localhost.sql file check below
=============================================

— phpMyAdmin SQL Dump
— version 3.2.4
— https://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: Apr 04, 2010 at 12:04 AM
— Server version: 5.1.41
— PHP Version: 5.3.1

SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

—
— Database: wordpress
—
CREATE DATABASE wordpress DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE wordpress;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

=====================================================

and i upload the localhost.sql file also

now what should i do ?

okay .. now i create again database name, username , and password in myphpadmin…

one of my friend create database on the windows base web hosting, through phpmyadmin, but he wont let me know * thats thhe problem ..

respected, the webhosting dont have the myphpadmin, that is why i m using the local phpadmin…..

databasename: wp_db
dtabaseuser: db_user
password: 123456
db_host: localhost
gave all privileges
and export it to localhost.sql
and upload it,

in wp-config.php file i did the following*

==============================
// ** MySQL settings – You can get this info from your web host ** //
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘wp_db’);

/** MySQL database username */
define(‘DB_USER’, ‘wp_user’);

/** MySQL database password */
define(‘DB_PASSWORD’, ‘123456’);

/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);

it shows me the error
Error establishing a database connection

now i want to know that the username and password which me webhosting provider , how and where i will use it ?

i m using the phpmyadmin from local computer, my webhosting is windows base hosting plan, i create the following database user etc and put into the wp-config.php but same problem ….

the webhost provider gave me username n password for database but i dnt know how to change the password or how to login …

i followed the link which u gave me but i dont know how to deal with that ? ?? can u explain it in details please ?

Yes ericreynolds007 i create username , password , database name, and also add mysql host name through MYPHPADMIN because my hosting is windows base hosting thats why i install the XAMPP myphpadmin and create the following now i would like to know how to connect my database with wordpress..

Regards
Chimi

same problem here …. ?? but i m under windows base webhosting …. *

this errors comes to me

plz help

Error establishing a database connection

This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at localhost. This could mean your host’s database server is down.

* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct hostname?
* Are you sure that the database server is running?

If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.

it shows the following error

(Error establishing a database connection)