<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Are you sure this isn't some kind of a firewall issue? A simple, but slightly dangerous, test would be to:<br><br> (1) Turn off the firewall<br> (2) Try to make your connection<br> (3) Regardless of the outcome of (2), immediately turn the firewall back on.<br><br>-- Mike<br></div><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><b><span style="font-weight: bold;">From:</span></b> Qiubo Su (David Su) <qiubosu@gmail.com><br><b><span style="font-weight: bold;">To:</span></b>
support@drupal.org; cjones@partialflow.com<br><b><span style="font-weight: bold;">Sent:</span></b> Thu, November 4, 2010 1:59:15 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [support] urgently need help for Site off-line error<br></font><br>
hello<span class="gI"><span class="ik"></span><span class="gD" style="color: rgb(204, 0, 96);"> Christopher,<br><br></span></span>i run apt-get install --reinstall mysql-server and start /etc/init.d/mysql start, but still got the same error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)".<br>
<br>i even create /var/run/mysqld/mysqld.sock file and then restart mysql, but the mysqld.sock file disappear and get the same error.<br><br>i got this problem when i finished install/configure drupal site and make it up and running, can browse the drupal site, loging from phpmyadmin, run /etc/init.d/mysql start without any issue, log to mysql from command line without any issue, then i restart the VM (use VM for this), then got the above problem.<br>
<br><br><br><div class="gmail_quote">On Fri, Nov 5, 2010 at 3:24 AM, Christopher M. Jones <span dir="ltr"><<a rel="nofollow" ymailto="mailto:cjones@partialflow.com" target="_blank" href="mailto:cjones@partialflow.com">cjones@partialflow.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
The log is telling you that the users table doesn't exist. I don't know<br>
how you installed mysql, or what distro you are using. If you installed<br>
using a package management tool then an administrative user should have<br>
been created. Review your installation process and make sure that all<br>
the necessary databases and tables are there, including the one<br>
mentioned in your logs. If you're using apt / dpkg and friends on a<br>
debian system, then you might try something like<br>
<br>
apt-get install --reinstall mysql-server<br>
<div class="im"><br>
On 11/03/2010 07:56 PM, Qiubo Su (David Su) wrote:<br>
> dear drupal support,<br>
><br>
> "/var/run/mysqld/" does exists. edit */etc/mysql/my.cnf* file to have<br>
> "bind-address" set to localhost and "socket" is set to<br>
> /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<br>
> 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<br>
> '/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<br>
> tables: Table 'mysql.user' doesn't exist<br>
><br>
> by the way, the server use dynamic IP address and the<br>
> /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 <<a rel="nofollow" ymailto="mailto:michel@ziobuddalabs.it" target="_blank" href="mailto:michel@ziobuddalabs.it">michel@ziobuddalabs.it</a><br>
</div><div class="im">> <mailto:<a rel="nofollow" ymailto="mailto:michel@ziobuddalabs.it" target="_blank" href="mailto:michel@ziobuddalabs.it">michel@ziobuddalabs.it</a>>> wrote:<br>
><br>
> Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto:<br>
>> 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,<br>
>> however, after i reboot the pc and run /etc/init.d/mysql start as<br>
>> 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<br>
>> start<br>
>><br>
>> Rather than invoking init scripts through /etc/init.d, use the<br>
>> 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<br>
>> socket '/var/run/mysqld/mysqld.sock' (2)<br>
> Hi, try to see if "/var/run/mysqld/" exist.<br>
> Try to edit */etc/mysql/my.cnf* file and see if "bind-address" is<br>
> set to localhost and if "socket" is set to /var/run/mysqld/mysqld.sock.<br>
><br>
> M.<br>
><br>
> --<br>
</div>> Michel'ZioBudda' <a rel="nofollow" ymailto="mailto:Morellimichel@ziobuddalabs.it" target="_blank" href="mailto:Morellimichel@ziobuddalabs.it">Morellimichel@ziobuddalabs.it</a> <mailto:<a rel="nofollow" ymailto="mailto:michel@ziobuddalabs.it" target="_blank" href="mailto:michel@ziobuddalabs.it">michel@ziobuddalabs.it</a>><br>
<div class="im">> Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax)<br>
> Telefono: 0200619074<br>
> Telefono Cell: +39-3939890025 -- Fax: +39-0291390660<br>
><br><span>
> <a target="_blank" href="http://www.ziobudda.net">http://www.ziobudda.net</a> ICQ: 58351764</span><br><span>
> <a target="_blank" href="http://www.ziobuddalabs.it">http://www.ziobuddalabs.it</a> Skype: zio_budda</span><br>
</div><span>> <a target="_blank" href="http://www.ziodrupal.net">http://www.ziodrupal.net</a> </span><a rel="nofollow" ymailto="mailto:MSN%3Amichel@ziobuddalabs.it" target="_blank" href="mailto:MSN%3Amichel@ziobuddalabs.it">MSN:michel@ziobuddalabs.it</a> <mailto:<a rel="nofollow" ymailto="mailto:michel@ziobuddalabs.it" target="_blank" href="mailto:michel@ziobuddalabs.it">michel@ziobuddalabs.it</a>><br>
> <a rel="nofollow" ymailto="mailto:JABBER%3Amichel@ziobuddalabs.it" target="_blank" href="mailto:JABBER%3Amichel@ziobuddalabs.it">JABBER:michel@ziobuddalabs.it</a> <mailto:<a rel="nofollow" ymailto="mailto:michel@ziobuddalabs.it" target="_blank" href="mailto:michel@ziobuddalabs.it">michel@ziobuddalabs.it</a>><br>
><br>
><br>
<font color="#888888">--<br>
</font><div><div></div><div class="h5"><span>[ Drupal support list | <a target="_blank" href="http://lists.drupal.org/">http://lists.drupal.org/</a> ]</span><br>
</div></div></blockquote></div><br>
</div></div></blockquote>
</div><br>
</body></html>