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> 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.

-- 
Michel 'ZioBudda' Morelli                       michel@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@ziobuddalabs.it                   
						JABBER: michel@ziobuddalabs.it