Forums

Importing MySQL Database to Wordpress (3 posts)

  1. grgry191
    Member
    Posted 5 months ago #

    Hello,

    I'm hoping someone here will be able to help me. I've run a couple of google and wordpress search and haven't found anything useful.

    I have an existing somewhat custom blog connected to a MySQL database that I'm trying to move over to wordpress. The "import" option in wordpress under Tools does not list regular MySQL databases so I was not able to import directly from the wordpress admin panel.

    I did a search and came across a How-to here on Wordpress.org that shows how to import directly from the phpMyAdmin panel. Problem is I'm getting an error message that's totally baffled me. See below:

    Error
    SQL query:
    --
    -- Database: information_schema
    --
    CREATE DATABASE information_schema DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    MySQL said: Documentation
    #1044 - Access denied for user 'phreshcc_grgry'@'localhost' to database 'information_schema'

    Does anyone know what this means and how I can get around it? Thanks in advance. This has become a three days headaches that I need to end.

    Thanks.

  2. MichaelH
    moderator
    Posted 5 months ago #

    The phpMyAdmin import thing would not seem practical from a MySQL database that is not a WordPress set of tables.

    Might look at using this:
    http://www.zackpreble.com/2008/03/28/importing-posts-from-csv-file-into-wordpress/

  3. lostrepublic
    Member
    Posted 3 months ago #

    Same problem.

    CREATE DATABASE information_schema DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    MySQL said: Documentation
    #1044 - Access denied for user 'lostrepublicus'@'%' to database 'information_schema'

Reply

You must log in to post.

About this Topic