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@ziobuddalabs.it
> <mailto:
michel@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@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@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.
>
> --