hello Christopher,
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)".
i even create /var/run/mysqld/mysqld.sock file and then restart mysql, but the mysqld.sock file disappear and get the same error.
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.
On Fri, Nov 5, 2010 at 3:24 AM, Christopher M. Jones <cjones@partialflow.com
wrote:
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@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 toan
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' Morellimichel@ziobuddalabs.it <mailto: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.netMSN:michel@ziobuddalabs.it MSN%3Amichel@ziobuddalabs.it mailto: michel@ziobuddalabs.it
JABBER:michel@ziobuddalabs.it JABBER%3Amichel@ziobuddalabs.it mailto: michel@ziobuddalabs.it
-- [ Drupal support list | http://lists.drupal.org/ ]