Help with MySQL

[abed]

Hi,
I am new to SiteGround and am trying to move the Joomla based website I have on my local server moved to my SiteGround new account.....however after uploading all the Joomla site files using FTP as instructed, I am having a hard time importing the JoomlaDB (MySQL Database) from the BackUp...after I create a new Joomladb form the CPanel and create a new user and add it to the New Database....I go to the phpMyAdmin to import the Database Dump ...however, I get access denied for the new user I just created in CPanel (#1044 - Access denied for user '(my account name appears here and not the new user account!!)'@'localhost' to database 'joomladb' ) !!!
When I go to phpMyAdmin Home, I can see on the Create New Database...No Privilages!!! I tried to create a user account with the same name as my login, but it keeps adding the domainname_ prefix to any new account I create!!!!
Thanks in advance for you help.

[Brandon]

Hi Abed,

This is a common issue, that you are experiencing. Since the phpMyAdmin that we run on our servers is integrated with the cPanel it can not work separated from it. I.e. -- you can consider the phpMyAdmin more as a tool for exploring, managing (in aspect of content, collation, etc.) your databases, but not for creating.

The MySQL databases creation is being done from your cPanel, under the MySQL databases menu. There you have options to create, delete and repair your MySQL databases, to add users with certain, limited or ALL privileges.

There you can create a database using the Create Db tool, but note hat if your cPanel username is abed, for example, and you create a database named forum, the database name will be abed_forum. The same goes with the users, if you create a username named user, it will be created under abed_user, as this is the cPanel hierarchy method for separating and guaranteeing iniquity of the MySQL databases on a shared hosting server.

Then you can go to your phpMyAdmin and import your dump, however, prior doing this, make sure that the heading row named "CREATE DATABASE yourdbname" is removed, as this will stop the phpMyAdmin from operating properly.