MySql5 install on SnowLeopard, problems starting

Samuel V Green III macunkie at gmail.com
Sun Oct 10 18:22:21 PDT 2010


Hoping there is someone out there who has successfully got MySql 5.1.51 running on 10.6.1 ?

MySQL 5 Install MacPorts:

sudo port install mysql5 +server

From here I couldn't get the databases initialized with this command:
sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql

Then I tried this:

sudo -u mysql mysql_install_db5

Still no luck and finally this seemed to work:

sudo mysql_install_db5

Producing :

Installing MySQL system tables...
OK
Filling help tables...
OK

"To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/opt/local/lib/mysql5/bin/mysqladmin -u root password 'new-password'
/opt/local/lib/mysql5/bin/mysqladmin -u root -h myserver.local password 'new-password'

Alternatively you can run:
/opt/local/lib/mysql5/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /opt/local ; /opt/local/lib/mysql5/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /opt/local/mysql-test ; perl mysql-test-run.pl"

ATTEMPTING TO START WITH THIS:

sudo /opt/local/share/mysql5/mysql/mysql.server start
Password:
Starting MySQL

...... ERROR! Manager of pid-file quit without updating file.


Don't quite know if my permissions are correct of the 
/opt/local/var/db/mysql5 directory ?

Current Permissions:

drwx------  8 _mysql  _mysql  272 Oct 10 18:15 mysql5

Thanks for any help !

Samuel.






More information about the macports-users mailing list