Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Dr_pepper on March 20, 2002, 12:36:22 AM

Title: sql password reset problem
Post by: Dr_pepper on March 20, 2002, 12:36:22 AM

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

Title: Re: sql password reset problem
Post by: Dan Brown on March 20, 2002, 12:41:05 AM

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.

Title: Re: sql password reset problem
Post by: Dr_pepper on March 20, 2002, 12:46:18 AM

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

Title: Re: sql password reset problem
Post by: Dan Brown on March 20, 2002, 12:58:30 AM

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

Title: Re: sql password reset problem
Post by: Dr_pepper on March 20, 2002, 01:04:11 AM

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

Title: Re: sql password reset problem
Post by: Dr_pepper on March 20, 2002, 01:25:15 AM

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.

Title: Re: sql password reset problem
Post by: Duncan on March 20, 2002, 02:07:33 AM

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