Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

SQL 1044 Error

Discussion in 'Database Discussion' started by agentblack, Jul 20, 2009.

  1. agentblack

    agentblack Well-Known Member

    Mar 28, 2008
    Likes Received:
    Trophy Points:
    Hello everyone. I am having the dreaded mysql 1044 error "user @ localhost has no permissions......." I was wondering what i need to check to ensure this is working properly. I have access to whm, but thus far i have been unable to find out what the issue is.

    the user created his own db, added the user he wants to access it, but when he goes to import his old db it gives that error..

    any thoughts?

    *Edit: well, you can disregard. Got the issue resolved. I had asked him to only back up the tables, but it had the header info telling it to create a db, etc. which was causing the error out. So, if you are importing a db from somewhere, make sure you remove the top part of the file where it says:

    -- phpMyAdmin SQL Dump
    -- version
    -- Host:
    -- Generation Time:
    -- Server version: 5.0.51
    -- PHP Version: 5


    /*!40101 SET NAMES utf8 */;

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

    -- --------------------------------------------------------

    otherwise it will error out.
    #1 agentblack, Jul 20, 2009
    Last edited: Jul 20, 2009

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice