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
