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