[support] urgently need help for Site off-line error
Qiubo Su (David Su)
qiubosu at gmail.com
Wed Nov 3 23:56:42 UTC 2010
dear drupal support,
"/var/run/mysqld/" does exists. edit */etc/mysql/my.cnf* file to have
"bind-address" set to localhost and "socket" is set to
/var/run/mysqld/mysqld.sock already.
but after run /etc/init.d/mysql start, still got below output
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the restart(8) utility, e.g. restart mysql
mysql start/running
run mysql, still got below output as well
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
tail -10f /var/log/mysql/error.log, still got the same error
101104 12:41:09 [Note] Plugin 'FEDERATED' is disabled.
101104 12:41:09 InnoDB: Started; log sequence number 0 44233
101104 12:41:09 [ERROR] Fatal error: Can't open and lock privilege tables:
Table 'mysql.user' doesn't exist
by the way, the server use dynamic IP address and the
/etc/network/interfaces is as below
auto lo
iface lo inet loopback
On Thu, Nov 4, 2010 at 12:11 PM, Michel Morelli <michel at ziobuddalabs.it>wrote:
> Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto:
>
> hello drupal support team,
>
> thanks for your reply.
> i tried /etc/init.d/mysql start and it is ok for the database, however,
> after i reboot the pc and run /etc/init.d/mysql start as below, it doesn't
> work again. thanks for your help with this again.
>
> root at quicksu-desktop:/var/www/sites/all/modules# /etc/init.d/mysql start
>
> Rather than invoking init scripts through /etc/init.d, use the service(8)
> utility, e.g. service mysql start
>
> Since the script you are attempting to invoke has been converted to an
>
> Upstart job, you may also use the start(8) utility, e.g. start mysql
> start: Job is already running: mysql
>
> root at quicksu-desktop:/var/www/sites/all/modules# mysql
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock' (2)
>
> Hi, try to see if "/var/run/mysqld/" exist.
> Try to edit */etc/mysql/my.cnf* file and see if "bind-address" is set to
> localhost and if "socket" is set to /var/run/mysqld/mysqld.sock.
>
> M.
>
> --
> Michel 'ZioBudda' Morelli michel at ziobuddalabs.it
> Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax)
> Telefono: 0200619074
> Telefono Cell: +39-3939890025 -- Fax: +39-0291390660
> http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_buddahttp://www.ziodrupal.net MSN: michel at ziobuddalabs.it
> JABBER: michel at ziobuddalabs.it
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20101104/62b07801/attachment.html
More information about the support
mailing list