Hi folks - I imagine this must be trivially easy & I'll look stupid - but here goes...
I just tried installing mysql & everything installed ok (there were 2 error messages that seemed ignorable - details below) but I can't run mysql or even change the root password as instructed. Since I just installed it - the instructions say to change the password so I type: --------------- /sw/bin/mysqladmin -u root -p password 'my_shiny_new_password' --------------- Which returns: --------------- /sw/bin/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! ---------------- So I think - ok I'll start mysqld with the command from the instrucstion so I type: -------------- cd /sw ; /sw/bin/safe_mysqld & -------------- Which spews -------------- [3] 805 [localhost:/] deep% touch: /sw/var/mysql/localhost.err: Permission denied chown: /sw/var/mysql/localhost.err: Permission denied Starting mysqld daemon with databases from /sw/var/mysql /sw/bin/safe_mysqld: permission denied: /sw/var/mysql/localhost.err [229] rm: /sw/var/mysql/localhost.pid: Permission denied /sw/bin/safe_mysqld: permission denied: /sw/var/mysql/localhost.err [235] tee: /sw/var/mysql/localhost.err: Permission denied 020124 00:27:23 mysqld ended tee: /sw/var/mysql/localhost.err: Permission denied [3] Exit 1 ( cd /sw; /sw/bin/safe_mysqld ) -------------- So then I cd to the sw directory & type /sw/bin/safe_mysqld & I get a similar error: ---------------------- touch: /sw/var/mysql/localhost.err: Permission denied chown: /sw/var/mysql/localhost.err: Permission denied Starting mysqld daemon with databases from /sw/var/mysql /sw/bin/safe_mysqld: permission denied: /sw/var/mysql/localhost.err [229] rm: /sw/var/mysql/localhost.pid: Permission denied /sw/bin/safe_mysqld: permission denied: /sw/var/mysql/localhost.err [235] tee: /sw/var/mysql/localhost.err: Permission denied 020124 00:42:41 mysqld ended tee: /sw/var/mysql/localhost.err: Permission denied --------- Any ideas? 'deep By the way - here is the text I was able to cut & paste from my installation attempt - Note the 2 error 1062 - are those relevant?: ----------------------- Unpacking zlib (from .../zlib_1.1.3-5_darwin-powerpc.deb) ... Unpacking readline (from .../readline_4.2-3_darwin-powerpc.deb) ... Unpacking libxml2 (from .../libxml2_2.3.14-2_darwin-powerpc.deb) ... Unpacking daemonic (from .../daemonic_20010902-1_darwin-powerpc.deb) ... Unpacking dlcompat (from .../dlcompat_20010831-1_darwin-powerpc.deb) ... Unpacking passwd (from .../passwd_20011202-1_darwin-powerpc.deb) ... Unpacking mysql (from .../mysql_3.23.42-1_darwin-powerpc.deb) ... Setting up ant (1.4.1-2) ... Setting up zlib (1.1.3-5) ... Setting up readline (4.2-3) ... * History: (history). The GNU history library API install-info: no section specified for new entry, placing at end * Readline: (readline). The GNU readline library API install-info: no section specified for new entry, placing at end * RLuserman: (rluserman). The GNU readline library User's Manual. install-info: no section specified for new entry, placing at end Setting up libxml2 (2.3.14-2) ... Setting up daemonic (20010902-1) ... Setting up dlcompat (20010831-1) ... Setting up passwd (20011202-1) ... The following user entries will be added to your NetInfo database: news:*:250:250::0:0:News Server:/:/dev/null mysql:*:251:251::0:0:MySQL Database Server:/:/dev/null pgsql:*:252:252::0:0:PostgreSQL Database Server:/:/dev/null games:*:253:253::0:0:Game Files Owner:/:/dev/null canna:*:254:254::0:0:Canna Japanese Input Server:/:/dev/null postfix:*:255:255::0:0:Postfix Mail Transfer Agent:/sw/var/spool/postfix:/dev/null The following group entries will be added to your NetInfo database: news:*:250: mysql:*:251: pgsql:*:252: games:*:253: canna:*:254: postfix:*:255: maildrop:*:256: Existing entries with these names or numbers will be overwritten or otherwise affected by this. On the other hand, some Fink packages will not work unless these entries are in the NetInfo database. You can make adjustments to the files /sw/etc/passwd-fink and /sw/etc/group-fink now (from another window), then say yes here. Or you can say no here and add the users and groups manually (e.g. on your central NetInfo server). If you don't know what all of this is about, just say yes. Do you want to continue? [Y/n] Setting up mysql (3.23.42-1) ... Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-root' for key 1 020124 0:25:21 /sw/sbin/mysqld: Shutdown Complete 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 ! This is done with: /sw/bin/mysqladmin -u root -p password 'new-password' /sw/bin/mysqladmin -u root -h localhost -p password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd /sw ; /sw/bin/safe_mysqld & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the /sw/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com * mysql: (mysql). MySQL documentation. install-info: no section specified for new entry, placing at end ---------------------------------- Amandeep Jawa Worker Bee Software ---------------------------------- [EMAIL PROTECTED] 225A Dolores St. San Francisco, CA 94103-2202 Home: 415 255 6257 (ALL MALP) professional: http://www.worker-bee.com personal: http://www.deeptrouble.com political: http://www.sflcv.org _______________________________________________ Fink-beginners mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/fink-beginners
