> Thanks for the info... As it turns out, I am just a blithering idiot...
I
> didn't know that I had to create a separate user... As I said, that shows
> my newbieness...
Hey we don't always castrate blithering idiots here. Only those who
pretend not to be one.
> However, this has lead me to another question... The default database,
> "mysql," comes with a "users" file already... How do I create that in a
new
> database?? Or can I just copy the existing to a new database?
Mysql lets you create databases. Within each database, you create tables.
Databases contain tables, It is the tables which contain data. Use MyCC
(download from www.mysql.com) or some gui to help you set these up. Or
phpMyAdmin if you want browser based admin. Or simply c:\mysql\bin\mysql if
you like command line and sql commands.
Don't touch the database named 'mysql' and the tables in it. It is a
special database containing system tables. As you create databases, tables
and users, these will be updated automatically.
Once you have set up your databases and tables, use the GRANT command to
allow user access to the tables. If you are using php to access the
database and the database is on the same machine as the web server, you
grant a user privileges to a database on localhost and then use the
following command to connect.
<?
@ $db = mysql_connect("localhost", "username", "password");
mysql_select_db("databasename", $db) or die(mysql_errno() . ": " .
mysql_error() . "<br>");
?>
After connection, use php statements to construct your sql queries to
reference the data in the tables.
and you're away... (after a bit more reading in www.mysql.com and
www.php.net. )
Lots of tutorials on this. Use google to find them.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
