Error when importing sql table in PHPMYADMIN

Connect with other users about what to run on your webhosting (and how to run it) here.
Post Reply
ickycoolboy
New to forums
New to forums
Posts: 4
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Mon Dec 22, 2014 11:41 am

Error when importing sql table in PHPMYADMIN

Post by ickycoolboy »

Whenever I try to import a table to get this admin web panel for my server to work, i get this:
Error
SQL query:


CREATE DATABASE IF NOT EXISTS `adminpanel` /*!40100 DEFAULT CHARACTER SET latin1 */;
MySQL said: Documentation

#1044 - Access denied for user 'ickyservers'@'localhost' to database 'adminpanel'

I am following the directions from this guide:
https://docs.google.com/document/d/1SQn ... N6wIQ/edit
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: Error when importing sql table in PHPMYADMIN

Post by soja »

The database name has to be package_dbname. This allows each package to have unique database names(2 customers can't have the same database name).

You can edit the file to add this, or make the database using the databases tab and then edit the sql statements are are importing to use the new database name. I recommed the latter.

Can you post the .sql file, or all of the sql statements you are trying to import? I can try to edit them for you if you are unsure what to do.
Not a NFO employee
ickycoolboy
New to forums
New to forums
Posts: 4
Joined: Mon Dec 22, 2014 11:41 am

Re: Error when importing sql table in PHPMYADMIN

Post by ickycoolboy »

Thank you for the help :) I changed the name inside the file and it imported succesfully.
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: Error when importing sql table in PHPMYADMIN

Post by soja »

Great, glad you got it to work :)

If you need anything else please ask!
Not a NFO employee
Post Reply