phpMyAdmin

[jleemc44]

Forgive the stupidity, this could be simple so I'm going to try a post before opening a ticket.

I'm trying to inport a table into an sql database with phpMyAdmin.

I'm logging in using the domains login, not the whm master account.

When I load phpMyAdmin I notice a message in red saying No Privileges.

I will not let me inport anything and gives me the same error.

Also, when I click logout it tells me incorrect loging or password, even though I was just logged in.

What gives?

[colt45]

You need to first create your MySQL database and database user using the MySQL Databases utility that's just before the PHPMyAdmin icon.

Create a database, create a database user, then assign the user to the database with "All privileges"

Once the database is created you can use PHPMyAdmin to import your data.

[jleemc44]

Thanks colt45 for the tip. However I did at least think to create a database before trying to import data into it. . Although I have done stupider things before. The problems seems to be phpMyAdmin doesn't believe I have the rights to create tables even though I am logged in correctly and the database does have a user.

Maybe I should open a ticket.

[H9Travis]

Hi,

If you have a .sql export of your database it is often easier for us to import it from root shell. If you would like it imported by us just open a ticket to support with your primary domain, the domain the database will go to, the location of your .sql export, and the database you want it imported to.

Note that the database must be created through the MySQL manager in cPanel, and can contain no duplicate tables as defined by your .sql export.

[colt45]

I'm wondering why this isn't working for the OP. I've moved all of my Joomla sites from my old host to H9 by importing SQL exports of the original MySQL databases.

I do see the "No Privileges" warning, but it only disallows database creation via PHPMyAdmin. All other functions work OK.

[kobra]

Colt45

Originally Posted by jleemc44

However I did at least think to create a database before trying to import data into it.

But he did not verify that he created a user and assign this user to this DB as you had tutored in your first post and is required

[jleemc44]

Originally Posted by kobra

Colt45

But he did not verify that he created a user and assign this user to this DB as you had tutored in your first post and is required

Yes, I did assign a user to the DB and gave it full privileges. Here are screen shots of the entire process and what goes wrong. I know they are not all in the same browser. This is because I tried it in both IE and FF.

Please Observe:

[colt45]

Yes, the error is valid.

Your SQL query is attempting to "create database mysql519yadayada"

Edit your query to say "use mysql519yadayada" instead, where mysql519yadayada is the name of the database you created using the MySQL account manager.

[kobra]

Thanks for the screen shots and ditto colt45 -

You can not "Create a database when using this phpmyadmin through cPanel.
You must use cPanel to create the DB's.

The exit message is standard - just ignore and close window

[jleemc44]

OK, it's apparent the problem is lack of knowledge on the subject.

I want to move a mambo site from my old host to this one. I haven't a clue
how to accomplish this but I assumed the first step was to move the MySQL database over.

So, I exported the db from the old host and tried to import to the new one. Thats when I got the above messages.

So I did what was suggested and changed the query to USE vs CREATE.

Now the process returns with:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATABASE `mysql05199f841b67d0b58f313b614ac` DEFAULT CHARACTER SET latin1 COLLATE' at line 1

If you wouldn't mind, please point me in the right direction from here. The only way I ever learn anything is to do it myself. I' have checked the docs and can't pinpoint the issue.

Thanks for all the help.