Koozali.org: home of the SME Server

MySQL

scottt

MySQL
« 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

Tim Litwiller

RE: MySQL
« Reply #1 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.

scottt

RE: MySQL
« Reply #2 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.

Dan Brown

RE: MySQL
« Reply #3 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?

scottt

RE: MySQL
« Reply #4 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.

scottt

RE: MySQL
« Reply #5 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