Koozali.org: home of the SME Server
Legacy Forums => Experienced User Forum => Topic started by: Eric on August 10, 2002, 04:41:37 AM
-
i'm trying to setup the phpMySetiStats for my seti@home. I have everything correct..i think...except for the $dbuser and $dbpass.
I don't know which user and password it wants. I've tried the ones for my server, but I believe it's asking for the one from mysql.
I just don't know...I'd appreciate any input from the awesome people out there....
And PLEASE don't tell me to RTFM... Here's what the manual says:
#Edit config.php to fit your needs
[root@server seti]# pico config.php
That's it, pretty lame, huh?
-
Try using 'root' as the username and get the root mysql password from
/root/.my.cnf
The password is around 75 characters long. Make sure you copy it all.
Jon
-
Jon Blakely wrote:
> Try using 'root' as the username
No, that's not a good idea. Seti only needs access to its own table, so you should create a seti user with its own password and table, and grant that user access to that table.
Charlie
-
I've created the user, how do I give that user rights to the phpMySetiStats table?
-
Did you ever work out how to fix this? I have the same problem. (give setiuser rights to the table)
TIA,
miked
-
Hi,
If you've created the user I assume you've done that for mysql? If not you can use the example in the Post Nuke Howto on e-smith.org. If You have created a mysql user than you're looking for this:
# mysql -u root
mysql> grant all on seti.* to setiuser@localhost identified by 'password_for_seti;
Where seti.* is the name of your mysql-dbase and setiuser the user you created. The password you can set to what you like.
Anyway, you should check out the howto on PostNuke0.7 on http://www.e-smith.org/docs/howto/contrib/postnuke-0.7-howto.html . It may give you the pointers you need.
Hope this helps
regards,
Jan