Sounds reasonable, but how do I shutdown down MYSQL so I can restart with --skip-grant-tables option?
On 1/30/06, Dan Trainor <[EMAIL PROTECTED]> wrote: > > sol beach wrote: > > I've been asked to assist the folks who own the data in the database, > but > > folks who used to maintain it are no longer with the company. > > This installation resides on a Windows 2003 server to which I have local > > admin rights. > > What is the most painless way to get "root" access to this database? > > I am more than willing to RTFM, if anyone will point me at which FM to > read. > > > > TIA > > > > Hi - > > I've always used the startup option of '--skip-grant-tables'. This may > or may not be the "correct" way to do so, but we'll see what kind of > feedback we get. > > I do this, then update the Password field in the mysql.user table. > > HTH > -dant >