Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Location
    London, England
    Posts
    71

    Angry Unanswered: Importing *.sql into mySQL

    Hi,
    I am relatively new with mySQL and I am having big problems importing a *.sql file into mySQL. It was sent to me by a client of mine to work with.

    I have tried what is suggested in the logs but it keeps telling me "ERROR 1045: Access denied for user: 'username@localhost' <Using Password: YES>

    I am actually typing the following:-
    C:\mysql\bin>mysql -u username -p -D database < c:\latestDB.sql

    I am running mySQL and Clients 4.0.17
    on Windows XP Pro

    Please help as it is driving me mad, and I can't see what I am doing wrong.

    Thanks.

  2. #2
    Join Date
    Jul 2004
    Location
    Dundee, Scotland
    Posts
    107
    The permissions on the MySQL server will need to be configured to accept connections to the specific MySQL database via the MySQL username you specify, and to do the specific operations you need (e.g. insert, create tables). this is a common wall to hit when first using MySQL.

    I assume you can connect to MySQL using:
    shell> mysql --user=root mysql

    Then try a variation of:
    mysql> GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
    mysql> FLUSH PRIVILEGES;

    I also came across this which might be of use:
    http://www.itlab.musc.edu/mysql_user...rs_readme.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •