Date: Sun, 15 May 2005 21:49:28 +0200 From: "Chris Knipe" <savage@savage.za.org> To: <cheney@soc.umass.edu>, <freebsd-questions@freebsd.org> Subject: Re: can't connect to mysql Message-ID: <076501c55987$362fb380$0a01a8c0@ops.cenergynetworks.com> References: <20050515193710.GA20262@sociostat.org>
next in thread | previous in thread | raw e-mail | index | archive | help
vi /etc/rc.conf mysql_enable="YES" :wq /usr/local/etc/rc.d/mysql-server.sh start mysql and you should be fine. read what the port installation says the next time you install a port ;-) -- Chris. I love deadlines. I especially love the whooshing sound they make as they fly by..." - Douglas Adams, 'Hitchhiker's Guide to the Galaxy' ----- Original Message ----- From: "Eric Cheney" <cheney@soc.umass.edu> To: <freebsd-questions@freebsd.org> Sent: Sunday, May 15, 2005 9:37 PM Subject: can't connect to mysql > 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 > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?076501c55987$362fb380$0a01a8c0>