Skip the -p.
You have no current password .
Jay Paulson wrote:
>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 '
If you have just finished installing, then root has no current password
and you can leave out the -p altogether:
root@localhost bin]# ./mysqladmin -u root password 'new-password'
good luck
Richard Ward
>>> "Jay Paulson" <[EMAIL PROTECTED]> 01/16/02 12:57AM >>>
I'm trying to change the root pa
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 oth