Date: Mon, 23 Jun 2003 11:32:16 +0900 From: Joel Rees <joel@alpsgiken.gr.jp> To: Konrad Scorciapino <fallenbr@uol.com.br>, freebsd-questions@freebsd.org Subject: Re: Granting access on MySQL Message-ID: <20030623112512.2435.JOEL@alpsgiken.gr.jp> In-Reply-To: <20030622194538.141630d0.fallenbr@uol.com.br> References: <20030622194538.141630d0.fallenbr@uol.com.br>
next in thread | previous in thread | raw e-mail | index | archive | help
> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030623112512.2435.JOEL>