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
