JohnO
03-12-2007, 03:30 PM
Hello,
I have a site that uses the SQL databases to store account information. I have always just accessed it through the CPanel.
I have some administrators on my site that need access to this account information.
Here is the problem: The PHPMyAdmin login links all go through the CPanel. Everytime I try to log into the MySQL using test accounts I have created, it never works. It always attempts to connect to the CPanel, and since their account isn't for the CPanel (only MySQL) they cannot login at all.
I have had hosting elsewhere that allows me to actually log into PHPMyAdmin without even seeing the CPanel. Matter of fact, using it you can even control what databases on the SQL that they can view. OF course I want my guys to view all the databases anyways.
My point is that there should be some means to log into the phpmyadmin other then using the main CPanel account.
Questions:
Is there another link other then the one in my CPanel that they need to use in order to log into the PHPMyAdmin? Presently the only link I have is the one provided in the CPanel, which doesn't seem to work for any account other then the main CPanel login account.
If the SQL Account I created is named "Testing," and appears as "itsaliv5_Testing" and I have the password set to "Testing1234" what exactly should I put in the login box? I have tried all combinations and I am assuming that I need to use a different link for SQLDb-Only accounts.
***NOTE: Here are the steps I took when creating the test accounts:
I opened up the CPanel, Logged in, and click on "MySQL Databases" in the "Databases" section of the CPanel
In the "Users" section of the page, I added a username "Testing" with a password of "Testing1234" then clicked "Add User"
The account name was added to the list as "itsaliv5_Testing"
Still in the "MySQL Databases" Page, I look in the "databases" section of the page. I click on the dropdown box for USER: and select the account I just created, "itsaliv5_Testing"
My database is named "itsaliv5_accountinfo" and so in the dropdown box next to Db: I select "itsaliv5_accountinfo" from the list.
In the Privledges: section below the dropdown boxes I select the checkbox for ALL PRIVLEDGES.
I click the "Add User to Db" button.
The account name I created now has a permission set under the "Databases" section
For some reason I cannot log into the SQL Database with this information. What am I doing wrong?
Again, the only way I can log into the SQL Database despite all the other accounts I have made, is to use my CPanel login information.
**EDIT: Tech support told me that the only way to access phpmyadmin is to log into CPanel. I don't understand it... So many other hosts allow it but they don't... Talk about a major limitation.
I have a site that uses the SQL databases to store account information. I have always just accessed it through the CPanel.
I have some administrators on my site that need access to this account information.
Here is the problem: The PHPMyAdmin login links all go through the CPanel. Everytime I try to log into the MySQL using test accounts I have created, it never works. It always attempts to connect to the CPanel, and since their account isn't for the CPanel (only MySQL) they cannot login at all.
I have had hosting elsewhere that allows me to actually log into PHPMyAdmin without even seeing the CPanel. Matter of fact, using it you can even control what databases on the SQL that they can view. OF course I want my guys to view all the databases anyways.
My point is that there should be some means to log into the phpmyadmin other then using the main CPanel account.
Questions:
Is there another link other then the one in my CPanel that they need to use in order to log into the PHPMyAdmin? Presently the only link I have is the one provided in the CPanel, which doesn't seem to work for any account other then the main CPanel login account.
If the SQL Account I created is named "Testing," and appears as "itsaliv5_Testing" and I have the password set to "Testing1234" what exactly should I put in the login box? I have tried all combinations and I am assuming that I need to use a different link for SQLDb-Only accounts.
***NOTE: Here are the steps I took when creating the test accounts:
I opened up the CPanel, Logged in, and click on "MySQL Databases" in the "Databases" section of the CPanel
In the "Users" section of the page, I added a username "Testing" with a password of "Testing1234" then clicked "Add User"
The account name was added to the list as "itsaliv5_Testing"
Still in the "MySQL Databases" Page, I look in the "databases" section of the page. I click on the dropdown box for USER: and select the account I just created, "itsaliv5_Testing"
My database is named "itsaliv5_accountinfo" and so in the dropdown box next to Db: I select "itsaliv5_accountinfo" from the list.
In the Privledges: section below the dropdown boxes I select the checkbox for ALL PRIVLEDGES.
I click the "Add User to Db" button.
The account name I created now has a permission set under the "Databases" section
For some reason I cannot log into the SQL Database with this information. What am I doing wrong?
Again, the only way I can log into the SQL Database despite all the other accounts I have made, is to use my CPanel login information.
**EDIT: Tech support told me that the only way to access phpmyadmin is to log into CPanel. I don't understand it... So many other hosts allow it but they don't... Talk about a major limitation.