RE: [PHP-DB] Grant statement
>Subject: [PHP-DB] Grant statement > > >GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP > ON database_name.* > TO username@localhost > IDENTIFIED BY 'password'; > > > do i write this is my php file??? >and is this its right syntax just put it like this??as i know i >put like this when using the command line..but in my php file!!i >don't know. >my host created the databse for me and gave me a username and >password i used them in my scripts...do i still have to use GRANT??? You would need to use the GRANT statement *only* if you wanted to give access another user. And you're only able to use the GRANT *if* your host/provider has given you permission to do so using your current username/password. Basically, if you're able to access your database right now, then there's nothing you need to do. regards -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- 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] Grant statement
no, if all you wan the user to do is to read/write data -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 5:03 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Grant statement GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON database_name.* TO username@localhost IDENTIFIED BY 'password'; do i write this is my php file??? and is this its right syntax just put it like this??as i know i put like this when using the command line..but in my php file!!i don't know. my host created the databse for me and gave me a username and password i used them in my scripts...do i still have to use GRANT??? -- 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] Grant statement
yes, you do. Set-up a generic account, with password, for all users. Then use it in the mysql_connect() statement. You need to set-up this account only once; not when accessing the database each time. -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 7:38 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Grant statement do i need to write thr Grant statement to allow users to a have access to database(mysql)? -- 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]