My company hosts their intranet on their own internal server. The intranet runs a mysql database. We no longer know the root password to update or create a database. However the php coding calling up the intranet's database has a different user name other than root(the privileges aren't set as high as superuser). If I reset the mysql root password (http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
) will it delete my other user names and passwords? Will resetting the root password allow me to create and alter databases while keeping my php scripts working that use a different username and password? Lastly, will other parts of the server be affected other than my php scripts that access the database if I reset the root password? thanks.