PHP/MySQL help

Anyone know any complete beginners MYSQL help sites? I want to install ediweb or some other PHP back end (not nuke!), but, embarassignly, I haven't a clue how to do the pre-install. I don't even know if I have the right software! I've done a few SQL statements in the past, but only enough to pass "Interactive databases" at uni - not much!

Here's what the docs say to do:

STEP ONE: Pre-installation
#########################
(skip this if you have a working MySQL database access) :
setup a valid MySQL database and user access.
See your server administrator or ISP for this if you do not run or manage your own server. If you do run your own server or if you have administrator access, follow these steps
(tested on MySQL 3.23 on Linux), replacing database_name>, <database_user>, <database_password> and <database_host> with the apropriate values:

a) login on the server console or over a telnet session.
b) run mysql client as admin (usually root).
c) issue the SQL command : CREATE DATABASE <database_name>
d) issue the SQL command : USE <database_name>
e) issue the SQL command : GRANT ALL ON <database_name>.* TO <database_user>@<database_host> identified by '<database_password>'
f) exit mysql client
g) run as admin (usually root) : mysqladmin reload
h) test your new database access :
- run the mysql client as the new user
- issue the SQL command : USE <database_name>
You should have a reply from the server saying "database changed" or equivalent.

I don't think I'll be able to telnet to my cheap new gisol.com webspace, so wtf? Ediweb (or at least the bits I've ripped out of the zip file) looks pretty cool for a simple site, better than the hodgepodge of ASP and CGI that I usually use (I'm better at them!). Thanks in advance if you can point me in the right direction,
Steve

Have you tried SSH?

If not just download putty

the.earth.li/~sgtatham/pu.../putty.exe

and login with ip or host addy and select ssh.

having said that the instuctions youve given are for a root user, which wont do you... so, you can just do everything you mentioned through phpMyAdmin.

www.phpwizard.net/projects/phpMyAdmin/

<blockquote><strong><em>Quote:</em></strong><hr>(skip this if you have a working MySQL database access) :[/quote]

Actually you dont need to do any of that, as no doubt you have a working db. just add the tables in phpMyAdmin.

The account got activated this morning and yes, I do have PHPMyadmin. There's a load of other interesting stuff installed too - couple of chat engines, shopping cart, some nicer perl scripts than the free guestbook you usually get, half a dozen different traffic analysis scripts,

Oops, damn form submitted itself. Anyways... loads of stuff. The MYSQL databases aren't created but there is a really simple form for creating them and adding users, so I'll have a bash when I get time.
Does anyone know a simple PHP / CGI solution for just implementing a news page, 'cos that's all I really need.

Hi,

I'm quite happy with this script

www.cgi.veinotte.com/news...pdater.htm

in use on one of my sites.

Wonderful. Had a look, and that's just what I need. Pretty similar to what I used to use, but no doubt better coded. I'll have a play as soon as I can. No deleting, but that's not too tricky to either add myself or just do manually.
Chow for now,
Steve.