issues running mysql, mysql5?
drackett at mac.com
Sat Mar 31 16:08:06 PDT 2007
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
mysql 4674 0.0 -0.5 39940 10444 ?? SNs 6:04PM
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
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
>> 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.
More information about the macports-users