Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

myphpadmin error

Posted on 2008-10-05
5
Medium Priority
?
1,043 Views
Last Modified: 2013-12-13
I have been trying to import an database from one hosting company to another. I have created the data via control panel and i assigned full access to the main user account.

When I import the database i get the following error:

Error
SQL query:

--
-- Database: `U1175941`
--
CREATE DATABASE `U1175941` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL said:  
#1044 - Access denied for user 'kitchen_admin'@'%' to database 'U1175941'

Im no DBA but Im assuming i can get around.

Any idea?
0
Comment
Question by:nexxsupport
  • 2
5 Comments
 
LVL 3

Expert Comment

by:wktang83
ID: 22647638
Do you have the privileges to create a database?

You can check your privileges by clicking on the privileges link on the phpmyadmin home page.

Unless you are logged in as root (which has ALL privileges), usually you have only limited privileges.
0
 

Author Comment

by:nexxsupport
ID: 22649650
I believe I do, i logged onto the hosting server as the main admin. Also I am to create databases, just seems when i try to import one there is this access denied error.
0
 
LVL 3

Accepted Solution

by:
wktang83 earned 2000 total points
ID: 22651685
I get an error ACCESS DENIED CREATE DATABASE db_name when I try to import a database

In order to solve this issue follow these steps:

   1. Open the mysql dump with a text editor on your local pc / mac;
   2. Delete the line saying "CREATE DATABASE yourdbname". Usually this line is found in the very beginning of the file;
   3. Save the file and try to import it again.


Try this.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question