Can't reset mysql root password
Hi there
I'm going crazy trying to reset the mysql root password. I've read plenty of articles on how to do it, but any suggested commands that I enter in terminal don't work.
I can't even access mysql in terminal.
Below are just some of the messages:
Last login: Mon Mar 8 17:34:00 on console
Welcome to Darwin!
paul-dodsons-Computer:~ pauldodson$ /usr/local/mysql/bin/mysql-root
-bash: /usr/local/mysql/bin/mysql-root: No such file or directory
paul-dodsons-Computer:~ pauldodson$ man sharing
No manual entry for sharing
paul-dodsons-Computer:~ pauldodson$ kill `cat /mysql-data-directory/host_name.pid`
cat: /mysql-data-directory/host_name.pid: No such file or directory
kill: usage: kill [-s sigspec | -n signum | -sigspec] [pid | job]... or kill -l [sigspec]
paul-dodsons-Computer:~ pauldodson$ mysqld_safe --init-file=/home/me/mysql-init &
[1] 2422
paul-dodsons-Computer:~ pauldodson$ -bash: mysqld_safe: command not found
mysql
-bash: mysql: command not found
[1]+ Exit 127 mysqld_safe --init-file=/home/me/mysql-init
paul-dodsons-Computer:~ pauldodson$
paul-dodsons-Computer:~ pauldodson$ mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
-bash: syntax error near unexpected token `('
paul-dodsons-Computer:~ pauldodson$ -> WHERE User='root';
-bash: -: command not found
paul-dodsons-Computer:~ pauldodson$ mysql> FLUSH PRIVILEGES;
-bash: mysql: command not found
paul-dodsons-Computer:~ pauldodson$
Can anyone PLEASE help with this before I go insane.
Thank you.
Paul