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 >
