Debian :: Can't Login To MySQL - Plugin Unix Socket Is Not Loaded

Jul 23, 2015

I just switched form MySQL to MariaDB for my WordPress website which is run with Apache, but I had a little problem logging in. So, I backed up all of my databases, deleted all of MySQL's configuration files, and reinstalled MariaDB. However, now I'm completely unable to login to MariaDB.

Whenever I try to, it says: ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded.

Also, why didn't MariaDB ask me to set up a password during the installation process like MySQL does?

View 8 Replies


OpenSUSE Install :: MySQL Socket Change For 11.2 / Get The Socket To /var/run/mysql?

May 25, 2010

In looking at the release notes, I saw the comment File locations changes:

* MySQL socket file and pid file were moved from /var/lib/mysql to more reasonable location /var/run/mysql by default.

* MySQL log files are in /var/log/mysql. Not sure what I was supposed to do with that information. So I ignored it. Now, I am finding some issues with it. The web server works, but any connection to the database fails with 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)The thought dawned on me that maybe all my databases were erased and none set up. Going in to the terminal, I could connect and list and query the databases. So even though I backed them up, they still are there!

phpMyAdmin gives the same error message.

However, when I go into MySQL Administrator, it works fine.

I forgot where I saw it, but the socket is still set to var/lib/mysql. I could not find any mysql install log and would say what was in my, but it still doesn't exist just as it has not in the past. Not sure if I should allow the MySQL Administrator to create it since I always ignored the prompt in the past and it worked. (Just wishing to keep the defaults)

At first I thought the upgrade upgraded the MySQL, but it's still 5.1.39 as I believe before. I've un-installed mysql-server and re-installed it with no change.

Can anyone can tell me how to get the socket to /var/run/mysql or what else is wrong? I read one place where mysql is supposed to set it up.

View 9 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:

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


View 6 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.


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

View 9 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:


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.


View 4 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

Networking :: Kill/disconnect Unix Domain Socket?

Jan 5, 2010

I have described my issue in detail here: [URL] basically, I am having a mysql server which keeps piling up on it's unix domain socket connections.

here's a small example of netstat as it looks now (count about 80-100 connections paired with httpd):

Active UNIX domain sockets (servers and established)
Proto RefCnt Flags Type State I-Node PID/Program name Path
unix 2 [ ACC ] STREAM LISTENING 3521428 12429/mysqld /tmp/mysql.sock


This is indeed a mysql server issue as far as I managed to debug it but until a workaround/fix is found I need to have my server responsive and the first idea that comes to my mind is to somehow kill those stray connections. as described in the mysql topic mentioend above, killing from mysql will not work. I need to kill them from outside mysql. I have setup a crontab script to kill and restart the mysql server when it cannot connect and it runs every 5 min. however this only lead to mysql being down sooner rather than later because in many cases just kill -9 and then service start mysql does not do the job (it's either part of the same issue of mysql or another issue). basically I need to manually kill mysqld instances a bunch of times until it's ok, OR, if that doesn't work, stop everything that is using mysql, wait a few minutes, and then start mysql. so I ditched that script and now I am manually restarting mysql server every ~ 24 hours.

so basically it's a pain. if I were to kill the stray connections however, I will not have to bother every day with restarting mysql.

View 2 Replies View Related

Programming :: Receiving Wrong Data On Winsock From Unix Socket

Jan 28, 2011

currently I've got a big problem on programming with sockets. I use the winsock2 API and want to receive data from a multicast adress running on a UNIX-PC. The connection works fine and I really receive data from this group, but as it seems not the right packages. The received data is saved in a char[]. E.g. at received_msg[12] is a float value. This one I would like to read out, convert and use it in later progress the next value is y at received_msg[16]. The same Code works on a Unix PC with unix sockets but converted to winsock I've got the described problem and I have to make this code work under windows.

Here a piece of the code (received_msg[12]='3f'):

Buffer is a struct containing the two float values x and y. If I convert the char as this under windows the value of x is a huge number. The correct value is around 192, so receveid_message[12] should be 1.92. Could it be that the Unix-PC is sending data in an other way than the winsock receive it?

View 2 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


View 1 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

Programming :: MYSQL Driver Is Not Loaded

Dec 25, 2010

I also the same problem, just that I can not proceed in the same way because I use Ubunto, what should I do to install the MySQL driver on my PC?

View 1 Replies View Related

Ubuntu :: 10.04: Can't Connect To MySQL Through Socket?

Dec 22, 2010

I am in the process of installing a genome brower on an ubuntu 10.04 (lucid). I achieved to see the browser once. Then, the mysql.sock disappeared and to solve this I tried first, to reboot the server with no results. Then I removed and reinstalled the MySQL server installing mysql-server-5.1. Now, I have a socket and MySQL is running (checked these out) but when I try to see the browser that is what I obtain:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

View 1 Replies View Related

Debian :: Login With Mail And Mysql Server?

Jun 9, 2010

I have machine which manages all mail accounts and their traffic and as well mysql database and some more stuff. Theres also windows server where users are managed and they get their programs from over rdp. I have login screen on Linux machine. It says Debian GNU/Linux 5.0. And I have root password, but I know that I have to login first with simple user account after which I can access login as root. But where can I get simple user account info. I need to manage mailaccounts mainly there.

View 3 Replies View Related

Server :: Export Unix Users To Mysql?

Jun 15, 2010

Anyway i have a very old Mandrake server where a previous owner hosted mailboxes on. This server is getting very slow and does alot of e-mail related tasks like:popsmtpmxIt runs on sendmail (which is also very outdated...) and it doesnt seem to respond to its config files. And the whole smtp and mx thing leaves us with some really weird mail problems...So i want to implement it in our current mail setup in which i have it all on seperate servers:2 smtp server (dns roundrobbing) (postfix)4 mx servers (1 etrn) (postfix)1 webmail server (v-webmail) (just apache and connects to the pop/imap server)And 1 pop/imap server (postfix, dovecot)I also want to implement smtp authentication because of all the mobile clients i have to host... This is where it gets tricky.

I want to export the unix user table of the old mandrake server and import that into a mysql database. This database will be used to authenticate the smtp users.I also want the export of the unix users to import it to the other pop/imap server so users can logon to that server instead of the crappy Mandrake server.I would expect that the export from unux users to mysql (including passwords) is the hardest part. I googled it, but some of the stuff i found didnt seem to be very reliable, so thats where you guys kick in :-). So is this possible? If so, how can i do it?I know i should go with some kind of ldap situation but that seems a way bigger hassle then this setup.

View 1 Replies View Related

Networking :: Mysql Cannot Connect Socket But Fine Through TCP/IP?

Jul 29, 2010

I'm using mysql server through tcp/ip with no problem. But I don't know since when I'm not able to connect through socket. There are lots of topics but my bad I couldn't find one works for me.

OS: Ubuntu 9.04
mysql 5.0.75-0ubuntu10.5



user = mysql
socket = /var/run/mysqld/mysqld.sock

/var/run/mysqld/mysqld.sock socket exists and has chmod 777

ERROR 2002 (HY000): Can't connect to local MySQL server through socket 'localhost' (2)

View 3 Replies View Related

Software :: How To Change Mysql Socket Path

Feb 23, 2010

i was tring to create a php daemon using system_daemon class. As i am in Lampp environment i get the problem that , system_daemon is is connecting to default mysql which i have stopped before starting lampp. i would like to know , how i can change its socket path to /opt/lampp/var... ? where i can make this path change?

View 1 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

#DESCR: 4GB RAM, InnoDB only, ACID, few connections, heavy queries


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/'.
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/ ended .....

View 2 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

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 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

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 When I ran the command


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

Ubuntu Security :: Login Password Requested After Desktop Is Loaded?

Oct 6, 2010

Lucid Lynx clean install.I do not seem to get the login screen from powerdown now. I do after logging off and logging back in again.From switched off, I get taken to my desktop and it is only a little while later, usually when starting Thunderbird or FireFox that I get asked for my password with this massagePlease Unlock The Login KeyringThe Login Keyring Did Not Get Unlocked When You Logged On

View 2 Replies View Related

Ubuntu :: ClamAV-clamd - Can't Connect To UNIX Socket /var/run/clamav/clamd.ctl

Apr 16, 2010

This started happening sometime yesterday afternoon on a server that's been trouble free for years.

My Ubuntu update is scheduled to run every month on the 5th, so this was roughly 10 days after that. So it seems to me it's not update related. The only thing I've done on the server lately is update a spamassassin rule which required an amavis restart. That was done earlier in the week.

I've already reviewed issues at [url] and all the conditions are correct for the more recent How to.

I can also confirm that, in fact, /var/run/clamav/clamd.ctl does not exist.

View 7 Replies View Related

Server :: Mysql Plugin Directory Vanished?

Dec 7, 2010

This server (running suse 11.1) was approaching a year of uptime when last night it became unresponsive @ max cpu and was given a hard reset. Suddenly mysql no longer works, it fails to secure a socket and shuts down. The error log says it can't load a bunch of stuff in /usr/lib/mysql/plugin/ because there's no such directory, then aborts after the unknown option --skip-federated. If I comment out skip-federated in /etc/my.cnf mysql will start, but users get access denied--I can't say if the same is true for root, I don't have root credentials for mysql.

This is all very funny because I need to finish/present my final project in a few hours and also happen to be the server admin, yet haven't been able to dig myself out of this hole, 5 hours has produced virtually no progress.

View 1 Replies View Related

General :: Mysql Query With Unix Timestamp Error "check The Syntax Near The Between"

Jun 28, 2010

Quote: select * from s_transaction Where between UNIX_TIMESTAMP('2010-06-28 15:40:00') and UNIX_TIMESTAMP('2010-06-28 16:00:00') and user_id = '15545941';

Is this the syntax correct to retrieve a particular user transaction between given time period? because "its return error check the syntax near the between"

View 3 Replies View Related

Copyrights 2005-15, All rights reserved