On Wednesday 22 of December 2010 10:29:43 Andrea Scarpino wrote: > > [r...@beruska ~]# mysql_upgrade > > Looking for 'mysql' as: mysql > > Looking for 'mysqlcheck' as: mysqlcheck > > Running 'mysqlcheck' with connection arguments: '--port=3306' '-- > > socket=/var/run/mysqld/mysqld.sock' '--port=3306' '-- > > socket=/var/run/mysqld/mysqld.sock' > > mysqlcheck: Got error: 2002: Can't connect to local MySQL server through > > socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect > > FATAL ERROR: Upgrade failed > > > > Any ideas? > > Is mysql running? It is not, mysqld doesn't know some option '--skip-locking' . Here's my debugging :
[r...@beruska ~]# ps aux | grep mysql
marek 27468 1.1 1.2 235992 24788 ? Sl 11:19 0:03
/usr/bin/mysqld --defaults-file=/home/marek/.local/share/akonadi//mysql.conf
--datadir /home/marek/.local/share/akonadi/db_data/ --
socket=/home/marek/.local/share/akonadi/db_misc/mysql.socket
root 27829 0.0 0.0 4284 828 pts/2 S+ 11:23 0:00 grep mysql
[r...@beruska ~]# /etc/rc.d/mysqld restart
:: Stopping MySQL Server
[FAIL]
:: Starting MySQL Server
[FAIL]
[r...@beruska ~]# vim /etc/rc.d/mysqld
I tried the commands manually to see output
[r...@beruska ~]# pgrep -u mysql mysqld
[r...@beruska ~]# /usr/bin/mysqld_safe --user=mysql
101222 11:26:35 mysqld_safe Logging to '/var/lib/mysql/beruska.err'.
101222 11:26:35 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
101222 11:26:37 mysqld_safe mysqld from pid file /var/lib/mysql/beruska.pid
ended
[r...@beruska ~]# /usr/bin/mysqladmin -uUNKNOWN_USER ping
/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!
[r...@beruska ~]# ls -l /var/run/mysqld/mysqld.sock
ls: cannot access /var/run/mysqld/mysqld.sock: No such file or directory
[r...@beruska ~]# tail -10 /var/lib/mysql/beruska.err
101222 11:26:36 InnoDB: highest supported file format is Barracuda.
101222 11:26:36 InnoDB: 1.1.4 started; log sequence number 1591525
101222 11:26:36 [ERROR] /usr/bin/mysqld: unknown option '--skip-locking'
101222 11:26:36 [ERROR] Aborting
101222 11:26:36 InnoDB: Starting shutdown...
101222 11:26:37 InnoDB: Shutdown completed; log sequence number 1591525
101222 11:26:37 [Note] /usr/bin/mysqld: Shutdown complete
101222 11:26:37 mysqld_safe mysqld from pid file /var/lib/mysql/beruska.pid
ended
Thanks, Marek
--
Marek Otahal :o)
signature.asc
Description: This is a digitally signed message part.
