The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

#1044 - Access denied for user

Discussion in 'Database Discussions' 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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. ottdev

    ottdev Well-Known Member

    Joined:
    Oct 1, 2013
    Messages:
    63
    Likes Received:
    1
    Trophy Points:
    8
    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