July 13th, 2000, 10:20 PM
Ugh, sorry for posting 2 posts in one day, i must be annoying you guys =P But, since im new to PHP and all, i'm having a bit of trouble with mySQL. The server my website is on is hosted on a unix machine that my friend owns, and it has mySQL already installed onto it - but he has no idea how to work with it. Could anyone tell me how to create a database with mySQL? I thought it was created by a code, but i don't think that is the case.
I tried http://www.mysql.com but I'm not sure what to look under. installtion? creating? etc.
July 13th, 2000, 11:01 PM
Hmm nevermind...looks like he has something called pSQL on his server and not mySQL. Ah well...
[This message has been edited by jamnbryan (edited July 13, 2000).]
July 14th, 2000, 07:36 AM
well, first tell him to download mysql, it's free and works great with php.
the sql syntax for creating databases should be about the same, no matter what program your using. can you get command line access to the database? in mysql, you use
create database database_name;
July 14th, 2000, 12:42 PM
Another way to get easy MySQL-management and SQL-feel is to use phpMyAdmin from phpwizards.net
Just put the scripts in a seperate directory and edit the config.inc.php supplying your username and password and you should be in business.