 | | | MySQL install problems on OSX 10.4 | MySQL install problems on OSX 10.4 2005-09-13 - By Michael Stassen
Back
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/mysql?unsub=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|