Solved

myphpadmin error

Posted on 2008-10-05
5
1,035 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 500 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

770 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