sudo /opt/local/share/mysql5/mysql/mysql.server start Finally works !
Thank you Begin forwarded message: > From: Samuel V Green III <[email protected]> > Date: October 10, 2010 7:17:27 PM PDT > To: Ryan Schmidt <[email protected]> > Subject: Re: MySql5 install on SnowLeopard, problems starting > > Just installed via : sudo port install mysql5-server > > Then I issued following command : > > sudo -u _mysql mysql_install_db5 > > GOT THE FOLLOWING OUTPUT: > > shell-init: error retrieving current directory: getcwd: cannot access parent > directories: Permission denied > job-working-directory: error retrieving current directory: getcwd: cannot > access parent directories: Permission denied > job-working-directory: error retrieving current directory: getcwd: cannot > access parent directories: Permission denied > job-working-directory: error retrieving current directory: getcwd: cannot > access parent directories: Permission denied > job-working-directory: error retrieving current directory: getcwd: cannot > access parent directories: Permission denied > job-working-directory: error retrieving current directory: getcwd: cannot > access parent directories: Permission denied > Installing MySQL system tables... > job-working-directory: error retrieving current directory: getcwd: cannot > access parent directories: Permission denied > job-working-directory: error retrieving current directory: getcwd: cannot > access parent directories: Permission denied > job-working-directory: error retrieving current directory: getcwd: cannot > access parent directories: Permission denied > OK > Filling help tables... > job-working-directory: error retrieving current directory: getcwd: cannot > access parent directories: Permission denied > job-working-directory: error retrieving current directory: getcwd: cannot > access parent directories: Permission denied > OK > > > > On Oct 10, 2010, at 7:09 PM, Ryan Schmidt wrote: > >> On Oct 10, 2010, at 20:22, Samuel V Green III wrote: >> >>> 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 >> >> As Bradley already pointed out, the mysql5 port has no variant called >> "server"; you want the separate mysql5-server port. >> >> >>> From here I couldn't get the databases initialized with this command: >>> sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql >> >> Why not? what happened? >> >> >>> Then I tried this: >>> >>> sudo -u mysql mysql_install_db5 >>> >>> Still no luck >> >> Why not? what happened? >> >> Note that on Leopard and later, the user is technically _mysql (not mysql). >> >> >>> 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" >> >> Well, ok, but now the database files created are owned by root, which isn't >> right. They need to be owned by _mysql. >> >> >>> 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 >> >> Those permissions might be ok... on my development system they're 755 >> instead of 700 but if everything is running as the _mysql user that >> shouldn't matter. >> >> >> Have you already referred to the MAMP how-to in our wiki? >> >> http://trac.macports.org/wiki/howto/MAMP >> >> >
_______________________________________________ macports-users mailing list [email protected] http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
