Re: MySQL question

[Nikki Locke <nikki@trumphurst.com>]

In article <[🔎] 3B5D88DA.C3000314@njit.edu>, 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?

You can do that. I found MySQL security settings to be impossible to set 
up until I got the X MySQL Admin package. After that I merely found it 
difficult. You will certainly need to read the security section of the 
MySQL docs to get a vague idea of what they are talking about. Then try 
playing with the admin program until you have sussed out how it works.

-- 
Nikki Locke, Trumphurst Ltd.      PC & Unix consultancy & programming
nikki@trumphurst.com            http://www.trumphurst.com/