Topic: PHP/MySql/Cron

[Thomas Kristensen]

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

[Dan Brown]

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

[Thomas Kristensen]

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

[Abe Loveless]

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

[Thomas Kristensen]

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