Re: Newbie Question: Creating database

Actually I think I'm beginning to understand it. In the Mysql database is a USER table. In that table contains all the users and privileges...is this correct? Is there anyway of specifiying a certain user to a certain database....that is only user A is allowed to access database B? Thanks again "Carl Campbell" <carlwc@yahoo.com> wrote in message news:BFEJLCDAKPPINKINOOECEEFMCDAA.carlwc@yahoo.com... > I think it will suit you well, to get (and install) the 'phpMyAdmin' > package. It will simplify the aspect of creating and maintaining the > database, while you learn the ins-and-outs of MySQL. > > You may want to invest some time in reading and learning the MySQL > documentation. Especially the part where the GRANT instruction is covered. > > In a nutshell, you want to: > > CREATE the database for your user. > GRANT the particular user, with rights over the database. > > Then, let him/her do with it as they please. > > > -----Original Message----- > > From: Jack Cazes [mailto:jack@dscope.com] > > Sent: Friday, January 04, 2002 10:53 AM > > To: php-windows@lists.php.net > > Subject: [PHP-WIN] Newbie Question: Creating database > > > > > > I have windows 2000 server with PHP 4.1.0 and Mysql. I'm not > > quite sure how > > PHP interelates with Mysql. Does PHP access Mysql directly? Or does it via > > the Windows ODBC. > > > > The reason why I am asking is because I have a user who wants a database > > created and wants to know the credentials to access the > > database...so I then > > used MyCC to create the database but there is no mention of username and > > password. > > > > Only if I create a FSN in the ODBC manager (by the way I loaded > > myodbc) does > > it ask for username and password...is this correct? > > > > Any help appreciated. > > > > > > > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > > For additional commands, e-mail: php-windows-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net >