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:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 4:57 PM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 4:03 PM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database 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]
