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]