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)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 26, 2003
votes: 0

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)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 22, 2001
votes: 0

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.


Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members