What affects will resetting mysql root password have on my database and server?

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.
iamdiggnifiedAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

cyberkiwiCommented:
If you reset the root password, only the root user is affected, so no- it doesn't really affect anything on the server aside from one single record in the user table for the password of the root user.
You know what that means.
cyberkiwiCommented:
Well, I hope you do.
If as you mention, all current access is via other logins, then they continue to work fine.  Anything that you have not discovered that may be using the old root password - those won't work anymore.

The only thing the rest procedure does is run this script:
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';

Open in new window

without being logged in as any user via init.
iamdiggnifiedAuthor Commented:
I was hoping for a little more clarification. Is there a way to see what other operations on the server or its databases are affected by creating a new root user password?
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

cyberkiwiCommented:
There are no triggers, nothing else is affected and there are no other operations.
All it does is update the password in one record on one table in the mysql database.

From then on, when the "root" user logs in, it is validated against that new password.  That's all there is to it.
wolfgang_93Commented:
Some comments:

-  What could get affected are maintenance jobs that are run routinely to administer
   your MySQL system. For example, to run mysqldump requires special privileges
   to dump your databases and though it is a better practice to set up a special account
   with privileges for this purpose, it is unlikely.

   I would look around for maintenance scripts that are being run automatically and
   that could have the root password imbedded in them. (This also would let you
   know the current root password).

-  I am assuming that you tried loggging onto the root account with no password and that
   it failed? (The default when setting up MySQL is a null password for the root account and
   it is conceivable that your predecessor never set one up -- a poor idea!)

-  If there is a password against your root account, then you are first going to have to
   follow a procedure to get in as root without a password
   in order to issue the UPDATE ... SET PASSWORD command.
   See: http://www.cyberciti.biz/tips/recover-mysql-root-password.html

-  After issuing the UPDATE ... SET PASSWORD command, the password will not
   change until you also issue this command after:
      FLUSH PRIVILEGES;







Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cyberkiwiCommented:
wolfgang
the reset procedure on the mysql site which requires access to the box itself (console) covers your last 2 points
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.