DropBox Posted August 23, 2010 Share Posted August 23, 2010 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 Link to comment Share on other sites More sharing options...
Wizard Posted August 24, 2010 Share Posted August 24, 2010 The host is "localhost", also make sure that you've created the db and the user. Link to comment Share on other sites More sharing options...
DeatheR Posted August 29, 2010 Share Posted August 29, 2010 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? Link to comment Share on other sites More sharing options...
Wizard Posted August 29, 2010 Share Posted August 29, 2010 Try stevie.heliohost.org. Link to comment Share on other sites More sharing options...
ashleigh Posted September 18, 2010 Share Posted September 18, 2010 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 Link to comment Share on other sites More sharing options...
Gordon Posted September 29, 2010 Share Posted September 29, 2010 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 Link to comment Share on other sites More sharing options...
Wizard Posted September 29, 2010 Share Posted September 29, 2010 Escalated. Am I missing a port number or something? I thought it was stevie.heliohost.org. Link to comment Share on other sites More sharing options...
Ashoat Posted September 29, 2010 Share Posted September 29, 2010 Are we talking about remote access to the MySQL database, or local access? Link to comment Share on other sites More sharing options...
pajn Posted September 29, 2010 Share Posted September 29, 2010 For DeatheR, ashleigh, Gordon and me it's remote access. But for TS (DropBox) i don't know. Link to comment Share on other sites More sharing options...
Ashoat Posted September 29, 2010 Share Posted September 29, 2010 Have you guys configured "Remote MySQL" from your cPanel? Link to comment Share on other sites More sharing options...
Gordon Posted October 1, 2010 Share Posted October 1, 2010 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? Link to comment Share on other sites More sharing options...
Guest Geoff Posted October 1, 2010 Share Posted October 1, 2010 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) Link to comment Share on other sites More sharing options...
Gordon Posted October 1, 2010 Share Posted October 1, 2010 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. Link to comment Share on other sites More sharing options...
Ashoat Posted October 8, 2010 Share Posted October 8, 2010 Glad everything worked out Link to comment Share on other sites More sharing options...
Recommended Posts