List:General Discussion« Previous MessageNext Message »
From:Gary.Every Date:January 15 2002 11:09pm
Subject:RE: Changing root password
View as plain text  
The file in the /etc/rc.d/init.d is likely called S95mysql, and you CAN add
that parameter to that file. You'll need to edit the file, and add something
like this:

/opt/mysql/bin/mysqld \
--basedir=opt/mysql \
...
--skip-grant-tables \
...
>> /var/log/mysql/mysql.err 2>&1

The ...'s above are other parameters that may or may not be there.



-----Original Message-----
From: Jay Paulson [mailto:jpaulson@stripped]
Sent: Tuesday, January 15, 2002 4:57 PM
To: mysql@stripped
Subject: Changing root password


I'm trying to change the root password for mysql.  This is the first time
I've tried to change the password and I can't get it to work.  Below is the
error message I get:

[root@localhost bin]# ./mysqladmin -u root -p password 'new-password'
Enter password:
./mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'

I've looked at the manual and it doesn't say much that I've already done.
I've also looked up the --skip-grant-tables but the only mysqld file I have
to run is in the /etc/rc.d/init.d/ directory and it doesn't take
the --skip-grant-tables flag.  So I'm at a lost at what to do next.

thanks.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread96451@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-Gary.Every=ingramentertainment.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thread
setting root psswd on Win2K ??Bryan Capitano10 Jan
  • Re: setting root psswd on Win2K ??Gerald Clark10 Jan
    • RE: setting root psswd on Win2K ??Todd Williamsen10 Jan
  • Re: setting root psswd on Win2K ??Gerald Clark10 Jan
  • Changing root passwordJay Paulson15 Jan
  • Re: Changing root passwordGerald Clark16 Jan
Re: setting root psswd on Win2K ??Bryan Capitano10 Jan
RE: Changing root passwordGary.Every16 Jan
Re: Changing root passwordRichard Ward16 Jan
Re: Changing root passwordRichard Ward16 Jan