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!

#1044 - Access denied for user

Discussion in 'Database Discussion' started by bojann, Jan 14, 2015.

  1. bojann

    bojann Registered

    Joined:
    Jan 14, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Hi,

    Tthis is my first post here so I will try to be right to the point, I need help

    As a beginner in this field I just started to do some AJAX,PHP and MySQL tutorial from Tuts+ and need to import 'sakila-schema.sql' to my database ( FROM HERE MySQL :: MySQL Documentation: Other MySQL Documentation ) , but I ended up having error replay

    SQL query:

    DROP SCHEMA IF EXISTS sakila;

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



    This is how it looks first few rows of the 'sakila-schema.sql'

    Code:
    [COLOR="#0000CD"]SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
    SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
    SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
    
    DROP SCHEMA IF EXISTS sakila;
    CREATE SCHEMA sakila;
    USE sakila;
    
    --
    -- Table structure for table `actor`
    --
    
    CREATE TABLE actor (
      actor_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
      first_name VARCHAR(45) NOT NULL,
      last_name VARCHAR(45) NOT NULL,[/COLOR] ............


    P.S. I have tried to look for solution but ended having no luck .Had my hopes on this one MySQL - 1044 Access Denied Error Message | InMotion Hosting but inputting "--" didn't help me
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,895
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    What method are you using to import the database? Do you have root access to this server? Have you verified the database user is added to the database via the "MySQL Databases" option in cPanel?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. ottdev

    ottdev Well-Known Member

    Joined:
    Oct 1, 2013
    Messages:
    115
    Likes Received:
    3
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Had this recently - after creating your database in the cpanel, check its name - I believe they are usually prefaced with the account. i.e. instead of sakila, it may be sakila_sakila or bojann_sakila etc... (whatever the account username is)
     
Loading...

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