Search

Sunday, January 22, 2012

Problem with MySQL - socket error

Problem : cant connect to mysql.
Error message : "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'"

Failed Attemps :
1. restart mysql service
2.
sudo mkdir /var/run/mysqld/
//Create the file by “touching” it.
sudo touch /var/run/mysqld/mysqld.sock
//Set the ownership of the mysqld.sock file and folder to mysql.
sudo chown -R mysql /var/run/mysqld/
source : http://anthologyoi.com/computers/cant-connect-to-local-mysql-server-through-socketerror.html

solution :
source : http://bikramkawan.com.np/error-2002-hy000-cant-connect-to-local-mysql-server-through-socket-varrunmysqldmysqld-sock-2/

Monday, January 16, 2012

SSH on Ubuntu

Location : ASEAN Foundation
Objective : set up SSH server on 192.1681.8, so it can be accessed from 10.0.0.126.

Process

check :
iptables configuration
file : /etc/ssh/ssh_config

Solution : use port 2222, not 22
#ssh localhost -p 2222

additional

Log in as root in ubuntu :
# sudo passwd