TOPIC: #1044 - Access denied for user 'spike'@'localhost'

I'm having problems exporting/importing my wp database.

The export from my wp seems to have worked (I tried a couple of times to make sure the db wasnt somehow corrupt.) But I get the following error when I try importing into my Joomla db;

#1044 - Access denied for user 'spike'@'localhost' to database 'spikemobile'

I'm hoping this is a quick fix!

Best Regards,
Mike

obvisously I forgot to select the CMigrator section can a mod please move it to the correct section.

I tried adding a user to the old database with the same name/pass as the new joomla but no luck.

Here's the 1st 20 lines of the export if it helps at all;

-- phpMyAdmin SQL Dump
-- version 3.4.5
-- www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Aug 09, 2012 at 10:35 AM
-- Server version: 5.5.14
-- PHP Version: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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: `spikemobile`
--
CREATE DATABASE `spikemobile` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `spikemobile`;

Hey Michael,
I think that your db user doesn't have the necessary rights to create a database.

This is localhost, right? So go with phpmyadmin on the users tab and make sure that your spike user has all the necessary privileges.

Kind regards,
Daniel

Hey Michael,

It is even possible that you exported your whole db as the sql file. This way your phpMyAdmin might try to create new database on mysql server and this wont help you migrate your content. Try to export only tables from your database and then import it to the Joomla database.
Check out this link for more help.
We can help you if you provide us with your username and password for phpMyAdmin, if you are able to do that.

Cheers,
Petar