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
http://www.mysql.com/doc/U/s/User_names.html you can tie specific users to specific databases, also see http://www.mysql.com/doc/G/R/GRANT.html there is also a mysql users mailing list. hope this helps as starting point adam -- -- 110010100 --