In article <[EMAIL PROTECTED]>, 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 [EMAIL PROTECTED] http://www.trumphurst.com/
