mysql5 +server install

[Ryan Schmidt]

On Nov 14, 2008, at 23:13, Michael Brian Bentley wrote:

> At 9:25 PM -0600 11/14/08, Ryan Schmidt wrote:
>
>> On Nov 14, 2008, at 13:22, Michael Brian Bentley wrote:
>>
>>> I just tried to install mysql5, and I tried uninstalling it and  
>>> reinstalling it a couple times. It appears to install a zero- 
>>> length /opt/local/var/db/mysql5/mysql/user.MYD file, apparently  
>>> making it difficult to log into mysql root and access things.
>>>
>>> Has anyone else run into that problem? We had to copy the /opt/ 
>>> local/var/db/mysql5/mysql folder contents from another machine to  
>>> be able to log in properly.
>>
>> The mysql5 port itself should install no MYD files.
>>
>> Are you saying an empty user.MYD file appeared when you tried to  
>> install the initial databases with mysql_install_db5? Or what was  
>> the exact sequence of commands you entered to get to this situation?
>
> Ok, good, that means then there likely was an old copy of that  
> folder around from a previous install attempt.
>
> sudo port install mysql5 +server is what we ran. If there was some  
> old cruft lying around, that would explain why it was so deucedly  
> hard to do anything.
>
> I'm not sure why there was a bad set of files present in the first  
> place.

"port contents mysql5" should show you everything the port installed;  
on my system, there aren't any *.MYD files in that list. So I expect  
you're right, those files must've already been there.