Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Need Some Help Understanding Databases

differences between databases installed with CPanel vs Direct Admin



5:11 pm on Oct 9, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member

Yesterday I installed a database with CPanel, ran a create table query, imported some test data and managed to patch together an old script to run a query.

No matter what I did, I kept getting a "not authorized ..." error

After a few hours of beating my head against the wall, I deleted the database, and this time created the database and table with phpmyadmin. The thing worked the first try.

Can someone please expain this to me, and whether the database set up with phpmyadmin (it has no password or priviledges set)is a security risk.

I really don't understand the passwords and priviledges issues of databases.


2:19 am on Oct 10, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member

It probably has to do with the username your script is using. CPanel and PHPMyadmin sometimes prepend the hosting account's user name to the database's user name, followed by an underscore. For example:

If your hosting accounts user name is: fred
and the database user's name is: foo
the actual database user name might be: fred_foo

It's not always readily apparent that this is the case.


Featured Threads

Hot Threads This Week

Hot Threads This Month