I cleaned my disk and reinstalled Mac OSX. Followed by the following actions. Why isn't this working ? Is the mysql port defect ? Have reinstalled OS X and MySQL 3 times now. Everything I found on google didn't help.
* I ran the OS X Software Update (5 updates) * restart * I ran the OS X Software Update (2 updates) * restart * Installed Xcode 3.2.5 * restart * macport install * restart * sudo port selfupdate * sudo port install mysql5 +server * sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql Password: Installing MySQL system tables... ERROR: 1004 Can't create file '/var/tmp/#sqla0_1_0.frm' (errno: 9) 101205 16:04:06 [ERROR] Aborting 101205 16:04:06 [Note] /opt/local/libexec/mysqld: Shutdown complete [...and more text...] * sudo /opt/local/lib/mysql5/bin/mysqld_safe & [1] 260 Sebastian-Wojtowiczs-MacBook:~ Allisone$ 101205 16:12:36 mysqld_safe Logging to '/opt/local/var/db/mysql5/Sebastian-Wojtowiczs-MacBook.local.err'. mkdir: /opt/local/var/run: No such file or directory chown: /opt/local/var/run/mysql5: No such file or directory chmod: /opt/local/var/run/mysql5: No such file or directory 101205 16:12:36 mysqld_safe Starting mysqld daemon with databases from /opt/local/var/db/mysql5 101205 16:12:42 mysqld_safe mysqld from pid file /opt/local/var/db/mysql5/Sebastian-Wojtowiczs-MacBook.local.pid ended * sudo mkdir /opt/local/var/run * sudo chmod g+w /opt/local/var/run * sudo mkdir /opt/local/var/run/mysql5 * sudo chown mysql /opt/local/var/run/mysql5 * mysqladmin5 -u root -p ping Enter password: mysqladmin5: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' * /opt/local/lib/mysql5/bin/mysqladmin -u root password 'mypass' /opt/local/lib/mysql5/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' * sudo chown -R mysql:mysql /opt/local/var/db/mysql5 * sudo chmod u+rwx,go= /opt/local/var/db/mysql5 * sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql Installing MySQL system tables... OK Filling help tables... OK [...and more text...] * mysqladmin5 -u root password mysqladmin5: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' 2010/12/5 Sebastian Wojtowicz <[email protected]> > Thx, I'm further now through: > > sudo chown -R mysql:mysql /opt/local/var/db/mysql5 > sudo chmod u+rwx,go= /opt/local/var/db/mysql5 > > But now I can't set the password. Is this related to the initial problem ? > > I started mysql... > sudo /opt/local/share/mysql5/mysql/mysql.server start > > and now I struggle with... > allisones-mac:~ Allisone$ sudo /opt/local/lib/mysql5/bin/mysqladmin -u root > password 'new-password' > /opt/local/lib/mysql5/bin/mysqladmin: connect to server at 'localhost' > failed > error: 'Access denied for user 'root'@'localhost' (using password: NO)' > > or > allisones-mac:~ Allisone$ sudo /opt/local/lib/mysql5/bin/mysqladmin -u root > password 'new-password' > /opt/local/lib/mysql5/bin/mysqladmin: connect to server at 'localhost' > failed > error: 'Access denied for user 'root'@'localhost' (using password: NO)' > allisones-mac:~ Allisone$ sudo /opt/local/lib/mysql5/bin/mysqladmin -u root > -h allisones-mac.fritz.box password 'new-password' > /opt/local/lib/mysql5/bin/mysqladmin: connect to server at > 'allisones-mac.fritz.box' failed > error: 'Host 'localhost' is not allowed to connect to this MySQL server' > > I remember this steps to be straight forward, what is happening now that > this doesn't work out of the box ? > > 2010/12/5 Jasper Frumau <[email protected]> > > Maybe a file/folder permissions issue. See also >> http://forums.freebsd.org/showthread.php?s=0d9db79ab2a610ba86748801aa3c0565&t=19807&page=2(page >> two of similar thread @ BSD) Using DiskUtilities you can check disc >> file permissions as well for the whole disc. But none of my >> suggestions/solutions are warranted. I just use MAP for web development.. >> >> On Sun, Dec 5, 2010 at 7:25 AM, Sebastian Wojtowicz < >> [email protected]> wrote: >> >>> Forgot to say, that error comes on >>> sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql >>> >>> 2010/12/5 Sebastian Wojtowicz <[email protected]> >>> >>> Has someone found a solution to this problem ? Cause I see posts, but no >>>> working solution in the internet. >>>> This night I have reinstalled Mac OSX Snow Leopard, updated to the >>>> newest version 10.6.5, Installed XCode newest Version 3.2.5, installed >>>> newest macports, did a selfupdate and then did a "sudo port install >>>> mysql5".... all that TWICE >>>> Tried "unset TMPDIR" >>>> tried to set "tmpdir = /tmp/" in "/opt/local/etc/mysql5/my.cnf" >>>> >>>> I always get the same error message. >>>> >>>> Thanks for the help >>>> >>> >>> >>> _______________________________________________ >>> macports-users mailing list >>> [email protected] >>> http://lists.macosforge.org/mailman/listinfo.cgi/macports-users >>> >>> >> >
_______________________________________________ macports-users mailing list [email protected] http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
