Welcome to WebmasterWorld Guest from 18.104.22.168 , register , free tools , login , search , pro membership , help , library , announcements , recent posts , open posts Become a Pro Member
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.
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.