Re: [PHP-DB] Given only one mySQL user account by Host Company

2005-01-23 Thread Doug Thompson
@'localhost' on mysql.users indentified by password('my_pass'); bastien From: Doug Thompson <[EMAIL PROTECTED]> To: Shay <[EMAIL PROTECTED]> CC: php-db@lists.php.net Subject: Re: [PHP-DB] Given only one mySQL user account by Host Company Date: Sun, 23 Jan 2005 15:

Re: [PHP-DB] Given only one mySQL user account by Host Company

2005-01-23 Thread Bastien Koert
ied by password('my_pass'); bastien From: Doug Thompson <[EMAIL PROTECTED]> To: Shay <[EMAIL PROTECTED]> CC: php-db@lists.php.net Subject: Re: [PHP-DB] Given only one mySQL user account by Host Company Date: Sun, 23 Jan 2005 15:51:41 -0700 Shay wrote: Yes they gave me phpMyAdmi

Re: [PHP-DB] Given only one mySQL user account by Host Company

2005-01-23 Thread Stuart Felenstein
--- Doug Thompson <[EMAIL PROTECTED]> wrote: > > Shay wrote: > > Yes they gave me phpMyAdmin to use, and no, I have > no access to the > > user/privilege table. So the only way to output > database entries is to > > connect with the single super account they gave > me. > > > I find this unus

Re: [PHP-DB] Given only one mySQL user account by Host Company

2005-01-23 Thread Doug Thompson
Shay wrote: Yes they gave me phpMyAdmin to use, and no, I have no access to the user/privilege table. So the only way to output database entries is to connect with the single super account they gave me. Principally, this means you cannot allocate user accounts for mysql. No big deal unless you

Re: [PHP-DB] Given only one mySQL user account by Host Company

2005-01-23 Thread Shay
Yes they gave me phpMyAdmin to use, and no, I have no access to the user/privilege table. So the only way to output database entries is to connect with the single super account they gave me. I have a question about what you said Doug: >Use INCLUDEs for the login portions of the script(s) and pl

Re: [PHP-DB] Given only one mySQL user account by Host Company

2005-01-23 Thread Jochem Maas
Shay definitely has bad hosting. the guy wants a seperate mysql user with readonly privileges on his DB which is good practice. only ... his hostingco. has given him a single DB and a single user a/c. no doubt they manage their system via a webinterface - when every they add a customer, they check

RE: [PHP-DB] Given only one mySQL user account by Host Company

2005-01-23 Thread Bastien Koert
What admin tools do you have for the db? PhpMyAdmin? something else? Many of those can be used to create additional user accounts with more limited restricitions. Bastien From: "Shay" <[EMAIL PROTECTED]> Reply-To: "Shay" <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] Given only o

Re: [PHP-DB] Given only one mySQL user account by Host Company

2005-01-23 Thread Doug Thompson
Simple _complete_ solution: Find a different hosting company that provides a virtual server and root access to everything about your account. Cost should be nominal, but probably not free. Simple _partial_ solution: Use INCLUDEs for the login portions of the script(s) and place them in a prot