homepage Welcome to WebmasterWorld Guest from 54.211.100.183
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Need Some Help Understanding Databases
differences between databases installed with CPanel vs Direct Admin
old_expat

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 76 posted 5:11 pm on Oct 9, 2005 (gmt 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.

 

volatilegx

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 76 posted 2:19 am on Oct 10, 2005 (gmt 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved