Phpmyadmin Change User

[c-square]

Hi,

I just joined TCH yesterday and am trying to get my mySQL databases setup. I've created an admin user on my databases with full privileges, but whenever I go to phpMyAdmin, it logs me in as MyTCHUserID@localhost. How can I login to phpMyAdmin with my admin user account so that I can do things like adding tables via my stored procedures?

 

Thanks!

 

-- Chris

[TCH-Bruce]

Welcome to the forums Chris

 

I guess I'm not understanding your problem. If you access phpAdmin through your cPanel you should be able to do anything to your databases that an admin user would be able to do.

[c-square]

Welcome to the forums Chris

 

I guess I'm not understanding your problem. If you access phpAdmin through your cPanel you should be able to do anything to your databases that an admin user would be able to do.

 

Thanks! Glad the forums are here!

 

My specific error happens when I try to run a stored procedure that drops and recreates a database. The stored procedure goes like this:

 

CREATE PROCEDURE resetHoldingsdb ()

BEGIN

DROP DATABASE IF EXISTS <myTCHUserID>_holdingsDB;

CREATE DATABASE <myTCHUserID>_holdingsDB;

 

...

 

The error I get is the following:

 

#1044 - Access denied for user '<myTCHUserID>'@'localhost' to database '<myTCHUserID>_holdingsDB'

 

(Oh, and the stored procedure is residing on a different database than the one I'm trying to drop and recreate.)

Edited February 11, 2009 by c-square

[TCH-Bruce]

Not sure I can help but the techs on the help desk may be able to help you. Link at top of page or in my signature.

[TCH-Thomas]

Welcome to the forum, Chris.

[c-square]

Not sure I can help but the techs on the help desk may be able to help you. Link at top of page or in my signature.

 

Will do. Thanks for the help.