Re: MySQL install problems on OSX 10.4
Matt Scales wrote: I've just installed MySQL 4 4.1.12_1 +server using darwinports but I can't seem to get past this error. After installing it tells me that it cold not resolve my IP. Why are you using darwinports instead of the official binary from mysql? For reference, I've had success running mysql 4.0.x and 4.1.x, official binaries and compiled from source, under Mac OS X 10.2.1 through 10.3.9. I haven't tried darwinports, however. Mattys-iMac-G5:/opt/local/bin matty$ sudo -u mysql ./mysql_install_db Password: WARNING: The host 'Mattys-iMac-G5' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL daemon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! I haven't seen this error since the first time I installed mysql on Mac OS X 10.2. I'm still using 10.3.9, so either this is a 10.4 issue, a darwinports issue, or something strange about your network setup. Installing all prepared tables 050910 15:52:28 [Warning] Setting lower_case_table_names=2 because file system for /opt/local/var/db/mysql/ is case insensitive Fill help tables 050910 15:52:30 [Warning] Setting lower_case_table_names=2 because file system for /opt/local/var/db/mysql/ is case insensitive This is normal. I ignore this and try and start mysqld using cd /opt/local ; /opt/local/bin/mysqld_safe but it won't work. It says You must be root to start mysqld. Hence, this needs to be cd /opt/local sudo -v sudo bin/mysqld_safe Mattys-iMac-G5:/opt/local/bin matty$ cd /opt/local ; /opt/local/bin/mysqld_safe [1] 18533 Mattys-iMac-G5:/opt/local matty$ chown: /opt/local/var/Mattys-iMac-G5.err: Operation not permitted Starting mysqld daemon with databases from /opt/local/var STOPPING server from pid file /opt/local/var/Mattys-iMac-G5.pid 050910 16:09:32 mysqld ended Can anyone advise me on what's going on with the the mysqld not starting? Probably because you are attempting to start mysqld as a normal user rather than as root. Typing mysql at the prompt tells me: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysqld/mysqld.sock' (2) The client normally connects via the unix socket file /opt/local/var/run/mysqld/mysqld.sock, which is created by the server at startup (and removed at shutdown). mysql is the client. As the server (mysqld) failed to start, the client (mysql) has nothing to connect to. Hence the error. Very confused as to why it isn't working. Any help most appreciated Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL install problems on OSX 10.4
I've just installed MySQL 4 4.1.12_1 +server using darwinports but I can't seem to get past this error. After installing it tells me that it cold not resolve my IP. Mattys-iMac-G5:/opt/local/bin matty$ sudo -u mysql ./mysql_install_db Password: WARNING: The host 'Mattys-iMac-G5' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL daemon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Installing all prepared tables 050910 15:52:28 [Warning] Setting lower_case_table_names=2 because file system for /opt/local/var/db/mysql/ is case insensitive Fill help tables 050910 15:52:30 [Warning] Setting lower_case_table_names=2 because file system for /opt/local/var/db/mysql/ is case insensitive I ignore this and try and start mysqld using cd /opt/local ; /opt/local/bin/mysqld_safe but it won't work. It says Mattys-iMac-G5:/opt/local/bin matty$ cd /opt/local ; /opt/local/bin/mysqld_safe [1] 18533 Mattys-iMac-G5:/opt/local matty$ chown: /opt/local/var/Mattys-iMac-G5.err: Operation not permitted Starting mysqld daemon with databases from /opt/local/var STOPPING server from pid file /opt/local/var/Mattys-iMac-G5.pid 050910 16:09:32 mysqld ended Can anyone advise me on what's going on with the the mysqld not starting? Typing mysql at the prompt tells me: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysqld/mysqld.sock' (2) Very confused as to why it isn't working. Any help most appreciated -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL install problems on OSX 10.4
Hello. /opt/local/var/Mattys-iMac-G5.err: Operation not permitted Check the permissions on /opt/local/var directory. Have a look here as well: http://dev.mysql.com/doc/mysql/en/starting-server.html Matt Scales [EMAIL PROTECTED] wrote: I've just installed MySQL 4 4.1.12_1 +server using darwinports but I can't seem to get past this error. After installing it tells me that it cold not resolve my IP. Mattys-iMac-G5:/opt/local/bin matty$ sudo -u mysql ./mysql_install_db Password: WARNING: The host 'Mattys-iMac-G5' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL daemon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Installing all prepared tables 050910 15:52:28 [Warning] Setting lower_case_table_names=3D2 because file system for /opt/local/var/db/mysql/ is case insensitive Fill help tables 050910 15:52:30 [Warning] Setting lower_case_table_names=3D2 because file system for /opt/local/var/db/mysql/ is case insensitive I ignore this and try and start mysqld using cd /opt/local ; /opt/local/bin/mysqld_safe but it won't work. It says Mattys-iMac-G5:/opt/local/bin matty$ cd /opt/local ; /opt/local/bin/mysqld_safe [1] 18533 Mattys-iMac-G5:/opt/local matty$ chown: /opt/local/var/Mattys-iMac-G5.err: Operation not permitted Starting mysqld daemon with databases from /opt/local/var STOPPING server from pid file /opt/local/var/Mattys-iMac-G5.pid 050910 16:09:32 mysqld ended Can anyone advise me on what's going on with the the mysqld not starting? Typing mysql at the prompt tells me: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysqld/mysqld.sock' (2) Very confused as to why it isn't working. Any help most appreciated -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]