Re: Changing root password

2002-01-16 Thread Gerald Clark
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 '

Re: Changing root password

2002-01-16 Thread Richard Ward
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

RE: Changing root password

2002-01-15 Thread Gary . Every
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