Author Topic: MySQL access denied on login  (Read 2330 times)

cash

  • Posts: 2
    • View Profile
MySQL access denied on login
« on: June 01, 2004, 10:29:05 pm »
I am trying to set up Listmail - when I log onto
http://www.mysite.com/Listmail/login.php

I get this message:
Warning: mysql_connect(): Access denied for user: 'xxxxx_@localhost' (Using password: YES) in /home/xxxxx/public_html/Listmail/admin.php on line 2293
Could not connect to MySQL, host / user / pass = localhost / xxxxx_ / abcdefg
MySQL Error: Access denied for user: 'xxxxx_@localhost' (Using password: YES)

How can I gain access?
Thanks
Angie

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
MySQL access denied on login
« Reply #1 on: June 02, 2004, 08:08:11 am »
Looks like you need to enter the correct values into config.php.  Check out this help page for more details:

http://www.listmailpro.com/help/3.html

To order a full installation, please visit the link below:

http://listmailpro.com/support?t=install

Thanks for becoming an owner!
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

cash

  • Posts: 2
    • View Profile
access denied
« Reply #2 on: June 02, 2004, 10:30:30 am »
This is my config.php file

$sqlhost = 'localhost';

$sqluser = 'xxxxx_';
$sqlpass = 'abcdefg';
$sqldb = 'xxxxx_Listmail';

What's wrong with it?
Thanks
Angie

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
MySQL access denied on login
« Reply #3 on: June 02, 2004, 11:13:50 am »
You need to make sure that your web host has the database available at that hostname, username, password, and database.  This can usually be set up in your control panel.  If not, you'll have to talk to your host about the correct values to put in here.
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

laughingbird

  • Posts: 4
    • View Profile
    • http://www.thelogocreator.com
Re: access denied
« Reply #4 on: June 02, 2004, 03:01:07 pm »
Quote from: "cash"
This is my config.php file

$sqlhost = 'localhost';

$sqluser = 'xxxxx_';
$sqlpass = 'abcdefg';
$sqldb = 'xxxxx_Listmail';

What's wrong with it?
Thanks
Angie



Hi Angie.
I've successfully set up MailListPro (Dean, it's a TERRIFIC software package! I'm very happy with it).

I had no problems setting up MLP, however, I've been trying to set up another mySQL/PHP script that gave me the exact same error you've written about.

After a few hours, I simply went over it all with a fine tooth comb. I discovered I was using a hidden space when I set up my password! A simple typo.

Try not to use any strange characters like an underscore ( _ ), quotes or spaces.

And also, make sure you save your final config page as "config.php" and not "config.php.txt"

Just a thought!

- Marc Sylvester
Creator of The Logo Creator software
http://www.thelogocreator.com
Marc Sylvester
Creator of The Logo Creator Software
http://www.thelogocreator.com

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
MySQL access denied on login
« Reply #5 on: December 17, 2005, 04:00:30 am »
Adding to the new "FAQ":
---
It looks like a problem with your MySQL username, password, database, hostname, or any combination of the two.

Are you sure you have created a database, set up a username and password, and also (on some servers) added the user to have permission to the database?

Most hosts use "localhost" as the hostname, but your host could use something else. This could be mentioned in your hosting FAQ or your MySQL control panel / setup page.
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting