[support] urgently need help for Site off-line error

[Christopher M. Jones]

The log is telling you that the users table doesn't exist. I don't know 
how you installed mysql, or what distro you are using. If you installed 
using a package management tool then an administrative user should have 
been created. Review your installation process and make sure that all 
the necessary databases and tables are there, including the one 
mentioned in your logs. If you're using apt / dpkg and friends on a 
debian system, then you might try something like

apt-get install --reinstall mysql-server

On 11/03/2010 07:56 PM, Qiubo Su (David Su) wrote:
> 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
> <mailto: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'  Morellimichel at ziobuddalabs.it  <mailto: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_budda
>     http://www.ziodrupal.net        			MSN:michel at ziobuddalabs.it  <mailto:michel at ziobuddalabs.it>
>     						JABBER:michel at ziobuddalabs.it  <mailto:michel at ziobuddalabs.it>
>
>