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 --
