[mythtv-users] Can only connect to mysql as localhost
lan at falleagle.net
Sun Aug 12 15:11:51 UTC 2007
Please know I am now trying to
1. delete all mythtv entries of privilege in mysql.user and
2. reenter one reasonable rule as described here
I'll report back.
On Sun, August 12, 2007 8:01 am, Lan Barnes wrote:
> Added both to the my.cnf in the FE/BE server, not the FE clients (I
> figured the "restart" instruction indicated that).
> Results interleaved
> On Sun, August 12, 2007 7:43 am, David Campbell wrote:
>> Lan Barnes wrote:
>> port = 3306 to /etc/my.cnf under [mysqld]
>> restart mysql
> Restarted but failed. This on the client:
> [lbarnes at gypsy ~]$ mysql -h xena -u mythtv -p mythconverg
> Enter password:
> ERROR 1045 (28000): Access denied for user 'mythtv'@'gypsy' (using
> password: YES)
> So the client (gypsy) is still looking for a local connection even though
> the "-h xena" flag is in the command and xena is in /etc/hosts (my home
> network is too small to justify DNS -- is that a problem here?).
> Remembering that one client box (hendriena) is connecting just fine, and
> the BE (xena) and another client (gypsy) are failing to connect to the IP
> address, I say again that I suspect the server mysqld is doing the right
> thing, but something about the config of these machines is telling client
> programs, local or distant, to go local only.
>> If that fails to amke the service available from the other server also
>> bind-address = mainipofserver
>> and restart again
> This just timed out on the restart and had to be commented out:
> [root at xena lbarnes]# /sbin/service mysqld restart
> Stopping MySQL: [ OK ]
> Timeout error occurred trying to start MySQL Daemon.
> Starting MySQL: [FAILED]
> Just to be complete, I'll try those lines in gypsy's my.cnf. FWIW, mysqld
> is not running on gypsy, so there can be no restart.
> Lan Barnes
> SCM Analyst Linux Guy
> Tcl/Tk Enthusiast Biodiesel Brewer
> mythtv-users mailing list
> mythtv-users at mythtv.org
SCM Analyst Linux Guy
Tcl/Tk Enthusiast Biodiesel Brewer
More information about the mythtv-users