Error2002 (hy000): Can't Connect To Local Mysql Server Through Socket '/var/run/mysql

Oh

Now I cannot connect to mysql on RHEL

I try:mysql --user=myuser--password=mydbpass mysql

and i get:

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

Sorry I have done this many times before but cannot get in on this server. If I
mysqladmin -u root -p status, it states:

Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

Cheers and sorry

PS /var/lib/mysql does not exist on my box

Hi everyone,
i tried to install mysql on my slackware 14.1.
typed mysql_install_db --user=mysql and went to the automatic configuration of secure access and receive this "Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)".
How can remove this installation, to try to reinstall the db?


And another error when try to reinstall :
"bash-4.2# mysql_install_db --user=mysql
Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
150130 9:40:11 [ERROR] mysqld: File '/var/lib/mysql/aria_log_control' not found (Errcode: 13)
150130 9:40:11 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/var/lib/mysql/aria_log_control'
150130 9:40:11 [ERROR] Plugin 'Aria' init function returned error.
150130 9:40:11 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
150130 9:40:11 [ERROR] mysqld: Can't find file: './mysql/db.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/db.frm' (errno: 13)
150130 9:40:11 [ERROR] Aborting

150130 9:40:11 [Note] /usr/libexec/mysqld: Shutdown complete


Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

shell> /scripts/mysql_install_db --defaults-file=~/.my.cnf

You can also try to start the mysqld daemon with:

shell> /usr/libexec/mysqld --skip-grant --general-log &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using
--general-log gives you a log in /var/lib/mysql that may be helpful.

The latest information about mysql_install_db is available at
http://kb.askmonty.org/v/installing-...sql_install_db.
MariaDB is hosted on launchpad; You can find the latest source and
email lists at http://launchpad.net/maria

Please check all of the above before mailing us! And remember, if
you do mail us, you should use the /usr/bin/mysqlbug script!
bash-4.2#
"

Hi all I installed redhat 9 in vmware and want to transfer file from redhat 9 to host win xp. I also make shared folder and I successfully transfer file from host to guest but I dont know transfer file from guest to host. please if someone know so tell me
Thanks

--
Abdul Wahab

Hey guys,

I have fedora version 8 with mysql 5.0.45 istalled. I have also installed drupal. Recently drupal gave me an error "error code 28". When i checked it out it seemed to be with the db. When i tried to created a db (for testing puposes) in root...i wasnt able to. so then i tried to restart mysql ...it stopped but unfortunately i have not been able to get mysql back up...i get a messeage saying
"Timeout error occurred trying to start MySql Daemon"

Could you please assist...

Thanks in advance,

Hi, I've just recently installed MySQL connector/c from source code on my Slackware 14.1 x64

I read the official instructions of the connector but I felt a bit disorientated when I read:
Code:

1 -Change location to the top-level directory of the source distribution.

I interpreted that I have to go to the "highest" directory Code:

/

So I wrote: Code:

 
        #                            cd /

root@- /#                            tar xzvf /home/normal/Downloads/mysql-connector-c-6.1.6-src.tar.gz 

root@- /#                            cd /mysql-connector-c-6.1.6-src/

root@- /mysql-connector-c-6.1.6-src# cmake -G "Unix Makefiles"

root@- /mysql-connector-c-6.1.6-src# make 

root@- /mysql-connector-c-6.1.6-src# make install

Then I did:
Code:

ln -s /usr/local/mysql-5.6.25/include /usr/include

But when I try to compile a program in c with #include <mysql.h> i get this error:
Code:

# gcc ctemp.c 
In file included from ctemp.c:2:0:
/usr/include/mysql.h:57:27: fatal error: mysql_version.h: No such file or directory
 #include "mysql_version.h"
                           ^

What can I do? Thanks a lot and sorry for poor english

PD: If you need the official instructions I paste here the link: https://dev.mysql.com/doc/connector-...on-source.html

I am novice at linux...I installed VMware work station and then install centos 6.4. Now I followed this tutorial to configure DHCP Server on my OS http://tecadmin.net/configuring-dhcp...centos-redhat/
but when start dhcp I see this : Starting dhcpd:[FAILED]
This is my /etc/dhcp/dhcpd.conf

option domain-name "center.local";
option domain-name-servers master.center.local;
default-lease-time 600;
max-lease-time 7200;
authoritative;
log-facility local7;
subnet 192.168.1.0 netmask 255.255.255.0 {
option routers 192.168.1.1;
option subnet-mask 255.255.255.0;
option domain-search "center.local";
option domain-name-servers 192.168.1.100;
option time-offset -18000; # Eastern Standard Time
range 192.168.1.100 192.168.1.120;
}

host station1 {
option host-name "centos-1.center.local";
hardware ethernet 00:11:1A:2B:3C:AB;
fixed-address 192.168.1.101;
}

so what is wrong?Any suggestion?
Thanks for your help and sorry for my bad English grammar

Hi,
I work in a company where job security isnt too great at the moment, so I'd like to learn new things, the main one being Linux.

Talking to a tech guy at work he says the best bet to replicate an office environment would be Red Hat, so I would like to install Red Hat Linux Enterprise V7 but am finding it difficult to find an open source website offering a free download for it.
Does anyone have a particular website they get their Linux from at all please?

Also, excuse this very ignorant question, but I'd like to set up a server within my Vmware Workstation 10 environment, plus 3 desktops - would that need Linux Red Hat server plus Linus Red Hat desktop software?

If the above has already been answered then I will happily follow a thread that you could point me too please instead?

Thanks in anticipation,
Clank

Hello Guys,

I set up a mail server in a LINUX environment using iRedMail.The users can only send and receive e-mail throughout the local network, not from the Internet. I would like to know the steps to follow for the configuration. Also i want the windows users to be able to send and receive e-mails through that mail server.
Thanks to help...

How to transfer the file from Windows to Linux server, while using below code I getting issue.

Command:- $ scp C:\Users\patil20\Desktop\NAV.1184.test112345.dat username@hostname:/u/spatil20/test.da

ERROR in Linux:- ssh: C: Name or service not known

thanks,
santosh

Hi,
my server centos 6 32bit, server config. 12core 16gb ram,only http and mysql(innodb).
promble: httpd service taking 90% cpu usage.
below is top command result and my.cnf conf..
some times site hangs.
any solution on this issue

top - 16:11:13 up 6 days, 5:38, 3 users, load average: 31.50, 30.64, 24.67
Tasks: 259 total, 35 running, 224 sleeping, 0 stopped, 0 zombie
Cpu(s): 61.2%us, 7.9%sy, 0.0%ni, 30.5%id, 0.2%wa, 0.1%hi, 0.1%si, 0.0%st
Mem: 15982704k total, 6111196k used, 9871508k free, 365788k buffers
Swap: 6291448k total, 0k used, 6291448k free, 2648472k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1500 apache 20 0 81188 55m 4660 R 47.7 0.4 3:53.51 httpd
1167 apache 20 0 80184 55m 4680 R 36.3 0.4 13:37.91 httpd
942 apache 20 0 86352 61m 4708 R 34.3 0.4 12:59.12 httpd
1157 apache 20 0 84272 59m 4704 R 34.3 0.4 13:04.18 httpd
1307 apache 20 0 86316 60m 4684 R 34.3 0.4 10:33.57 httpd
1363 apache 20 0 80164 55m 4676 R 34.3 0.4 7:07.59 httpd
1386 apache 20 0 86336 60m 4676 R 34.3 0.4 5:58.29 httpd
1620 apache 20 0 80164 54m 4660 R 34.3 0.3 3:01.97 httpd
937 apache 20 0 84084 59m 4712 R 32.4 0.4 13:04.31 httpd
1147 apache 20 0 84260 59m 4696 R 32.4 0.4 12:21.55 httpd
1158 apache 20 0 84084 60m 4688 R 32.4 0.4 12:39.18 httpd
1159 apache 20 0 84288 59m 4696 R 32.4 0.4 13:12.04 httpd

my.cnf conf. file
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
set-variable=max_allowed_packet=100M
set-variable=max_connections=500
set-variable=key_buffer_size=100M
#set-variable=key_buffer_size=64M
set-variable=sort_buffer_size=64M
#set-variable=innodb_buffer_pool_size=32M
set-variable=innodb_buffer_pool_size=1024M
#set-variable=innodb_buffer_pool_size=2048M
#set-variable=table_cache=1024
set-variable=table_cache=256
set-variable=thread_cache_size=16
set-variable=query_cache_size=16M
#set-variable=innodb_log_file_size=100MB
set-variable=interactive_timeout=60
set-variable=wait_timeout=60