vacation-vallarta Posted August 16, 2012 Share Posted August 16, 2012 I use godaddy, and I am having a problem setting my database up with my PHP. I have attached both, can anybody help me fill in the PHP with my info, no matter what I do, I can not log on. Thank you in advance. if (!defined("IN_COMMENTICS")) { die("Access Denied."); } //ENTER DATABASE INFORMATION HERE***************************************************** $cmtx_mysql_database = 'vacationvallarta'; // The name of the database you created $cmtx_mysql_username = 'vacationvallarta@72.167.233.37'; // Your MySQL username $cmtx_mysql_password = '********'; // Your MySQL password $cmtx_mysql_host = 'localhost'; // Usually 'localhost'. Can also be an IP address. $cmtx_mysql_table_prefix = ''; // In most cases leave blank. //************************************************************************************ ?> Here is my Info on SQL database: vacationvallarta.db.8327489.hostedresource.com Server version: 5.0.92-log Server: vacationvallarta.db.8327489.hostedresource.com (50.63.105.30 via TCP/IP) User: vacationvallarta@72.167.233.37 MySQL charset: UTF-8 Unicode (utf8) Quote Link to comment https://forums.phpfreaks.com/topic/267153-help-having-sql-problem/ Share on other sites More sharing options...
Christian F. Posted August 16, 2012 Share Posted August 16, 2012 Can you post the code where you're trying to connect to the database, and what kind of error do you get? BTW: You'll want to change the username on that MySQL server, seeing as you posted the IP-address and username. Granted you did remove the password, but knowing that the server is publicly available means that attackers can (and probably will) try to brute force/guess/circumvent the password anyway. Quote Link to comment https://forums.phpfreaks.com/topic/267153-help-having-sql-problem/#findComment-1369768 Share on other sites More sharing options...
jazzman1 Posted August 16, 2012 Share Posted August 16, 2012 Don't public this information! Quote Link to comment https://forums.phpfreaks.com/topic/267153-help-having-sql-problem/#findComment-1369769 Share on other sites More sharing options...
vacation-vallarta Posted August 16, 2012 Author Share Posted August 16, 2012 Im going to change it once I know where and what needs to be inputed. Im getting the denied error. I just do not know what I need to input in the PHP to make sure it works. Quote Link to comment https://forums.phpfreaks.com/topic/267153-help-having-sql-problem/#findComment-1369773 Share on other sites More sharing options...
jazzman1 Posted August 16, 2012 Share Posted August 16, 2012 Are you able to connect to database server using any mysql client application? Quote Link to comment https://forums.phpfreaks.com/topic/267153-help-having-sql-problem/#findComment-1369784 Share on other sites More sharing options...
vacation-vallarta Posted August 16, 2012 Author Share Posted August 16, 2012 I have never tried. I would pay for someone to help me. I know it is easy. Quote Link to comment https://forums.phpfreaks.com/topic/267153-help-having-sql-problem/#findComment-1369793 Share on other sites More sharing options...
jazzman1 Posted August 16, 2012 Share Posted August 16, 2012 I have never tried. I would pay for someone to help me. I know it is easy. http://support.godaddy.com/help/article/3323/locating-your-mysql-database-connection-strings/?pc_split_value=4 Quote Link to comment https://forums.phpfreaks.com/topic/267153-help-having-sql-problem/#findComment-1369838 Share on other sites More sharing options...
Christian F. Posted August 16, 2012 Share Posted August 16, 2012 I've replied to you PM, vacation-vallarta. So I think we should be able to find a solution to this one. Quote Link to comment https://forums.phpfreaks.com/topic/267153-help-having-sql-problem/#findComment-1369876 Share on other sites More sharing options...
fenway Posted August 20, 2012 Share Posted August 20, 2012 I have never tried. I would pay for someone to help me. I know it is easy. If you want to pay, you've come to the wrong place. Quote Link to comment https://forums.phpfreaks.com/topic/267153-help-having-sql-problem/#findComment-1370977 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.