Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: scottt on September 27, 2000, 12:15:19 AM

Title: MySQL
Post by: scottt on September 27, 2000, 12:15:19 AM

Hello, I followed the instructions from the installing webbased email using MySQL and installed the MySQL rpms and the e-smith-mysql rpm. However when I try changing the root password I get this error:

connect to server at '.localhost' failed
error: 'Access deined for user: 'root@localhost' (Using password: NO)'

Any Idea what's causing this?

Thanks for any help.

Scott

Title: RE: MySQL
Post by: Tim Litwiller on September 27, 2000, 02:45:23 AM

your MySql must already have a password set. Do you remember what you set it as?  if you do add a -p to the end of the command line you are trying and then it will prompt you for your old password before it continues.

Title: RE: MySQL
Post by: scottt on September 27, 2000, 03:03:19 AM

I didn't ever set a password for it. I just installed it via the rpm's from

http://users3.50megs.com/danb35/webmail.html

using the instructions there. I've uninistalled it and retried several times. Is their a way to reset the password?

Thanks.

Title: RE: MySQL
Post by: Dan Brown on September 27, 2000, 04:04:29 AM

If you installed it following the directions I left, you did this:

Once you've installed MySQL, it's a very good idea to change the root password:

[root@e-smith /root]# mysqladmin -u root password mynewpassword

...and if so, your password is "mynewpassword".  What are you doing when you receive this error message?

Title: RE: MySQL
Post by: scottt on September 27, 2000, 04:12:40 AM

Hi Dan, I tried doing:

[root@e-smith /root]# mysqladmin -u root password mynewpassword

and that's when I got the error.

Title: RE: MySQL
Post by: scottt on September 27, 2000, 04:22:44 AM

I reinstalled e-smith and reinstalled MySQL and everything went great! I was able to reset the password. Thank's for your help.

On another note. I would like to use php-nuke. What directory should I untar it in to use it on my primary site?

Thank you again for your comments.

Scott