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
[email protected], 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
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Fink-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/fink-users
