Web Hosting Talk







View Full Version : mysql.inc statement?


SeanC
02-26-2002, 05:04 PM
I'm installing a mailing list manager for a client
http://www.phplist.com

and am receiving this notice when I run the admin script.:
Warning: Access denied for user: 'usrphplist@localhost' (Using password: YES) in /home/sites/site29/web/lists/admin/mysql.inc on line 7

Warning: Supplied argument is not a valid MySQL-Link resource in /home/sites/site29/web/lists/admin/mysql.inc on line 8

Warning: Supplied argument is not a valid MySQL-Link resource in /home/sites/site29/web/lists/admin/mysql.inc on line 18 Cannot connect to Database, please check your configuration

the original script has this text in it.

# select the database module to use
$database_module = "mysql.inc";
# select the language module to use
# at the moment we have german, italian, italian2 (quite different, but I don't speak italian) danish, dutch
$language_module = "english.inc";

# if you want more trouble, make this 63 (very unlikely you'll like the result)
#$error_level = error_reporting(0);

any ideas? I've granted permission to the user for the database and they should be able to do everything with the mysql file, but appears not to like it.

New at the whole mysql thing...
Sean

sjau
02-26-2002, 05:41 PM
well, did you alter the mysql.inc file and add you MYSQL_USERNAME, MYSQL_PASSWORD, MYSQL_SERVER (mostly "localhost") and MYSQL_DATABASE?

It seems those four variables are not quite correct in the mysql.inc file.

I can't really tell you what the variables are named in that specific inc file, maybe you want to post it here?

SeanC
02-26-2002, 06:19 PM
I'm sensing it a user name / password issue. when I use my "master" password in the script, it works fine, but when I use phpmyadmin to add a user (and give them permission to do everything with that db) it doesn't work.

is there some trick with phpmyadmin to add a user with password and get it to work?

thanks!
Sean

sjau
02-26-2002, 06:57 PM
well, my host only lets add users to mysql-dbs by using h-sphere control panel, same with creation of databases. no error message appears but nothing is being altered.

iseletsk
02-26-2002, 11:37 PM
You have to modify mysql.inc to match user/password that you created for mysql database.
The host name, will probably be mysql.yourdomain.com, and the database name - the one you created.
Make sure you set the user to have admin rights for the database.

You should be able to get most info from following screens in your control panel:
http://www.psoft.net/HSdocumentation/user/mysql_support.html#editsettings
http://www.psoft.net/HSdocumentation/user/mysql_support.html#userprivileges