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
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 Bastien Koert
net Subject: [PHP-DB] Given only one mySQL user account by Host Company Date: Sun, 23 Jan 2005 03:03:26 -0700 My hosting company gave me one database and one root user account, and I have no access for priviliges at all. So as far as I can tell, the only way for me to connect to the database on

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

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

2005-01-23 Thread Shay
My hosting company gave me one database and one root user account, and I have no access for priviliges at all. So as far as I can tell, the only way for me to connect to the database on my site is to do a mysql_connect("host", "user", "pass"), where the user and pass are the ones for this one s