Topic awaiting preservation: stupid question of the day... (Page 1 of 1)

I know most of the basic commands for SQL and enough php to set up a basic page. However, how do you interact with a database on a webserver? I assume that most servers already have MySQL or something set up, but I haven't figured out how to set up tables and such on it to use on my webpages. I have downloaded mySQL onto my computer and can set up the tables I need on it. Is there a file or two or a directory that I need to upload to the server or something? Pretty much I have both ends of it figured out, just connecting the two concpets is where I'm missing something...

Any help would be much appreciated, thanks.

There's a couple of ways depending on your server and sysadmin setup

First you may have to check with your host to make sure you have the hostname of the mysql server (think of it kinda like a webserver) you also need a username and password with which to log on to the mysql server.

Now you have a couple of choices, the easiest one is to just download phpmyadmin and install that (it may already be installed, again check with your host) once that is installed it has a fairly easy to use interface which will allow you to create your tables without even using any SQL.

If for some reason that doesn't work, if you have telnet or ssh access to your server you could log on and use the commandline mysql application. Check the mysql documentation for more on that.

Finally make sure you have gone through all the php mysql part of the manual. (I know this is kinda an RTFM answer but for almost all things php the answer is there somewhere

What are you trying to do right now specifically?



.:[ Never resist a perfect moment ]:.

[This message has been edited by bitdamaged (edited 08-02-2002).]

Since I'm just now trying to learn this stuff too, I'll milk this topic as much as I can, as I'm sure to have a few of my own "stupid questions" on occasion

quote:

---

if you have telnet or ssh access to your server you could log on and use the commandline mysql application -- from bit's post

---

quote:

---

It's a common misconception that you use telnet to connect to a remote MySQL server. You can't.

To connect to the server, you need to use a client program written specifically for use with MySQL. -- from: http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_0_0

---

First one being, do these two quotes contradict each other, or is there some slight wording difference I'm not catching? I understand the difference between connecting and logging on (I think), (you have to connect before you can log on), or at least that makes some kind of sense at the moment...
Also, is the "commandline mysql application" the same thing as the "client program written specifically for use with mysql?"


And thanks a bunch for helping a couple 'newbies' bit.



[This message has been edited by Lord_Fukutoku (edited 08-03-2002).]

He's being nitpickity (he's technically correct just being nitpickety)

Usually the "mysql" client resides on the host machine which allows you to telnet in and run the host machine's instance of the mysql client. ( so you can do it via telnet )




.:[ Never resist a perfect moment ]:.

I'll also point out one obvious difference...

Bitdamaged said:

...if you have telnet or ssh access to your server you could log on and use the commandline mysql application...

It says access to your *server*, it doesn't say access to your *MySQL server*. So, that basically says they you should telnet / ssh to computer that's holding your web site (web host) and not MySQL itself...

All right, that makes sense, use telnet to connect to the computer that has MySQL on it and so forth...

The general ideas/concepts are easy to learn, it's just the slight details in getting it all to work together that can be a hassle

Thanks again bit and max.