[Solved] MySql Connect

[DropBox]

When i register on my site i have:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'doougs_mails'@'dooug.co.cc' (using password: YES) in /home/doougs/public_html/forms/email/process.php on line 29

[Wizard]

The host is "localhost", also make sure that you've created the db and the user.

[DeatheR]

but what would be my host externally? I mean I want to send data to my database from external resources. In that what what is my host name?

[Wizard]

Try stevie.heliohost.org.

[ashleigh]

I too am having the same problem. I'm writing a C# program which gets data from the MySQL database. so while I'm still writing it it is stored on my desktop but I still want to connect to the database so I can test as I code...how do I get it to recognise me as a valid user? i.e. stop adding my server name onto the end of the user?

 

Thanks

[Gordon]

Im struggling too, though i'm sure the solutions is easy once explained.

 

I am wanting to connect from Data Loader (though the process seems simular from Access 2007, which i can't get to connect either).

 

I am trying to connect to the SQL sever running on my heliohost account.

 

i am trying the following settings

 

Server : ballam.heliohost.org

Port : 3306

Username : (user created on the mysql wizzard at ballam.heliohost.org)

Password : (password for user created on the mysql wizzard at ballam.heliohost.org)

Database : (database created on the mysql wizzard at ballam.heliohost.org)

 

When i try to connect i get the error that is in the attachements.

 

I have checked the Windows Firewall, and made an exception for Data Loader

 

Now i suspect this could also be an issues with the SQL Driver, but hopefully someone can set me on the right path

 

[Wizard]

Escalated. Am I missing a port number or something? I thought it was stevie.heliohost.org.

[Ashoat]

Are we talking about remote access to the MySQL database, or local access?

[pajn]

For DeatheR, ashleigh, Gordon and me it's remote access. But for TS (DropBox) i don't know.

[Ashoat]

Have you guys configured "Remote MySQL" from your cPanel?

[Gordon]

Have you guys configured "Remote MySQL" from your cPanel?

 

I havent, my understanding is that is for other webservers to access the database.

 

Is it nesseccary to configure it if connecting from Access 2007 or a simular program?

[Guest Geoff]

Ok everyone here is the steps for dummies:

 

1. Go to your cpanel

2. Click on remote MySql

3. Put a '%' in the box (without the quotes)

4. Click Add Host

 

Done, sorry I did not post earlier, it would have saved djbob a lot of trouble.

 

 

Also here is the connection info:

 

Host:stevie.heliohost.org

Port:3306 (Which is the default port)

[Gordon]

Ok everyone here is the steps for dummies:

 

1. Go to your cpanel

2. Click on remote MySql

3. Put a '%' in the box (without the quotes)

4. Click Add Host

 

Done, sorry I did not post earlier, it would have saved djbob a lot of trouble.

 

 

Also here is the connection info:

 

Host:stevie.heliohost.org

Port:3306 (Which is the default port)

 

Thanks, one step closer to acheiving my dreams :-)

 

Just for clarification of other Dummies. Username and Password is you CPanel login, not useraccounts created under Cpanel.

 

Anyway, thats what worked for me.

 

[Ashoat]

Glad everything worked out