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?
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:
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
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)
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
I was playing with the mysql my.cnf file yesterday, trying to move my database files to my dropbox folder so I can use the database on my other machine. All I changed was the datadir setting to point to my dropbox folder. I also moved my mysql data files there.
When I tried to restart mysql and test the new location it said my mysqld.sock was missing. I searched and searched the web and my filing system for it but I have no idea what's happened to it?? I have even tried changing the datadir path back and reinstalling mysql but that doesn't seem to work either.
Since /etc/rc2.d/S19mysql does not exists anymore, and then init.d/mysql uses /sbin/start, I am unable to use mysql server anymore: me@mycomputer~#start mysql [ret] ...... for hours this command never returns so that ^C aborts...
me@mycomputer~#ps axw |grep mysql ( no results, no mysql!!! ) me@mycomputer~#stop mysql [ret] no returns either!!! This upstart [start|stop] thing seems a total failure for mysql!!!
I've created a mysql user and he can connect Joomla to mysqld when everyone has full permissions to the mysql homedir but I know this is bad from a security standpoint. If I set mysql user as the only one with permissions then I can't connect. I know Joomla support is not very help from past experience, wish I could dump it for something else but it does work great once it is configured so I need to keep it around, can anyone make a guess as to what permissions I need to have set on mysql's home dir so that joomla can still connect yet I am more secure than now?
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.
I have a droid phone, and I have ubuntu 9 running on it. This is done by chrooting since the phone runs a linux kernel. And it works... I have a question though. tightvncserver does work, and its able to listen on 127.0.0.1.. Its how you view your X session. So you chroot to Ubuntu, then start vncserver. Then switch back to android and login to ubuntu via vnc client. but apache, mysql, and postgresql do not work. Well. They dont seem too.. except for mysql. Mysql will start but only if you tell it not to use networking by saying skip-networking in my.cnf
Mysql says: mysqld cant create ip socket permission denied Apache2 says it can find 127.0.0.1 but doesnt actually run same with postgresql... All seem to be compiled with arm architecture. So why does tightvncwork? Why is it so special? How can it listen on the loop back (127.0.0.1) when nothing else can...
I have /proc and /dev bind to the chroot side. I can run ifconfig okay, and I can run /etc/init.d/networking start okay.. But apache2, mysql, etc have problems binding. I have removed apparmor even though technically its not running, but I removed it and its configuration files, just because I thought perhaps mysql looks at apparmor, but I doubted it.
i'm not the most knowlegable person but i have successfully installed mysql in the past. but now that i am attempting to install it again i'm getting this error during installation. has anyone seen this before?
mysql error: *Starting MySQL database server mysqld [fail] invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.0 (--configure): subprocess post-installation script returned error exit status 1
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
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:
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.
We have been struggling with a problem with the mysql-server package. This might be in the wrong category because our problems are with it on x86_64. Where the problem happens variables that should populate from the my.cnf don't, on other servers, they do, the my.cnf files are identical except for the server-id
The problem occurs on some of our machines but not others. All are using the mysql-server-5.0.45-7.el5.x86_64 The ones that work, when you connect with a client respond with server version 5.0.45-log source distribution The ones that don't work respond with 5.0.45 source distribution
It's unclear what the differences are between the two source versions and how we wind up with two different versions. One thing that might be involved, the mysql package is installed with both the i386 and x86_64
as soon as mysqld starts it goes 100% cpu. I can stop it, there is no mysql_safe running, and I ran mysqlcheck -A -a -c -o -g --auto-repair -u root -p all is ok, syslog shows nothing important but I can't login to any account with mysql client it just sits there, using php it times out. I don't know how to fix the urgent situation...
Looks like it has been started after a release update to 9.10 or 10.4 (i did it in a row) I don't know if this bug is related [URL]
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 ?!
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
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 .....
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.
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: 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: ^G/usr/bin/mysqladmin: connect to