On Fri, 12 Aug 2005 15:06:44 +0200 Daniel Leidert <[EMAIL PROTECTED]> wrote:
Thanks for the reply. > > Last night I believe I upgraded mysql. Now whenever I try and use mysql, I > > get this error: > > > > > ~$ mysql > > > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > > > '/var/run/mysqld/mysqld.sock' (2) > > I had a similar problem. What does '/etc/init.d/mysql start' say? If it > does not start, then open your /etc/mysql/my.cnf and comment out > 'old_passwords' (mysql now fails with this option). Here is what '/etc/init.d/mysql start' says: > /var/lib/mysql/mysql# /etc/init.d/mysql start > Starting MySQL database server: mysqld...failed. > Please take a look at the syslog. > /usr/bin/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! I've posted what syslog says at the bottom of this email. > > I've tried reinstalling mysql-server-4.1, mysql-client-4.1, and > > libmysqlclient14, but nothing seems to work. I've looked through > > documentation, with nothing being said about a missing 'mysqld.sock' file. > > This normally means, that your mysql-server is not running. Which you are correct. It isn't running. :( > > My system is a PB G3 Firewire (Pismo) running Debian/Etch. Any help would be > > appreciated. > > If mysqld does not start, you should have a look at the syslog. I have now looked at the syslog. It's looking like /var/lib/mysql/mysql/user.frm is corrupt in some way. Again, I'm at a loss as to how to approach this problem. If someone could shed a little light on this for me, I'd really appreciate it... I've seen a few cases on Google where they said to run mysql_fix_privelege_tables, but I can't even get mysqld running, so everything I've tried results in the original error I posted... ************* PASTED ************* Aug 12 15:39:43 cora mysqld_safe[6844]: started Aug 12 15:39:44 cora mysqld[6847]: 050812 15:39:44 InnoDB: Database was not shut down normally! Aug 12 15:39:44 cora mysqld[6847]: InnoDB: Starting crash recovery. Aug 12 15:39:44 cora mysqld[6847]: InnoDB: Reading tablespace information from the .ibd files... Aug 12 15:39:44 cora mysqld[6847]: InnoDB: Restoring possible half-written data pages from the doublewrite Aug 12 15:39:44 cora mysqld[6847]: InnoDB: buffer... Aug 12 15:39:44 cora mysqld[6847]: 050812 15:39:44 InnoDB: Starting log scan based on checkpoint at Aug 12 15:39:44 cora mysqld[6847]: InnoDB: log sequence number 0 44158. Aug 12 15:39:44 cora mysqld[6847]: InnoDB: Doing recovery: scanned up to log sequence number 0 44204 Aug 12 15:39:44 cora mysqld[6847]: InnoDB: Last MySQL binlog file position 0 79, file name /var/log/mysql/mysql-bin.000233 Aug 12 15:39:44 cora mysqld[6847]: 050812 15:39:44 InnoDB: Flushing modified pages from the buffer pool... Aug 12 15:39:44 cora mysqld[6847]: 050812 15:39:44 InnoDB: Started; log sequence number 0 44204 Aug 12 15:39:44 cora mysqld[6847]: 050812 15:39:44 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/user.frm' Aug 12 15:39:44 cora mysqld[6847]: 050812 15:39:44 [ERROR] Fatal error: Can't open privilege tables: Incorrect information in file: './mysql/user.frm' Aug 12 15:39:44 cora mysqld_safe[6858]: ended Aug 12 15:39:50 cora /etc/init.d/mysql[6925]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Aug 12 15:39:50 cora /etc/init.d/mysql[6925]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Aug 12 15:39:50 cora /etc/init.d/mysql[6925]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Aug 12 15:39:50 cora /etc/init.d/mysql[6925]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Aug 12 15:39:50 cora /etc/init.d/mysql[6925]: ************* END PASTE ************* -M. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
