RE: [PHP-DB] New users on mysql using php

I do have root access and run the Grant command in Telnet. But what i want to do is have a web page called add_user.php. When the administartor adds a username and password i want that user to be granted all rights. I eman can i run the Grant statement in my php page and not on Telnet. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -----Original Message----- From: Rick Emery [mailto:remery@excel.com] Sent: Thursday, October 25, 2001 4:57 PM To: 'harpreet@crispincorp.com'; php-db@lists.php.net Subject: RE: [PHP-DB] New users on mysql using php Do you have root access to mysql? If so, then you can GRANT privileges to create new users. Otherwise, you have only the GRANT privileges delegated to you by the MySQL admin. -----Original Message----- From: Harpreet [mailto:harpreet@crispincorp.com] Sent: Thursday, October 25, 2001 4:03 PM To: php-db@lists.php.net Subject: [PHP-DB] New users on mysql using php I connect to mysql database using the following: $StrConnectionUser=mysql_connect(ipaddress,"$USER"); mysql_select_db(database name, $StrConnectionUser); My question is how can I add new users to mysql using the web interface. Like can i run the Grant and revoke (mysql commands) in my php page?? This way i can add or delete users that can have access to the mysql database through the web. I hope the above makes sense. Thanks, Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net