Re: installing MySQL with FreeBSD pkg_add
Peter Michaux wrote: # mysql -uroot ERROR 2002 (HY000): Can't connect to local MySQL server through socket 'tmp/mysql.sock' (2) What to do? The server isn't running. Start it, and this message will go away. If the port/package is correctly installed, then $ /usr/local/etc/rc.d/mysql-server.sh start as root should do the trick. To have mysql-server start automagically, add: mysql_enable="YES" to the file /etc/rc.conf BTW, shouldn't there be a space between the "-u" and the "root" ? Probably just a c-n-p error. KDK -- We are all in the gutter, but some of us are looking at the stars. -- Oscar Wilde ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
RE: installing MySQL with FreeBSD pkg_add
The pkg_add -r msql41-server auto installs mysql41-client as a dependaent so when you ran pkg_add -r mysql41-client it found it was all ready there just like it should. This is not an error. Next you have to do rehash command or reboot box so system can find those new modules. Then run mysql_install_db --user=mysql from the command line to tell mysql to create its internel control db. Then mysql -u root should work. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Peter Michaux Sent: Saturday, May 20, 2006 11:58 AM To: freebsd-questions@freebsd.org Subject: installing MySQL with FreeBSD pkg_add Hi, I am happy to have FreeBSD 6.1-RELEASE and KDE running on my intel box. I am now trying to install MySQL. I logged in as root and ran the following commands # pkg_add -r msql41-server Added group "mysql" Added user "mysql" # pkg_add -r mysql41-client "mysql-client-4.1.18_1" or its older version already installed # mysql -uroot ERROR 2002 (HY000): Can't connect to local MySQL server through socket 'tmp/mysql.sock' (2) What to do? Thanks, Peter ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]" ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: installing MySQL with FreeBSD pkg_add
Peter, cp /usr/local/share/my-small.cnf /var/db/mysql/my.cnf. Have a look at your new config in /var/db/mysql and make any necessary adjustments. There's some other configs in /usr/local/share so if you need something other than the small configuration file copy that one over. All depends on what you're doing with it. -John Peter Michaux wrote: Hi, I am happy to have FreeBSD 6.1-RELEASE and KDE running on my intel box. I am now trying to install MySQL. I logged in as root and ran the following commands # pkg_add -r msql41-server Added group "mysql" Added user "mysql" # pkg_add -r mysql41-client "mysql-client-4.1.18_1" or its older version already installed # mysql -uroot ERROR 2002 (HY000): Can't connect to local MySQL server through socket 'tmp/mysql.sock' (2) What to do? Thanks, Peter ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]" ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
installing MySQL with FreeBSD pkg_add
Hi, I am happy to have FreeBSD 6.1-RELEASE and KDE running on my intel box. I am now trying to install MySQL. I logged in as root and ran the following commands # pkg_add -r msql41-server Added group "mysql" Added user "mysql" # pkg_add -r mysql41-client "mysql-client-4.1.18_1" or its older version already installed # mysql -uroot ERROR 2002 (HY000): Can't connect to local MySQL server through socket 'tmp/mysql.sock' (2) What to do? Thanks, Peter ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"