|
|
|
|
![]() ![]() |
Jul 15 2005, 02:26 AM
Post
#1
|
|
|
Premium Member ![]() Group: Banned Posts: 160 Joined: 10-July 05 From: Bogotá, Colombia, South America. Member No.: 9,238 |
helo! hou do you? i need somebody post the data for acces my mysql database from my client. thanks a lot!
also i need the alter code for add a foreign key to a column on a table, thanks a lot This post has been edited by KuBi: Jul 15 2005, 06:00 AM |
|
|
|
Oct 8 2005, 03:05 PM
Post
#2
|
|
|
Newbie [Level 3] ![]() ![]() ![]() Group: Members Posts: 42 Joined: 8-October 05 From: Haarlem, The Netherlands Member No.: 12,672 |
So thats not how to connect to a mySQL server from your PHP scripts is it?
I recommend u use phpmyadmin (a tool you can probably find under domain.com/phpmyadmin , unless it is offcource not installed)... In that interface you can easily alter you table's ! |
|
|
|
Oct 9 2005, 03:03 AM
Post
#3
|
|
|
Privileged Member ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Members Posts: 874 Joined: 30-July 04 Member No.: 246 |
QUOTE("Kubi") Moved to the appropriate section. Don't put questions in the tutorial section please. I don't think this is the 'appropriate section'. Anyway... epox, it depends on what your 'client' is (by which I'm assuming you mean some form of application that requires MySQL database usage). I think you need to provide a little more detail before anyone can really help you. |
|
|
|
Nov 5 2005, 04:04 PM
Post
#4
|
|
|
Premium Member ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Members Posts: 162 Joined: 1-November 05 From: SATA II Member No.: 13,683 |
actually, you have't give any information about you client, it may need more to make other help you. anyway, following is some suggest :
QUOTE for windows desktop client like vb, vb.net, c++, delphi .. etc. you may download mysql odbc driver from mysql.com or click here. for php, thats already have driver bundle with it, go tutorial forum, there have a thread let you know how to do it. and, for the code about alter database table, you can refer to , or mysql mannu or here. - hope this help |
|
|
|
Nov 6 2005, 06:51 AM
Post
#5
|
|
|
Newbie [Level 2] ![]() ![]() Group: Members Posts: 25 Joined: 3-November 05 Member No.: 13,747 |
u can connect to urs sql database in two ways:
1)path the database as "Localhost" 2)or by using port,used where u wanna to connect to external mysql. suppose urs database is placed at www.mysql.com and the port is 3306.now in order to connect to database u enter the full sitename where urs database is placed alongwith the port in this way: PATH TO DATABASE: www.mysql.com:3306 |
|
|
|
![]() ![]() |
Similar Topics
|
Lo-Fi Version | Time is now: 25th July 2008 - 09:35 PM |