dear drupal support,<br><br>"/var/run/mysqld/" does exists. edit <b>/etc/mysql/my.cnf</b> file to have "bind-address" set to localhost and "socket" is set to /var/run/mysqld/mysqld.sock already.<br>
<br>but after run /etc/init.d/mysql start, still got below output<br><br>Rather than invoking init scripts through /etc/init.d, use the service(8)<br>utility, e.g. service mysql restart<br><br>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<br>
<br>mysql start/running<br><br>run mysql, still got below output as well<br><br>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)<br><br>tail -10f /var/log/mysql/error.log, still got the same error<br>
<br>101104 12:41:09 [Note] Plugin 'FEDERATED' is disabled.<br>101104 12:41:09 InnoDB: Started; log sequence number 0 44233<br>101104 12:41:09 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist<br>
<br>by the way, the server use dynamic IP address and the /etc/network/interfaces is as below<br><br>auto lo<br>iface lo inet loopback<br><br><br>
On Thu, Nov 4, 2010 at 12:11 PM, Michel Morelli <span dir="ltr"><<a href="mailto:michel@ziobuddalabs.it">michel@ziobuddalabs.it</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div text="#000000" bgcolor="#ffffff">
Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto:
<div class="im"><blockquote type="cite">hello drupal support team,<br>
<br>
thanks for your reply.<br>
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.<br>
<br>
root@quicksu-desktop:/var/www/sites/all/modules# /etc/init.d/mysql start<br>
<br>
Rather than invoking init scripts through /etc/init.d, use the
service(8)<br>
utility, e.g. service mysql start<br>
<br>
Since the script you are attempting to invoke has been converted to an<br>
<br>
Upstart job, you may also use the start(8) utility, e.g. start mysql<br>
start: Job is already running: mysql<br>
<br>
root@quicksu-desktop:/var/www/sites/all/modules# mysql<br>
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)<br>
</blockquote></div>
Hi, try to see if "/var/run/mysqld/" exist. <br>
Try to edit <b>/etc/mysql/my.cnf</b> file and see if "bind-address" is
set to localhost and if "socket" is set to /var/run/mysqld/mysqld.sock.<br>
<br>
M.<br>
<br>
<pre cols="72">--
Michel 'ZioBudda' Morelli <a href="mailto:michel@ziobuddalabs.it" target="_blank">michel@ziobuddalabs.it</a>
Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax)
Telefono: 0200619074
Telefono Cell: +39-3939890025 -- Fax: +39-0291390660
<a href="http://www.ziobudda.net" target="_blank">http://www.ziobudda.net</a> ICQ: 58351764
<a href="http://www.ziobuddalabs.it" target="_blank">http://www.ziobuddalabs.it</a> Skype: zio_budda
<a href="http://www.ziodrupal.net" target="_blank">http://www.ziodrupal.net</a> MSN: <a href="mailto:michel@ziobuddalabs.it" target="_blank">michel@ziobuddalabs.it</a>
JABBER: <a href="mailto:michel@ziobuddalabs.it" target="_blank">michel@ziobuddalabs.it</a>
</pre>
</div>
</blockquote></div><br>