From: Nathan B. <Nat...@it...> - 2010-04-03 00:42:27
|
I've having trouble installing/running mysql - the instructions provided with the package (printed after installation) aren't working. Specifically, the instructions I got were: >To start mysqld at boot time you have to copy >support-files/mysql.server to the right place for your system > >PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! >To do so, start the server, then issue the following commands: >/sw/bin/mysqladmin -u root password 'new-password' >/sw/bin/mysqladmin -u root -h my-macs-name.local password 'new-password' >See the manual for more instructions. >You can start the MySQL daemon with: >cd /sw ; /sw/bin/mysqld_safe & > >You can test the MySQL daemon with mysql-test-run.pl >cd mysql-test ; perl mysql-test-run.pl > >Please report any problems with the /sw/bin/mysqlbug script! i) It isn't clear where support-files/mysql.server is - turns out it is in /sw/share/mysql (can't fink provide the full path?) ii) cd /sw ; /sw/bin/mysqld_safe & worked ii) /sw/bin/mysqladmin -u root password 'somepass' worked iii) /sw/bin/mysqladmin -u root -h my-macs-name.local password 'somepass' didn't, I got: /sw/bin/mysqladmin: connect to server at 'my-macs-name.local' failed error: 'Host 'xx.xx.xx.xx' is not allowed to connect to this MySQL server' iv) cd mysql-test ; perl mysql-test-run.pl - again, we have to find mysql-test in /sw/share/mysql/mysql-test, and then we get this error: /sw/share/mysql> cd mysql-test ; perl mysql-test-run.pl Logging: mysql-test-run.pl mysql-test-run: *** ERROR: Could not find any of /sw/share/client_release /sw/share/client_debug /sw/share/client/release/ /sw/share/client/debug/ /sw/share/client /sw/share/bin I have installed: i dbd-mysql-pm588 4.005-12 Perl5 Database Interface to MySQL i mysql-unified 5.0.45-2 Open Source SQL database i mysql-unified-client 5.0.45-2 Open Source SQL database - Client i mysql-unified-dev 5.0.45-2 Open Source SQL database - Development headers and libraries i mysql-unified-shlibs 5.0.45-2 Open Source SQL database - Shared libraries >Release: mysql-5.0.45 (Source distribution) >C compiler: i686-apple-darwin9-gcc-4.0.1 (GCC) 4.0.1 (Apple Inc. build 5465) >C++ compiler: i686-apple-darwin9-g++-4.0.1 (GCC) 4.0.1 (Apple Inc. build 5465) >Environment: <machine, os, target, libraries (multiple lines)> System: Darwin my-macs-name.local 9.8.0 Darwin Kernel Version 9.8.0: Wed Jul 15 16:55:01 PDT 2009; root:xnu-1228.15.4~1/RELEASE_I386 i386 Some paths: /usr/bin/perl /sw/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using built-in specs. Target: i686-apple-darwin9 Configured with: /var/tmp/gcc/gcc-5465~16/src/configure --disable-checking -enable-werror --prefix=/usr --mandir=/share/man --enable-languages=c,objc,c++,obj-c++ --program-transform-name=/^[cg][^.-]*$/s/$/-4.0/ --with-gxx-include-dir=/include/c++/4.0.0 --with-slibdir=/usr/lib --build=i686-apple-darwin9 --with-arch=apple --with-tune=generic --host=i686-apple-darwin9 --target=i686-apple-darwin9 Thread model: posix gcc version 4.0.1 (Apple Inc. build 5465) Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -O3 -fno-omit-frame-pointer -g' CXX='g++' CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -O3 -fno-omit-frame-pointer -g' LDFLAGS='-L/sw/lib' ASFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Nov 21 2007 /usr/lib/libc.dylib -> libSystem.dylib Configure command: ./configure '--prefix=/sw' '--enable-assembler' '--with-extra-charsets=complex' '--enable-thread-safe-client' '--with-innodb' '--with-archive-storage-engine' '--with-big-tables' '--with-blackhole-storage-engine' '--with-federated-storage-engine' '--with-csv-storage-engine' '--with-embedded-server' '--enable-local-infile' '--with-ndbcluster' '--without-libedit' '--without-readline' '--disable-dependency-tracking' '--with-mysqld-user=mysql' '--with-yassl' '--mandir=/sw/share/man' '--infodir=/sw/share/info' '--localstatedir=/sw/var/mysql' '--libexecdir=/sw/sbin' '--sysconfdir=/sw/etc' 'CFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -O3 -fno-omit-frame-pointer -g' 'CPPFLAGS=-I/sw/include' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -O3 -fno-omit-frame-pointer -g' 'LDFLAGS=-L/sw/lib' /sw/bin/mysqlbug includes the below details, but wants to send an email to my...@li..., when I suspect this is more a fink packaging problem (or possibly a fink configuration problem with how I've set up fink). I'm running: /sw> fink -V Package manager version: 0.29.10 Distribution version: selfupdate-rsync (0.9.0), 10.5, i386 Mac OS X 10.5.8 on a MacBookPro |