On Mar 17, 2011, at 1:17 PM, David Gentry wrote:
Bradley,
Thank you for your response. I am responding to your request that I
run 3 commands:
$ /opt/local/lib/mysql5/bin/my_print_defaults client mysql mysqld
--port=3306
--socket=__PREFIX/var/run/mysqld/mysqld.sock
wrong
--skip-innodb
--user=mysql
--pid-file=__PREFIX/var/run/mysqld/mysqld.pid
wrong
--socket=__PREFIX/var/run/mysqld/mysqld.sock
wrong
--port=3306
--log=__PREFIX/var/log/mysql/mysql.log
wrong
--basedir=/usr/local/mysql-5.5.6-rc-osx10.6-x86_64
wrong
--datadir=/usr/local/mysql-5.5.6-rc-osx10.6-x86_64/data
wrong
--language=__PREFIX/share/mysql/english
wrong
--skip-locking
--set-variable=key_buffer=16M
--set-variable=max_allowed_packet=1M
--set-variable=thread_stack=128K
--enable-named-pipe
--connect_timeout=3
Did you replace the actual "prefix" with "__PREFIX" or is that the
unaltered output?
"__PREFIX" is wrong. These paths should have the same prefix as your
MacPorts install.
Example:
__PREFIX/var/run/mysqld/mysqld.sock
should be
/opt/local/var/run/mysqld/mysqld.sock
$ ls -la /etc/my.cnf/etc/mysql/my.cnf/opt/local/etc/mysql5/my.cnf
~/.my.cnf
ls: /Users/davidgentry/.my.cnf: No such file or directory
ls: /etc/my.cnf/etc/mysql/my.cnf/opt/local/etc/mysql5/my.cnf: Not a
directory
There are spaces missing after each my.cnf. Try this:
$ /opt/local/lib/mysql5/bin/my_print_defaults | grep my.cnf | xargs ls
-l
We need to clean up and start over. Mysql is actually an easy install
so if you clean it up well we can have you up and running quickly.
$ sudo port unload mysql5-server
$ sudo port uninstall mysql5-server
$ sudo port uninstall mysql5
Below we will move things out of the way. You can delete them if there
is not data to worry about preserving.
$ sudo mv /usr/local /usr/local_moved
$ sudo mv /etc/my.cnf /etc/my.cnf_moved
$ sudo mv /etc/mysql /etc/mysql_moved
$ sudo mv /opt/local/var/db/mysql5 /opt/local/var/db/mysql5_moved
$ sudo port install mysql5-server
$ sudo -u _mysql mysql_install_db5
$ sudo port load mysql5-server
Note about next command: press enter at password prompt.
$ mysql5 -u root -p
mysql> show databases;
mysql> exit;
Now create your root password if you like.
$ mysqladmin5 -p -u root password 'new-password'
If any of the above steps fail, stop there and report to the list.
--
Bradley Giesbrecht (pixilla)
_______________________________________________
macports-users mailing list
[email protected]
http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
