Wonderful info! Thanks. I never anticipated having mySQL on a box, having chosen Postgres to pursue. No personal antipathy, just so many Linux hours in the day.
Now I guess I need to pay attention. On Mon, May 14, 2007 3:42 pm, Paul G. Allen wrote: > First, I would suggest using the MySQL Administrator GUI for database > administration and the query tool for queries, unless you actually like > entering command line stuff and fighting with logins, etc. (personally, > I prefer the GUI when I want to get something done, instead of spending > my day typing commands and remembering command syntax for obscure > commands. The Administrator "User Administration" menu itme will show > you what users are configured in the DB engine and what privileges they > have. > > Second, the problem is most likely one of user privileges. A user in > MySQL has multiple logins and might have a different set of privileges > for each one. The default login is of the form [EMAIL PROTECTED], meaning > that the only machine that the user is allowed to login from is the > local machine. In order to allow logins from multiple machines, you need > to either use the wildcard (%) or set login privileges for the user for > each machine you want them to have access from. > > Now, the reason I say to use the GUI admin tool, is because the CLI > command for granting privileges can be tedious to type (unless you just > want to give the user access to everything). Using the GUI you get it > done before you can type the word GRANT. > > The GUI tools I mentioned are located here: > http://www.mysql.org/downloads/gui-tools/5.0.html > > Depending upon the Linux distro you have, you may already have them > installed. On my Fedora box, the Admin command is: > > /usr/bin/mysql-administrator > > > And the Query Browser command is: > > /usr/bin/mysql-query-browser > > > These tools also help with backups, fixing problems in the DB, etc. I > use them on nearly a daily basis during development. > > PGA > > On Mon, 2007-05-14 at 15:20 -0700, Lan Barnes wrote: >> I have a mySQL DB on a machine. It is supposed to serve across a >> network. >> I can log into it with >> >> mysql -u mythtv -p -h localhost mythconverg >> >> but not with >> >> mysql -u mythtv -p -h xena mythconverg >> >> No joy with xena's dotted quad. >> >> If I add xena to the loopback line in /etc/hosts as another nickname, it >> connects, but of course, doesn't really make it available across the >> network. >> >> I have tried putting >> >> bind_address=xena >> >> into /etc/my.cnf with various permutations such as bind-address, the IP >> address, and in various sections of the file. >> >> Any tips? >> >> TIA, >> >> -- >> Lan Barnes >> >> SCM Analyst Linux Guy >> Tcl/Tk Enthusiast Biodiesel Brewer >> >> > > > -- > [email protected] > http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list > -- Lan Barnes SCM Analyst Linux Guy Tcl/Tk Enthusiast Biodiesel Brewer -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
