--- Chris <[EMAIL PROTECTED]> wrote: - snip -
> So you *have* set the root password before. > > From your previous emails: > > # mysqladmin -u root password yourrootsqlpassword > > That set the password to "yourrootsqlpassword". > > > > If you need to reset it, see documentation: > > http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html I tried learning resetting the password according to above URL. I can't find "set" command on this box. I don't know which package provides it so finally I surrendered. > As a final recourse, remove & re-install mysql from your server. > > If you have no data, then that might be the quickest & easiest. I have no data as this is a new installation for learning. # yum groupremove mysql It went throught w/o complaint. # yum install mysql mysql-devel mysql-server Also went through w/o complaint # nano /etc/init.d/mysqld changed; restart(){ stop start } *end* to; restart(){ stop sleep 3 start } *end* # chkconfig --levels 235 mysqld on No complaint # /etc/init.d/mysqld start Starting MySQL: [ OK ] # netstat -tap tcp 0 0 *:mysql *:* ..... *end* # mysqladmin -u root password myrootpassword mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' *end* Still the same B.R. satimis Send instant messages to your online friends http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]