issues running mysql, mysql5?

[Chris Drackett]

when I try and run it i get the following:

Hobbes:~ cwd$ ps auxww | grep mysql
cwd       4715   1.0 -0.0    27372    428  p3  S+    6:05PM   0:00.00  
grep mysql
mysql     4674   0.0 -0.5    39940  10444  ??  SNs   6:04PM    
0:00.21 /System/Library/Frameworks/CoreServices.framework/Frameworks/ 
Metadata.framework/Versions/A/Support/mdimportserver

and if I try and start the server I get:

Hobbes:~ cwd$ /opt/local/share/mysql5/mysql/mysql.server start
Starting MySQL/opt/local/share/mysql5/mysql/mysql.server: line 151:  
kill: (4732) - No such process
ERROR!

any ideas :)


On Mar 31, 2007, at 5:58 PM, Ryan Schmidt wrote:

> On Mar 31, 2007, at 11:57, Chris Drackett wrote:
>
>> I have installed mysql and mysql5 using macports.. I used to have  
>> it installed pre-macports, but that install didn't seem to work  
>> with the things (like python) that I recently installed via  
>> macports. Here is the message I am getting when I try to run  
>> mysql5 (which i assume is the same as mysql?)
>>
>> Hobbes:~ cwd$ mysql5
>> ERROR 2002 (HY000): Can't connect to local MySQL server through  
>> socket '/opt/local/var/run/mysql5/mysqld.sock' (2)
>>
>> and if I try and run mysql, it can't find it, so I try and  
>> activate using port:
>>
>> Hobbes:~ cwd$ port activate mysql
>> --->  Activating mysql
>> Error: port activate failed: Image error: /opt/local/share/man/ 
>> man1/mysql.1.gz is being used by the active mysql5 port.  Please  
>> deactivate this port first, or use the -f flag to force the  
>> activation.
>>
>> I am new to this, and have no idea what is going on :)
>
> The port "mysql" is MySQL version 3.23.58. (Discover that with  
> "port info mysql".) That's ancient. You probably don't want it.  
> Uninstall it. "sudo port uninstall mysql".
>
> Can't connect to the socket? Ok. Is your MySQL 5 server running?  
> Check the list of running processes. I use "ps auxww | grep mysql".  
> If you see more than just the grep process, MySQL should be  
> running. If it's not... Did you start your MySQL 5 server? Did you  
> even install your MySQL 5 server? To get it, you need to have run  
> "sudo port install mysql5 +server". If you instead just ran "sudo  
> port install mysql5" without specifying the +server variant, then  
> you don't have the server. Uninstall the nonserver version ("sudo  
> port uninstall mysql5") and reinstall it with the +server variant.  
> When it's done, it'll print out a command that you can run to  
> activate the launch daemon so that your MySQL 5 server is running.  
> Then you should be able to connect to its socket.
>
>