can't connect to mysql

Chris Knipe savage at savage.za.org
Sun May 15 12:49:35 PDT 2005


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 at soc.umass.edu>
To: <freebsd-questions at 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 at soc.umass.edu
>
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to 
> "freebsd-questions-unsubscribe at freebsd.org" 



More information about the freebsd-questions mailing list