problems running mysql_install_db5

[Bradley Giesbrecht]

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)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20110317/346502b0/attachment.html>