Preserved Topic: Mysql/SSH (Page 1 of 1)

Ok I have a problem I am working with a PHP script that uses MySql database I have created a new database and would like to create a table in the database, connecting to the database via SSH, do you have any commands that you could give me or perhaps a site that gives tutorials on commands for SSH? If you give me the command please tell me the command to open the Mysql database and from there how to create a table with in it.
Also what does it mean when you are getting a 404 on a php file?
Thanks
-YoYoFREAK

{edit} If I sound like I am an idiot, this is my first time doing Mysql database. sorry {/edit}

[This message has been edited by YoYoFREAK (edited 09-29-2001).]

Let me clarify some things first. SSH is not used to connect to MySQL database. SSH is used to connect to your Linux box (computer that is hosting your web site). It will allow you to use shell on your Linux box (the same as command prompt in Windows). When you're connected, you should use MySQL command line utilities to create databases and/or tables. Type "mysql --help" when you get to the shell for more information.

There's also another way how you can add tables. You should install phpMyAdmin on your web server and then you can use your web browser to administer MySQL.

When you get 404 error (no matter what file), it means that file doesn't exist (you didn't upload it).

I am getting a 404 on a .php page that I know I uploaded, and I am not typing a URL just opening the file directly from my webcontrol panel so I know I would not be typing in the URL incorrectly. I think it is probably isn't connecting to Mysql properly, unless you can think of something else but wouldn't I be getting a script error and not a 404?
Thanks Max for the reply.
-YoYoFREAK

"404 File Not Found" error message doesn't have anything to do with MySQL. Your script definitvely isn't uploaded or your web based control panel doesn't work correctly. Try to access your script directly by typing correct address in your web browser.

BTW When there are some problems with script, PHP will output error message(s) to web browser. Also, if script can't even start you'll get "500 Internal Server Error" error message...

This was not my mistake Mr. Max, I just called tech to get a few answers on my problem and they said the PHP engine hadn't been installed yet on the server so now I have my PHP support which would have been nice a little earlier, heh. Anyways I think I can figure it out now since the script is telling me where the errors are. Thanks for the help, I will be back if I have further trouble.
Thanks Mr. Max
-YoYoFREAK

YYF: You might want to instal PHP and MySQL on your computer so you can test these things offline - it'll save you time and (as you've seen) get around any problems your hosting may be having. I used Nusphere but there are others (see old threads here).

Emps

phpdev4 will install Apache/PHP4/ActivePerl/MySQL on Windows very easy...