Mysql – thesql5.58 unstart server in mac os 10.6.5

macosMySQL

MySQL 5.5.8 uninstall MAC OS 10.6.5,restart computer is message “/Library/StartupItems/MySQLCOM” has not been started because it does not have the proper security settings. i set
sudo /Applications/TextEdit.app/Contents/MacOS/TextEdit /usr/local/mysql/support-files/mysql.server

Locate the configuration defining the basedir and set the following :
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

bug i click the mysql preference start mysql server isn't start

and i sudo chown -R root:wheel /Library/StartupItems/MySQLCOM and restart again ,not warning message but mysql server not start ,why?

Best Answer

I just installed MySQL 5.5.8 (mysql-5.5.8-osx10.6-x86_64.dmg) on Mac os X 10.6.5 and also had the problem that MySQL was not starting.

After reading this post: http://forums.mysql.com/read.php?11,399397,399606#msg-399606

Modify the mysql.server script file using the following command :
sudo /Applications/TextEdit.app/Contents/MacOS/TextEdit /usr/local/mysql/support-files/mysql.server
Locate the configuration defining the basedir and set the following:
basedir=/usr/local/mysql 
datadir=/usr/local/mysql/data 
Save the file and start the mysql server in the system preferences / terminal

This solved the problem.

Hope this helps. Thanks to http://forums.mysql.com/profile.php?11,3773555 !

Related Solutions

Macos – Find (and kill) process locking port 3000 on Mac

You can try netstat
```
 netstat -vanp tcp | grep 3000
```
For macOS El Capitan and newer (or if your netstat doesn't support -p), use lsof
```
 lsof -i tcp:3000 
```
For Centos 7 use:
```
 netstat -vanp --tcp | grep 3000
```

Macos – Who is listening on a given TCP port on Mac OS X

On macOS Big Sur and later, use this command:

sudo lsof -i -P | grep LISTEN

or to just see just IPv4:

sudo lsof -nP -i4TCP:$PORT | grep LISTEN

On older versions, use one of the following forms:

sudo lsof -nP -iTCP:$PORT | grep LISTEN
sudo lsof -nP -i:$PORT | grep LISTEN

Substitute $PORT with the port number or a comma-separated list of port numbers.

Prepend sudo (followed by a space) if you need information on ports below #1024.

The -n flag is for displaying IP addresses instead of host names. This makes the command execute much faster, because DNS lookups to get the host names can be slow (several seconds or a minute for many hosts).

The -P flag is for displaying raw port numbers instead of resolved names like http, ftp or more esoteric service names like dpserve, socalia.

See the comments for more options.

For completeness, because frequently used together:

To kill the PID:

sudo kill -9 <PID>
# kill -9 60401

Best Answer

Related Solutions

Macos – Find (and kill) process locking port 3000 on Mac

Macos – Who is listening on a given TCP port on Mac OS X

Related Topic