resetting a password

2002-02-12 Thread jeremy rotsztain
hello, following the instructions for resetting a password ( http://www.mysql.com/doc/R/e/Resetting_permissions.html ), i was not able to find the .pid file. is it possible to continue the process without killing it? what would be the command to restart the daemon using the --skip-grant-tables o

more problems: session ends immediately ...

2002-02-11 Thread jeremy rotsztain
hello again, still learning ... i'm experiencing some unusual behaviors from the daemon. it stops immediately. [localhost:/usr/local/mysql] root# sudo ./bin/safe_mysqld --user=mysql & [localhost:/usr/local/mysql] root# Starting mysqld daemon with databases from /usr/local/mysql/data 020205 1

more problems: session ends immediately ...

2002-02-05 Thread jeremy rotsztain
hello again, still learning ... i'm experiencing some unusual behaviors from the daemon. it stops immediately. [localhost:/usr/local/mysql] root# sudo ./bin/safe_mysqld --user=mysql & [localhost:/usr/local/mysql] root# Starting mysqld daemon with databases from /usr/local/mysql/data 020205 1

resetting a password

2002-02-05 Thread jeremy rotsztain
hello, following the instructions for resetting a password ( http://www.mysql.com/doc/R/e/Resetting_permissions.html ), i was not able to find the .pid file. is it possible to continue the process without killing it? what would be the command to restart the daemon using the --skip-grant-tables o

admin privilege problems

2002-02-05 Thread jeremy rotsztain
hello, i made the mistake of changing my root password manually in the mysql database. after doing so, i 'flushed privileges'. now i'm unable to log on using the root. i've tried to log on using the new password a number of times, but i'm always denied access. strangely enough, other users (tha