Topic: sql password reset problem

[Dr_pepper]

This is the message ig am I using bad syntax

mysql> UPDATE root SET Password=******; (not my real password)
ERROR 1146: Table 'mysql.root' doesn't exist

[Dan Brown]

Don't reset the mysql root password.  If you really think you need to use the root account to install phorum (you don't), find out what the root password is, and use it.  If you change it, you'll confuse other parts of the SME system.

[Dr_pepper]

I know what the root passowrd is I am using it to log in to the ssh util.  So now do you have any suggestions the forum I am trying to install I made by phpbb

[Dan Brown]

As I posted in the other thread, the mysql root password is not the same as the system root password.

[Dr_pepper]

Ok I think i found a thread that will help me but it does not give all the directories i can look in any suggestions

http://forums.contribs.org/index.php?topic=12853.msg48390#msg48390

[Dr_pepper]

Ok after poking around for a while in the folder I found the my.cnf file but not i can find a line in the file that says password anywhere  i found it in the etc directory I dont have any files in the root directory.

[Duncan]

The my.conf file you are looking for sits in the /root directory. If as you say there are no longer any files in this directory then you have been a naughty boy in some of your previous attempts.

It sounds to me (looking thru your previous posts) that you are new to linux, which is fine but that said you really need to be careful what you do when running as root. You have the power to do a lot of damage in record time.

Try looking in the /etc/openldap/ldap.pw file. for your password. It will be a 75 character password.

Regards Duncan