Date: Sun, 15 May 2005 15:37:11 -0400 From: Eric Cheney <cheney@soc.umass.edu> To: freebsd-questions@freebsd.org Subject: can't connect to mysql Message-ID: <20050515193710.GA20262@sociostat.org>
next in thread | raw e-mail | index | archive | help
Hello. I'm trying to get MySQL4.0 working. I've installed it using /stand/systinstall (as well as ports method on another attempt). I got a report from sysinstall that MySQL was installed. That's both the client and the server (it caught the dependencies.) But here's the problem: I can't connect to the database. Here's the error I get.... ****begin error message****** max# mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ****end error message****** I did the above leaving the password blank because I haven't set up a password for root on MySQL yet. Which brings up another problem. I've tried the below and get the stated message..... ****begin error message****** max# mysqladmin -u root password 'newpassword' mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! max# ****end error message****** Well sure enough, /tmp/mysql.sock does not exist. And a "ps waux | grep msyql" leaves me to believe that mysql is not running. So then I did this, as root .... max# /usr/local/etc/rc.d/mysql-server.sh start And still mysql is not running, and I get the same problems as stated above. Any ideas about what I'm doing wrong? Thank you. -- <Eric Cheney> cheney@soc.umass.edu
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050515193710.GA20262>