Re: [PHP-DB] New users on mysql using php
On Friday 26 October 2001 05:29 am, Harpreet wrote: > 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. All the grants and access info are stored in the "mysql" database. You can manipulate it directly to grant whatever you want. For the details look in the manual. regards -- Jason Wong Gremlins Associates www.gremlins.com.hk -- 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]
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:[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]
Re: [PHP-DB] New users on mysql using php
go grab yourself a copy of phpmyadmin http://phpmyadmin.sourceforge.net/download.html jim - Original Message - From: "Harpreet" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 25, 2001 2:02 PM 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]
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]