[mythtv-users] MySQL errors, mysqld.sock

[al]

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