-
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
-
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 :)
-
php mysql
I suggest heading over to devshed.com or webmonkey.com and going through their tutorials on php and MySQL. They are very good.
-
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.
-
thanks all :) I'll have a poke around and see what happens *grin*
Greg Moore
http://www.akashik.net
-
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.
-
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
-
LOL. I've always been a coder, so I know the Devil's in the details! :-)
-
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.