Re: MySQL question
Read about GRANT queries in the mysql manual.
You should definitely not be using your root info for web work -- in fact
I'd create a user with SELECT only privs for most of it ...
GRANT SELECT on YOURDB.* to username@localhost identified by 'somepassword'
Varying the YOURDB and the username@localhost/somepassword will give you different
permutations of access by user to different databases ... varying the SELECT (adding
additional permissions) will set the access rights. ... you can get more involved
with specific tables/columns within tables -- but that should get you in the
right direction.
On Tue, Jul 24, 2001 at 10:40:26AM -0400, Aaron Traas wrote:
> I currently have a database-driven web site up, with a PHP front end and
> MySQL back-end. The problem I'm having is that the login for the
> database is root and my root password. How do I change this?
>
> Also, I plan on having multiple web sites and thus multiple databases.
> Can I tie a user and password to one specific database (or set of
> databases) rather than giving said user access to all databases?
>
> Thanks in advance.
>
> --Aaron
>
>
> --
> To UNSUBSCRIBE, email to debian-user-request@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
--
Hank Marquardt <hank@yerpso.net>
http://web.yerpso.net
Web & Database Development in PHP, MySQL/PostgreSQL
Small Office Networking Solutions - Debian GNU/Linux & FreeBSD
PHP Instructor - HTML Writers Guild <http://www.hwg.org>
*** PHP II "The Cool Stuff" starts July 16, 2001
*** http://www.hwg.org/services/classes/p181.1.html
Reply to: