Need Some Help Understanding Databases

differences between databases installed with CPanel vs Direct Admin

[old_expat]

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.

[volatilegx]

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.