problem problem and problem with db

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 ?

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

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
— http://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 ?