#1044 - Access denied for user

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 [url=http://dev.mysql.com/doc/index-other.html]MySQL :: MySQL Documentation: Other MySQL Documentation ) , but I ended up having error replay [COLOR="#FF0000">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'

[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, ............

P.S. I have tried to look for solution but ended having no luck .Had my hopes on this one [url=http://www.inmotionhosting.com/support/website/database-troubleshooting/mysql-1044-access-denied-error-message]MySQL - 1044 Access Denied Error Message | InMotion Hosting but inputting "--" didn't help me

cPanelMichael

January 15, 2015 12:29

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.

ottdev

January 15, 2015 16:04

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)

#1044 - Access denied for user

Comments

Didn't find what you were looking for?