[vsurfer]

Eek a few questions:

1) Anyone know of a good tutorial for mysql + php ?

Something very hands-on to test a simple database on my Powerbook on which I'm using as a dev server with Apache.

php install seems fine, though mysql is giving some odd results:

eg:


1) vsurfer% ./bin/mysqladmin -u root -h Kota.local. password foobar
./bin/mysqladmin: connect to server at 'Kota.local.' failed
error: 'Host '10.0.1.xxx' is not allowed to connect to this MySQL server'

2)The mysql user that is already created in OSX - what's the deal with the password with this user since it was preset apparently?

Thanks in advance


----------------------
OSX 10.2.3
php 4.1.2

| pid_file | /usr/local/mysql-3.23.53/data/Kota.local..pid
| socket | /tmp/mysql.sock
| version | 3.23.53-entropy.ch

[vsurfer]

OK seem to be doing better...

mysql> SHOW DATABASES
-> ;
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.00 sec)

mysql> PROCESS
-> ;
ERROR 1064: You have an error in your SQL syntax near 'PROCESS' at line 1
mysql> SHOW FULL PROCESSLIST;
+----+------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+------+---------+------+-------+-----------------------+
| 8 | vsurf | localhost | test | Query | 0 | NULL | SHOW FULL PROCESSLIST |
+----+------+-----------+------+---------+------+-------+-----------------------+
1 row in set (0.00 sec)

mysql>

and

http://hotwired.lycos.com/webmonkey/...x2a_page2.html

is working out well as a php intro

http://www.programmingtutorials.com/tutorial.asp?id=SQL
is also helpful

May have answered fixed/my own questions! but sure to be back with more. But feel free to chip in!

Ta

[gorgonzola]

PHP and MySQL both have really good manuals that will show you how to do most things you need to do ... it's worth giving them a shot.

[Lucidwray]

I agree with gorgonzola. Both PHP and MySQL have outstanding documentation on their web sites.

http://www.php.net/docs.php

http://www.mysql.com/documentation/index.html

Start there, both of those sites have searchable documentation and user comments. I was able to teach my self with those 2 sites and this program. JaneBuilder 1.5 for PHP

http://www.seejanecode.com/

Janebuilder is killer for quickly creating SQL statements to do what you want. Its output is very simple and straightforward. I use Janebuilder to create basic pages that I can tear apart in Dreamweaver MX or BBedit and make them do more complex stuff.

Once you get into a little more indepth projects, check out DevShed.com. They have some awesome tutorials.

Have fun!