Thread: simple MYSQL connection

Hello
im trying to do a simple check up for a connection to my database through PHP script that looks like that :

<?php mysql_connect("74.86.118.24
", "user", "password") or die(mysql_error()); echo "Connected to MySQL<br />"; ?>

but it always answers :

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'dannydb '@'voda23.voda23.com' (using password: YES) in /home/rgajsgjb/public_html/test.php on line 5
Access denied for user 'dannydb '@'voda23.voda23.com' (using password: YES)

what didnt i do good ?

*the user that i interd is the one i created with ABVFP

my site is www.brasilwebdesign.com (the link in the center of the page)

thanks

Originally Posted by dannysheps********.com

Hello
im trying to do a simple check up for a connection to my database through PHP script that looks like that :

<?php mysql_connect("74.86.118.24
", "user", "password") or die(mysql_error()); echo "Connected to MySQL<br />"; ?>

but it always answers :

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'dannydb '@'voda23.voda23.com' (using password: YES) in /home/rgajsgjb/public_html/test.php on line 5
Access denied for user 'dannydb '@'voda23.voda23.com' (using password: YES)

what didnt i do good ?

*the user that i interd is the one i created with ABVFP

my site is www.brasilwebdesign.com (the link in the center of the page)

thanks

Hi Danny,
I am not sure why you would want to access your database from your page. Will you be a little more specific as to what you are trying to accomplish please?

in general
can i access my database with a script like that at all ?

or i can get access only from the Form way

hi
im trying to learn how to create a MYSQL PHP site
that i can let people post messages on the site , it will be more of a donate stuff site

so im trying to make the first step of quyering data from the database by connectiong to mysql

Originally Posted by dannysheps********.com

in general
can i access my database with a script like that at all ?

or i can get access only from the Form way

I am sure if you know how to set up scripts it may be possible but don't quote me on that.

You can always access your phpmyadmin on cpanel and it will be safer there than to try to access your database from your website

Originally Posted by dannysheps********.com

hi
im trying to learn how to create a MYSQL PHP site
that i can let people post messages on the site , it will be more of a donate stuff site

so im trying to make the first step of quyering data from the database by connectiong to mysql

Ok I understand. If you said you already set up a database using ABVFP then that is good enough right there. NavalDesign is the best to talk to about that.

is there a way to contact navaldesign ?

in general what is the password and user name i should inter ?

*i have one that i created for the ABVFP and the regular user name for the CP

Originally Posted by dannysheps********.com

is there a way to contact navaldesign ?

in general what is the password and user name i should inter ?

*i have one that i created for the ABVFP and the regular user name for the CP

Yes there is. You may go to his website at http://www.dbtechnosystems.com

You may also get your answers right there on his site. Contact him from there

The password and username is up to you. I couldn't answer that. When you go to cpanel and go to mysql database that part is left up to you what name you want your database to be as well as your username and password.

10x

Originally Posted by dannysheps********.com

10x

Is that how many times you've tried? Don't worry NavalDesign will get you in the right direction. Also check out this thread as to it may help you as well.

http://www.vodahost.com/vodatalk/mys...ating+database

hehehe

10=than x=ks

==

thanks

Originally Posted by dannysheps********.com

hehehe

10=than x=ks

==

thanks

lol gotcha, you are welcome. Did that thread help you?

no man
its not realy the same matter...

my thing is just to get a simple connection to the MYSQL thats it....nothing more

but seems to be impossible yet

Actually it's WO man lol but sorry if that wasn't any help to you

:)
sorry about that StrictlyBusiness

Originally Posted by dannysheps********.com

:)
sorry about that StrictlyBusiness

lol no worries Danny. I don't actually have a very femenine name lol. I am just sorry that I wasn't able to help you but I hope you hear from Naval soon or someone on the forum who knows how to assist you further.

i went to the link of naval's site and tried to submit a support form but they want there any fields that i realy dont know where to find that information

why they make it so dificult

Originally Posted by dannysheps********.com

i went to the link of naval's site and tried to submit a support form but they want there any fields that i realy dont know where to find that information

why they make it so dificult

Hi Danny,
There contact form isn't difficult at all. Go to the contact link. You provide him the information that is required "You will know which one is required by the red astericks" then let him know how urgent it is in priority then "How do you want to be contacted via email, phone, etc. You heard about him from VH Forum and then enter the verification letters and numbers and that is it. You don't have to worry about the upload part unless there is something you want him to look at.

anyone ?

Hey, Danny.

Here's an example database connection

Code:

<?
$path = "MYSQL SERVER PATH";
$dbusername = "USERNAME";
$dbpassword = "PASSWORD";
$dbname = "DATABASE NAME";
$conn = mysql_connect($path, $dbusername, $dbpassword);
mysql_select_db($dbname);
?>

10x
got it

How do I configure PHP scripts that must be hidden from public_html? I have two domains and want to save the index.php in the public_html but other .php files in not public directories.

You are not sufficiently clear.
Once you have published the index file in your public_html, the other files are not visible any more. If, anyway, you want to publish the other files elsewhere, just create another folder and publish them there.

If that is not what you wanted, please explain.