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" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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:[EMAIL PROTECTED]] > > Sent: Friday, January 04, 2002 10:53 AM > > To: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
