Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Thomas Kristensen on September 01, 2002, 03:08:05 PM

Title: PHP/MySql/Cron
Post by: Thomas Kristensen on September 01, 2002, 03:08:05 PM

I was tooling around with PHP the other night, having found a nice little tutorial on how to interact with Mysql from PHP (I'm used to ASP and ADODB).

I couldn't access my test DB (access denied) without setting a password on the root user which I did, but of course that was a mistake. This morning I received this mail from cron:

/etc/cron.daily/logrotate:

/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'

Now I'm trying to delete the root password on Mysql but the command:

mysqladmin -u root -p password

keeps saying: Too few arguments to change password. That makes sense since I don't specify a new password, I'm interested in deleting the existing and not specifying a new one.

Does it make sense to remove to root password on Mysql or should I instead make cron understand that it needs a password? And whichever option you might suggest, how is it done???

Thanks in advance,
Thomas Kristensen

Title: Re: PHP/MySql/Cron
Post by: Dan Brown on September 01, 2002, 05:32:44 PM

Really, it seems like this is something that comes up every week at least.  A forum search on mysql password would have found you all the information you need, including this URL:

http://www.familybrown.org/howtos/mysql-password-howto.html

Title: Re: PHP/MySql/Cron
Post by: Thomas Kristensen on September 01, 2002, 06:10:49 PM

Thanks Dan,

I saw your post in the Experienced forum containing the same link only after I had made my post. So maybe now I'll learn to do a search before shooting off questions :-)

Thanks,
Thomas

Title: Re: PHP/MySql/Cron
Post by: Abe Loveless on September 06, 2002, 10:39:22 PM

Thomas,

Where is the tutorial you were working with?  I've been through a couple of sites, but never really found a tutorial I like.

I'm also more familiar with the ASP on IIS area.

Thanks,
Abe

Title: Re: PHP/MySql/Cron
Post by: Thomas Kristensen on September 07, 2002, 02:48:44 AM

Hi Abe,

I did a basic search on Google for "php tutorial" and found this (among many others):

http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html

This is real basic stuff, getting a few records from mysql etc...

Cheers,
Thomas