mysql question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



As mentioned here, you can use a GRANT statement from a mysql prompt, or
more directly manipulate the mysql.user table by INSERT INTO a new
record or UPDATE an existing record to create the appropriate access and
privileges.  See:
http://www.mysql.com/documentation/mysql/bychapter/

for lots of help on anything mySQL.  Use the search field for GRANT or
"users" or "privileges".

-- Hugh

On Sun, 13 Jul 2003, Hugh Esco wrote:

> In addition to the networking issues which look like editing, as root,
> /etc/hosts.allow and hosts.deny in Debian, once you get into mysql, you
> need to make sure that no firewall is denying connections on its port,
> usually 3306 or was it 5432, (as I recall?) , and you also have to, as the
> mysql user _root_, add records to the mysql.user table which define what
> users you will allow what access and privileges from what hosts at your
> mysql server.  Err on the side of caution and define access as narrowly as
> you can and still get the work done.
>
> -- Hugh
>
> On Sun, 13 Jul 2003, Alex Snow wrote:
>
> > Hi all.
> > How can I alow remote connections to my mysql server? I'm using mysql
> > 3.23.56 5that comes with slackware 9.0 and it seems that it is setup for
> > local connections only.
> >
> > _______________________________________________
> > Speakup mailing list
> > Speakup at braille.uwo.ca
> > http://speech.braille.uwo.ca/mailman/listinfo/speakup
> >
>
> _______________________________________________
> Speakup mailing list
> Speakup at braille.uwo.ca
> http://speech.braille.uwo.ca/mailman/listinfo/speakup
>




[Index of Archives]     [Linux for the Blind]     [Fedora Discussioin]     [Linux Kernel]     [Yosemite News]     [Big List of Linux Books]
  Powered by Linux