Ubuntu Servers :: Upgrading From Mysql5.1 To Mysql5.5 - Get An Error :2002 : Can't Connect To Local MySQL Server Through Socket ?

Apr 28, 2011

how to upgrade from mysql5.1 to mysql5.5 version. Pls guide me in briefly.I did upgrade with the help of this url

http://www.ovaistariq.net/490/a-step...-to-mysql-5-5/ but i got error like this error:2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed

In /etc/my.cnf , i didnt get like this. Is this is the error
user = mysql; socket = /var/run/mysqld/mysqld.sock; port = 3306; basedir = /usr/local/mysql; datadir = /usr/local/mysql/data; tmpdir = /tmp; log_error = /var/log/mysql/error.log

View 1 Replies


ADVERTISEMENT

Ubuntu Servers :: ERROR 2002 (HY000): Can't Connect To Local MySQL Through Socket

Apr 2, 2011

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). I've had this problem to the point where I thought I messed up my actual configuration so bad that I reinstalled Ubuntu to get rid of all the MySQL configuration; I ran MySQL through Windows with a breeze, but I'm getting some errors like that after restarting my computer just a few minutes ago and I have not changed anything in my SQL settings. I'm on Ubuntu 10.10 64 bit and running MySQL 5.1. the actual error that I get from Navicat and from the website is at [URL]... Update: 20110402. Connection for controluser as defined in your configuration failed. Just got that when I tried to log in to phpmyadmin.

View 4 Replies View Related

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

Jun 7, 2011

I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:

Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory

[Code]...

View 6 Replies View Related

Fedora :: MYSQL Error 2002 (HY000): Can't Connect To Local MySQL Server Through Socket?

Feb 22, 2011

I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.

Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.

Howver, just been trying to again to fix the problems with downgrading mysql and get:-

Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14

View 7 Replies View Related

Ubuntu Servers :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/run/mysqld/mysqld.sock' (2)

Feb 27, 2011

I'm the lead Dev of GnackTrack and we're having issues with running MySQL on the LiveDVD.Once installed everything works fine, mysql can be connected to but when using the liveDVD we get the following error:

Code:

root@root:~# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Contents of /etc/mysql/my.cf point to /var/run/mysqld/mysqld.sock but because this is a liveDVD the actual file is located in:
/rofs/var/run/mysqld/mysqld.sock

[code].....

View 4 Replies View Related

Ubuntu Security :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket

May 9, 2011

I have installed the mysql server on my ubuntu. I need to assign or reset the root password. I followed the article at http://www.ubuntugeek.com/reset-the-...-on-mysql.html. When I ran the command

[Code]....

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) what am i doing wrong, and explain to someone who almost has no experience with ubuntu. I am new to this.

View 1 Replies View Related

Server :: ERROR 2002 (HY0000): Can't Connect To Local MySQL Server Through Socket

Mar 28, 2010

Im getting this error when i try to run mysql from a shell

Code:
ERROR 2002 (HY0000): can't connect to local MySQL server through socket

I have installed MySQL over yum on fedora.

but the path and file /var/lib/mysql/mysql.sock does not exist on my system?

View 3 Replies View Related

Server :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket

Apr 11, 2010

I've tried /etc/init.d/mysql start, and it actually starts, or at least, it doesn't error out. But when I do pgrep mysql I get nothing, and when I try to login with mysql -p as root, I get

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

None of my other logins work, either, but since pgrep mysql didn't work, it's clear that MySQL just isn't running. I tried uninstalling and reinstalling mysql-server via apt-get, but I get the same thing. The logs in /var/log/syslog show this:

Apr 11 14:31:26 /etc/init.d/mysql[9774]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Apr 11 14:31:26 /etc/init.d/mysql[9774]: error: 'Can't connect to local MySQL server

[code].....

View 3 Replies View Related

Server :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysq

Apr 24, 2011

I have an e-mail production server that has been running fine for almost two years.

Notice mail was not serving today and login to a bunch of errors in messages

However, I think they are all from not being able to access MySQL and when I:

mysql -u root -p

I get:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

View 5 Replies View Related

General :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/run/mysqld/mysqld.sock' (2)

Feb 24, 2011

I need some help.Trying to set up bugzilla on my VM.After setting up the IP to use static i could log on to the url its not even loading up from command line its issueing an error.when i try to log on to mysql

bugzilla:~# mysql -u root mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

View 1 Replies View Related

Ubuntu Servers :: Error: 'Can't Connect To Local MySQL Server Through Socket '/var/run/mysqld/mysqld.sock' (2)

Apr 10, 2010

After the upgrade from 8.10 to 9.04, all was well. But after the upgrade from 9.04 to 9.10, I lost the MySQL server. Now, I recall during the upgrade, I was asked if I wanted to keep the existing my.cnf file or replace it with a newer one. I did as suggested and kept the original as I had edited it before. The same question was asked with a couple other config files. I kept the original in each case. After the first step, I checked the server was running and the websites were up, all was well. After the update to 9.10, when I checked the server, I get the following error:

Code: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Can anyone point me in the right direction to getting this resolved?

View 2 Replies View Related

OpenSUSE :: MySQL Error 2002 (HY000): Can't Connect To Local MySQL?

Dec 6, 2010

I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).

Error I receive is:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

View 6 Replies View Related

Red Hat :: Error 'Can't Connect To Local MySQL Server Through Socket'

Feb 28, 2011

when i tried the command mysql -u root it is giving me an error that "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(2)" although my mysql server is ruuning beacuse i m using XAMMP server and its inbuild mysql server is running i cannot use service mysqld start command beacuse this command try to start another instance of mysql and i required mysql of XAMMP.

View 3 Replies View Related

General :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)

Jun 2, 2010

i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error

[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.

[code]....

i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.

View 9 Replies View Related

Programming :: Error ""Can't Connect To Local MySQL Server Through Socket" In Connecting To MySQL In C Language

Sep 29, 2010

I wrote a code in C to connect to MySQL by using mysql_real_connect function but I recieved error "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" (by using mysql_error function).

I also did the following things: in mysql I typed 'SHOW VARIABLES LIKE '%SOCKET%'', it returned /var/lib/mysql/mysql.sock I typed 'mysql_config --socket' in shell, it returned /var/lib/mysql/mysql.sock I modified /etc/my.cnf file

View 3 Replies View Related

Software :: Connecting To Mysql Database - Can't Connect To Local MySQL Server Through Socket

Aug 25, 2010

I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:

Code:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.

Code:

View 4 Replies View Related

Red Hat / Fedora :: Can't Connect To Local MySQL Server Through Socket

Jul 4, 2010

I'm using fedora 13(x86_64).i got an error message while starting the mysql database software through the kernel. Code: [pradeep@localhost ~]$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [pradeep@localhost ~]$ this is the first time i'm using the mysql in linux environment. do i have to configure anything before using it for the first time ?!

View 5 Replies View Related

General :: Can't Connect To Local Mysql Server Through Socket?

Aug 8, 2011

i am new member for this forum, i am doing copy data from virtualbox A centos machine to virtualbox B centos machine.first step i use mysqldump database xxx > xxx.sqlthan send to B machine by scp xxx.sql @B machine IP /root.but come to third step, the xxx.sql need import to B machine mysql database,the error occur again:# can't connect to local mysql server through socket 'opt/lampp/lampp/mysql/mysql.socki really dun know how to solve it, use almost 3 hour cannot do solve it,but i use win scp check the folder, i found mysql.sock is no at the /opt/lampp/lampp/mysql/mysql.sock but at/opt/lampp/var/mysql/mysql.socpi dun know how to continue it, i hope those centos user help me to overcomethe issue. thank you very much!centos version 5.5, xampp version 1.4

View 3 Replies View Related

General :: Can't Connect To Local MySQL Server Through Socket

Jun 18, 2010

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

following my.cnf setting why this error is coming

#BEGIN CONFIG INFO
#DESCR: 4GB RAM, InnoDB only, ACID, few connections, heavy queries
#TYPE: SYSTEM
#END CONFIG INFO

[Code].....

View 8 Replies View Related

Software :: Cannot Connect To Local MySQL Server Through Socket

Apr 26, 2010

I some how installed mysql-5.1.46 (I believe I have installed) When I start mysql I am getting error:
[root@501 ~]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Then when I restart:
[root@501 ~]# /etc/init.d/mysql restart
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.

Then I tried to safe start mysql :
[root@501 ~]# mysqld_safe
100426 21:36:49 mysqld_safe Logging to '/usr/local/mysql/data/501.training.com.err'.
100426 21:36:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
100426 21:36:49 mysqld_safe mysqld from pid file /usr/local/mysql/data/501.training.com.pid ended .....

View 2 Replies View Related

CentOS 5 :: Cannot Connect To Local MySQL Server Through Socket

Apr 26, 2010

During the boot of CentOs I see this message which never stops scrolling during all the boot :
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

View 3 Replies View Related

Ubuntu Installation :: Cannot Connect To Local MySQL Server Through Socket

Apr 2, 2010

When I type mysql,
vignesh@vignesh:~$ mysql

I get this error.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

So, I checked whether the file mysqld.sock is there in its respective folder, but I could not find that file. How to create the file and start mysql server.

View 1 Replies View Related

Ubuntu :: Can't Connect To Local MySQL Server Through Socket / Make It Possible?

May 23, 2010

I'm pretty new to Linux and this is my first post here.

Whenever I try to connect to MySQL, I get the following message:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

It worked just fine the other day, then are I ran some updates and setup port forwarding to this computer [Ubuntu Server 10.04 LTS].

View 1 Replies View Related

Ubuntu Installation :: Cannot Start Mysql - "Can't Connect To Local MySQL Server Through Socket:"?

Mar 15, 2010

I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':

Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: ^G/usr/bin/mysqladmin: connect to

[code]....

View 1 Replies View Related

Ubuntu Servers :: Can't Connect To Local MySql Through Socket '/var/run/mysqld/mysqld.sock' (2)

Apr 18, 2011

installing mysql server manually. i have successfully installed mysql server but when i am try to create database, it shows error like this

ERROR 2002 (HY000): Can't connect to local MySql server through socket '/var/run/mysqld/mysqld.sock' (2)

** mysqld is not available in /var/run and error log file is also not available in /var/log **

View 5 Replies View Related

Server :: Can't Connect To Local MySql Server Through Socket '/var/run/mysqld/mysqld.sock' (2)

Apr 18, 2011

i have successfully installed mysql server but when i am try to create database, it shows error like this

ERROR 2002 (HY000): Can't connect to local MySql server through socket '/var/run/mysqld/mysqld.sock' (2)

** mysqld is not available in /var/run and error log file is also not available in /var/log **

View 4 Replies View Related

Ubuntu Servers :: #2002 Cannot Log In To MySQL Server

Feb 18, 2011

whenever i try to connect with phpmyadmin igot this error "#2002 Cannot log in to the MySQL server".how to recover this error?

View 6 Replies View Related

Fedora Servers :: Getting Error Message When Trying To Connect To Vncserver 'unable Connect To Socket: No Route To Host (113)'

Apr 26, 2011

I install and configure the vncserver following and reading 1000papers, but all of this present the same problem; when i try to connect to my vncserver,recive this mesage: unable connect to socket: No route to host (113) The OS version is Fedora Core 14 and tigervnc-server i try different solutions including:Allow TCP connection modifing files /etc/gdm/custom.conf and /usr/share/gdm/gdm.chemas Disable SELinux removing iptables Here follow the vncserver configuration:

[code].....

The ip address of the vncserver is correct because i can do ssh on it. Where or what can i do?

View 4 Replies View Related

Ubuntu :: Mysql Not Starting In 10.10 - ERROR 2002

Apr 9, 2011

i installed mysql 5.1, the workbench and glassfish along with netbeans for an application I plan to build using the java EE. Glassfish is on local host 8080 and when I installed mysql after that, trying to start mysql from command prompt or even connecting through the workbench gives me error. for example going through the terminal and just typing mysql gives me: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) what should I do so both servers can run at the same time when deploying my application? on windows this is all handled for me. but apparently thats not the case on ubuntu

View 2 Replies View Related

General :: Trying To Start MySQL - Error 2002

Jul 9, 2010

installed mysql
type
yum install mysql
tells me nothing to do - up to date

type mysql
responds ERROR 2002 - cant connect to local MYSQL server through socket
/var/lib/mysql/mysql.sock

Lost in tons of documentation - sun docs very general and maybe its there but I'm getting dizzy looking. How to get to the point where I can get an mysql> prompt?

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved