Re: Granting access on MySQL
> Hello, > I need to grant a user access to a database. How can I do it? > This is what I've tried: > mysql> grant all on databasename.* to username; > I got no error messages, but I after connecting as > the user, I couldn't use the database. Hi, Finally, don't forget to "flush privileges" or restart your mysql daemon after you granted permissions. Cheer, Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Granting access on MySQL
> Hello, > > I need to grant a user access to a database. How can I do it? > > This is what I've tried: > > mysql> grant all on databasename.* to username; > > I got no error messages, but I after connecting as the user, I couldn't use the > database. Connect as the (MySQL) root user and take a look at the "mysql" database. Note that passwords are assigned, not to just a user name, but to the combination of user and host. MySQL has their own mailing lists, with archives available at marc and other places, BTW. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Granting access on MySQL
Konrad, What errors did you get? Your GRANT command seems unusual. You would do something like: GRANT ALL ON databasename.* TO [EMAIL PROTECTED] IDENTIFIED BY "password" or GRANT ALL ON databasename.* TO [EMAIL PROTECTED] IDENTIFIED BY "password" The second is if you connect remotely. Obviously, the user has to exist before you do the GRANT. Also, it is not wise to do GRANT ALL on a database unless the user is going to be at superuser level. You do the GRANT at the table level. Say the table is account_info. You would do: GRANT ALL ON databasename.account_info TO [EMAIL PROTECTED] IDENTIFIED BY "password" If you don't want to do ALL, you can be specific: GRANT DELETE,INSERT,SELECT,UPDATE ON databasename.account_info TO [EMAIL PROTECTED] IDENTIFIED BY "password" If you still have trouble look at the tables in the mysql database, in particular, the db and user tables. -John On Sunday, June 22, 2003, at 06:45 PM, Konrad Scorciapino wrote: Hello, I need to grant a user access to a database. How can I do it? This is what I've tried: mysql> grant all on databasename.* to username; I got no error messages, but I after connecting as the user, I couldn't use the database. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]" John Von Essen ([EMAIL PROTECTED]) President, Essenz Consulting (www.essenz.com) Phone: (800) 248-1736 Fax: (800) 852-3387 ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Granting access on MySQL
Konrad Scorciapino wrote: > I need to grant a user access to a database. How can I do it? One thing to check is if you need to reload privileges. The mysql doc has lots of info on this. Another short term way to move fwd might be to install webmin or phpMyAdmin, both of which are available in freebsd ports. Tom McIntyre __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Granting access on MySQL
Hello, I need to grant a user access to a database. How can I do it? This is what I've tried: mysql> grant all on databasename.* to username; I got no error messages, but I after connecting as the user, I couldn't use the database. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"