Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : PHP - MYsql installation

[akashik]

I need some advice.

Using a PHP script how do I set it to recognize the MYSql database? The initiate file wants to know where my database is, so any help would be wonderful. I looked at my control panel (Alabanza), and it says I have one named akashik_net. What would be the exact path I should add to the script for it to point at the file? Also from what I gather of the readme it will write it's own tables so I don't have to add these. Would that be correct?

Just learnt to install cgi and am jumping right into installing PHP so I don't mind the long answer *lol*

Thanks

Greg Moore
http://www.akashik.net

[kunal]

Start Long Answere -->

Well usually the path to the mysql database can be set to localhost.

Every program requires a different name or different properties for the tables it uses. Usually the program you are installing would create the tables.


<-- End Long Answere

Hope this helps

[4php]

I suggest heading over to devshed.com or webmonkey.com and going through their tutorials on php and MySQL. They are very good.

[alchiba]

I don't know what your script looks like, but there are usually five pieces of information needed to set up access to MySQL in a PHP script. This is usually stored in variables at the top of the script, but the basic info is:

Server Type ="mysql"
Server Name ="localhost" (literally, "localhost"
DB Username ="yourusername" (Alabanza domain username)
DB Password ="yourpassword" (Alabanza domain password)
Database Name ="akashik_net" (The database Alabanza created)

With an Alabanza MySQL setup, your DB Username and DB Password are the same as your CP login credentials.

You could post or email a code snippet of this part of your script and I can provide better details for you.

[akashik]

thanks all I'll have a poke around and see what happens *grin*

Greg Moore
http://www.akashik.net

[Jag]

You wouldnt set an absolute path to connect, use localhost as stated above or you can try using the server host name if its available to you.

[akashik]

Thanks all. I nailed it finally. Seems all was correct, just had to set the permissions on a folder. Got all excited about not having to do the cgi-shuffle with changing every file and overlooked a rather obvious section of the instructions. Remember when being a webdesigner was just about design?

Greg Moore
http://www.akashik.net

[alchiba]

LOL. I've always been a coder, so I know the Devil's in the details! :-)

[wirematter]

Sorry to bring this old thread back into the spotlight but how did you solve this problem? What folders did you set the permissions on?

My script asked for a 'Full Path To mysqldump' and 'Full Path To mysql'. I did a 'locate' in telnet but the script says it can't find it there.