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