New to WordPress – trouble moving Database to New Server

I’m trying to move a SQL database from one server to a new one on NetworkSolutions. I moved all the files via FTP but the database gives me error messages each time.

I dumped the database from the old server as localhost.sql and tried to import it into my new host and get this error message:

———————————–

SQL query:

—
— Database: information_schema
—
CREATE DATABASE information_schema DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL said:

#1044 – Access denied for user ‘1_0332c83_0’@’localhost’ to database ‘information_schema’

———————————–

What am I don’t wrong?

HERE IS MY CODE:

———————————–

— phpMyAdmin SQL Dump
— version 3.3.9
— https://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: Mar 02, 2011 at 11:34 AM
— Server version: 5.0.91
— PHP Version: 5.2.6

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: information_schema
—
CREATE DATABASE information_schema DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE information_schema;

— ——————————————————–

—
— Table structure for table CHARACTER_SETS
—

CREATE TEMPORARY TABLE CHARACTER_SETS (
CHARACTER_SET_NAME varchar(64) NOT NULL default ”,
DEFAULT_COLLATE_NAME varchar(64) NOT NULL default ”,
DESCRIPTION varchar(60) NOT NULL default ”,
MAXLEN bigint(3) NOT NULL default ‘0’
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

—
— Dumping data for table CHARACTER_SETS
—

INSERT INTO CHARACTER_SETS (CHARACTER_SET_NAME, DEFAULT_COLLATE_NAME, DESCRIPTION, MAXLEN) VALUES
(‘big5’, ‘big5_chinese_ci’, ‘Big5 Traditional Chinese’, 2),
(‘dec8’, ‘dec8_swedish_ci’, ‘DEC West European’, 1),
(‘cp850’, ‘cp850_general_ci’, ‘DOS West European’, 1),
(‘hp8’, ‘hp8_english_ci’, ‘HP West European’, 1),
(‘koi8r’, ‘koi8r_general_ci’, ‘KOI8-R Relcom Russian’, 1),
(‘latin1’, ‘latin1_swedish_ci’, ‘cp1252 West European’, 1),
(‘latin2’, ‘latin2_general_ci’, ‘ISO 8859-2 Central European’, 1),
(‘swe7’, ‘swe7_swedish_ci’, ‘7bit Swedish’, 1),
(‘ascii’, ‘ascii_general_ci’, ‘US ASCII’, 1),
(‘ujis’, ‘ujis_japanese_ci’, ‘EUC-JP Japanese’, 3),
(‘sjis’, ‘sjis_japanese_ci’, ‘Shift-JIS Japanese’, 2),
(‘hebrew’, ‘hebrew_general_ci’, ‘ISO 8859-8 Hebrew’, 1),
(’tis620′, ’tis620_thai_ci’, ‘TIS620 Thai’, 1),
(‘euckr’, ‘euckr_korean_ci’, ‘EUC-KR Korean’, 2),
(‘koi8u’, ‘koi8u_general_ci’, ‘KOI8-U Ukrainian’, 1),
(‘gb2312’, ‘gb2312_chinese_ci’, ‘GB2312 Simplified Chinese’, 2),
(‘greek’, ‘greek_general_ci’, ‘ISO 8859-7 Greek’, 1),
(‘cp1250’, ‘cp1250_general_ci’, ‘Windows Central European’, 1),
(‘gbk’, ‘gbk_chinese_ci’, ‘GBK Simplified Chinese’, 2),
(‘latin5’, ‘latin5_turkish_ci’, ‘ISO 8859-9 Turkish’, 1),
(‘armscii8’, ‘armscii8_general_ci’, ‘ARMSCII-8 Armenian’, 1),
(‘utf8’, ‘utf8_general_ci’, ‘UTF-8 Unicode’, 3),
(‘ucs2’, ‘ucs2_general_ci’, ‘UCS-2 Unicode’, 2),
(‘cp866’, ‘cp866_general_ci’, ‘DOS Russian’, 1),
(‘keybcs2’, ‘keybcs2_general_ci’, ‘DOS Kamenicky Czech-Slovak’, 1),
(‘macce’, ‘macce_general_ci’, ‘Mac Central European’, 1),
(‘macroman’, ‘macroman_general_ci’, ‘Mac West European’, 1),
(‘cp852’, ‘cp852_general_ci’, ‘DOS Central European’, 1),
(‘latin7’, ‘latin7_general_ci’, ‘ISO 8859-13 Baltic’, 1),
(‘cp1251’, ‘cp1251_general_ci’, ‘Windows Cyrillic’, 1),
(‘cp1256’, ‘cp1256_general_ci’, ‘Windows Arabic’, 1),
(‘cp1257’, ‘cp1257_general_ci’, ‘Windows Baltic’, 1),
(‘binary’, ‘binary’, ‘Binary pseudo charset’, 1),
(‘geostd8’, ‘geostd8_general_ci’, ‘GEOSTD8 Georgian’, 1),
(‘cp932’, ‘cp932_japanese_ci’, ‘SJIS for Windows Japanese’, 2),
(‘eucjpms’, ‘eucjpms_japanese_ci’, ‘UJIS for Windows Japanese’, 3);

— ——————————————————–