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