php/mysql

Anon

ok, so sorry for the sql question, but i cant find another forum...
allright, so i am a beginner with some very basic questions...

I installed and set up mysql, but everything i read, talks about using ms-dos or something to use it. It looks the interface i have for mysql has all those options, or no??? Is whatever I will want to do not possible within that interface?

I am confused on how to allow permissions to a file on my remote server. Is 'localhost' only for my local machine? How do I set permissions on a file on a remote server, or am i missing something? I have read everything i can find, and nothing seems to make this clear.

These are very basic , I know, but whomever could take the time to explain how to get this all started, I would GREATLY appreciate it!!! I have scripts waiting to be played with!

Thanks so much!
Mac

Anon

You don't need DOS to do anything for you. I've made an installation on my private pc of Apache, PHP and MySQL (Windows98). Assuming your php.ini and httpd.conf files are correctly set up, you can use 'localhost' as your server. I've included the lines below as an example. They work.
I can then develop the scripts on my local machine and test them using 'http://127.0.0.1 'or 'http://localhost' in any browser and avoid spending hours on the Internet wasting money testing.
Both server and database are called 'user1065' because this is my user name on the remote machine but it works just as well at home where, I believe, no user name is necessary.

Permissions? Not needed as far as my experience goes. For Linux/unix system, sure. (That's how Linux avoids getting hit by viruses).

If you can get phpMyAdmin going, you've come a long way. And if your question had been a bit more specific...

Good luck!
Allan :-)

$server = mysql_pconnect("localhost", "user1065", "") or die ("Ingen adgang til serveren.");
$kontakt = mysql_select_db("user1065",$server) or die ("Ingen adgang til databasen.");
$query = "SELECT * FROM kalender WHERE dato >= '$idag' ORDER BY dato ASC LIMIT 0, 6";
$resultat = mysql_query($query);

...etc...

sepodati

You can use DOS to interface with MySQL. You can log in to the server and add users, create databases, etc...anything you want. Once you create a user, you can then use this user in your PHP scripts to log into MySQL and display data...

Go to a dos prompt, navigate to the mysql/bin directory.

start mysql by using 'mysqld'

log into mysql using 'mysql -uroot'

from there you create databases and issue queries. You'll want to read up in the manual on how to assign a password to your root user, to prevent unauthorized access, of course.

If there are any other specific questions, just ask...

www.devshed.com has a mysql forum that is very helpful, and there is a database forum here on phpbuilder where you might get better answers to database only type questions...

---John Holmes...