Database importing issue

Discussion in 'MySQL' started by robibrk, Jul 4, 2008.

0
  1. #1
    Getting this error:

    SQL query:

    /*!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: `freehd_db`
    --
    CREATE DATABASE `freehd_db` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;


    MySQL said:
    #1044 - Access denied for user 'freehd'@'10.%' to database 'freehd_db'

    What can be wrong?
     
    robibrk, Jul 4, 2008 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    MySQL user freehd does not have rights on database freehd_db
     
    mwasif, Jul 5, 2008 IP
  3. sawz

    sawz Prominent Member

    Messages:
    8,225
    Likes Received:
    808
    Best Answers:
    0
    Trophy Points:
    360
    #3
    start by removing this from the top of your sql file:

    Database: `freehd_db`
    --
    CREATE DATABASE `freehd_db` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;


    then try again.
     
    sawz, Jul 5, 2008 IP