[mythtv-users] MySQL errors, mysqld.sock

al philamythtv at gmail.com
Fri Jul 8 09:58:10 EDT 2005


That's it! I've got MySQL running now. Thanks for the links. That site
is one of the best MySQL how-to's I've seen.

On 7/8/05, Marc Tousignant <drayson at net1plus.com> wrote:
> I found your error here
> http://www.washington.edu/computing/web/publishing/mysql-install.html
> In this case, you have incorrectly specified the path to mysql.sock in your
> home directory. Look at step 9 and fix your ~/.my.cnf file
> http://www.washington.edu/computing/web/publishing/mysql-install.html#step9
> 
> I'm running gentoo as well.
> Here is the relavant section of my /etc/mysql/my.cnf
> pid-file        = /var/run/mysqld/mysqld.pid
> socket          = /var/run/mysqld/mysqld.sock
> log-error       = /var/log/mysql/mysqld.err
> 
> I checked my system and I do not have a /var/lib/mysqld folder which, unless
> you created one, I think your problem is. Mysql can not start because it can
> not create a file in a directory that does not exist.
> 
> > -----Original Message-----
> > From: mythtv-users-bounces at mythtv.org [mailto:mythtv-users-
> > bounces at mythtv.org] On Behalf Of al
> > Sent: Thursday, July 07, 2005 7:53 PM
> > To: Aaron Stewart
> > Cc: Discussion about mythtv
> > Subject: Re: [mythtv-users] MySQL errors, mysqld.sock
> >
> > I've tried the logs too. Applicable info:
> >
> > [mysql.err]
> >
> > 050706 07:03:48  mysqld started
> > 050706  7:03:48 Can't start server : Bind on unix socket: No such file
> > or directory
> > 050706  7:03:48 Do you already have another mysqld server running on
> > socket: /var/lib/mysqld/m$
> > 050706  7:03:48 Aborting
> >
> > 050706  7:03:48 /usr/sbin/mysqld: Shutdown Complete
> >
> > 050706 07:03:48  mysqld ended
> >
> > 050707 18:57:11  mysqld started
> > 050707 18:57:12  mysqld ended
> >
> > [mysql.log] - nothing
> >
> > [mysqld.err]
> >
> > 050706  6:57:05 /usr/sbin/mysqld: Shutdown Complete
> >
> > InnoDB: The first specified data file ./ibdata1 did not exist:
> > InnoDB: a new database to be created!
> > 050707 18:57:11  InnoDB: Setting file ./ibdata1 size to 10 MB
> > InnoDB: Database physically writes the file full: wait...
> > 050707 18:57:11  InnoDB: Log file ./ib_logfile0 did not exist: new to be
> > created
> > InnoDB: Setting log file ./ib_logfile0 size to 5 MB
> > InnoDB: Database physically writes the file full: wait...
> > 050707 18:57:11  InnoDB: Log file ./ib_logfile1 did not exist: new to be
> > created
> > InnoDB: Setting log file ./ib_logfile1 size to 5 MB
> > InnoDB: Database physically writes the file full: wait...
> > InnoDB: Doublewrite buffer not found: creating new
> > InnoDB: Doublewrite buffer created
> > InnoDB: Creating foreign key constraint system tables
> > InnoDB: Foreign key constraint system tables created
> > 050707 18:57:12  InnoDB: Started; log sequence number 0 0
> > 050707 18:57:12 [ERROR] Fatal error: Can't open privilege tables:
> > Table 'mysql.host' doesn't exist
> >
> > On 7/7/05, Aaron Stewart <acs at hourglassone.com> wrote:
> > > Look in /var/log/mysql/* and see if that points to problems.
> > >
> > > I've had a similar issue, but it was one of those things I just blew
> > > through without thinking about what it was, so I'm crossing my fingers
> > > that it's something simple.
> > >
> > > -=Aaron
> > >
> > > al wrote:
> > >
> > > >Long time reader, first time poster.
> > > >
> > > >Problem: MySQL no longer connects to the mysqld server.
> > > >
> > > >History: I setup a Knoppmyth frontend/backend system (see specs in
> > > >sig, rather vanilla setup) about a year ago. Recently I started over
> > > >from scratch on Gentoo to learn more about the system.
> > > >
> > > >After installing everything, I had a working MythTV frontend/backend
> > > >system. However, it took me a few weeks to get the IR blaster working.
> > > >The first time I tried MythTV after fixing the IR blaster, mythbackend
> > > >failed. I traced the problem back to MySQL. I could no longer connect
> > > >to the mysqld server or databases.
> > > >
> > > >I've read up on MySQL troubleshooting but have not found success with
> > > >the common suggestions. I have verified all permissions on the
> > > >applicable directories (/var/lib/mysql, /var/run/mysqld, etc). I have
> > > >a "mysql" user and "mysql" group. I do not have a mysqld.sock, which I
> > > >understand is created upon running the server. I can't create it. I
> > > >have verified that the mysqld.sock is not in /tmp. I've tried
> > > >unmerging/ re-emerging MySQL several times, even upgrading to MySQL
> > > >4.1.12.
> > > >
> > > >here is some applicable info about my problem:
> > > >
> > > ># mysqladmin -u root password new-password
> > > >mysqladmin: connect to server at 'localhost' failed
> > > >error: 'Can't connect to local MySQL server through socket
> > > >'/var/run/mysqld/mysqld.sock' (2)'
> > > >Check that mysqld is running and that the socket:
> > > >'/var/run/mysqld/mysqld.sock' exists!
> > > >
> > > ># ps aux | grep mysqld
> > > >root     28316  0.0  0.1   1484   436 pts/0    R+   19:03   0:00 grep
> > mysqld
> > > >
> > > ># mysqld_safe
> > > >Starting mysqld daemon with databases from /var/lib/mysql
> > > >STOPPING server from pid file /var/run/mysqld/mysqld.pid
> > > >050707 18:57:12  mysqld ended
> > > >
> > > >Can anyone help me? Since this is a new installation, I have no
> > > >database to save. I can destroy/create new databases as needed.
> > > >
> > > >TIA,
> > > >-Al
> > > >_______________________________________________
> > > >mythtv-users mailing list
> > > >mythtv-users at mythtv.org
> > > >http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> > > >
> > > >
> > >
> > >
> >
> >
> > --
> > Biostar M7NCG 400
> > AMD Athlon XP 2000
> > PVR 350
> > nVidia GeForce4 MX 440
> > S-vid out to SD TV
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 
> 


-- 
Biostar M7NCG 400
AMD Athlon XP 2000
PVR 350
nVidia GeForce4 MX 440
S-vid out to SD TV


More information about the mythtv-users mailing list