[Rails] Re: Problem installing Mysql for use with ROR

When i try mysql_install_db --verbose --user=`whoami` --basedir="$
(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp

This come up:

"
Installing MySQL system tables...
110618 17:17:01 [ERROR] Incorrect definition of table mysql.proc:
expected column 'comment' at position 15 to have type text, found type
char(64).
ERROR: 1548 Cannot load from mysql.proc. The table is probably
corrupted
110618 17:17:01 [ERROR] Aborting

110618 17:17:01 [Note] /usr/local/Cellar/mysql/5.5.10/bin/mysqld:
Shutdown complete

Installation of system tables failed! Examine the logs in
/usr/local/var/mysql for more information.

You can try to start the mysqld daemon with:

shell> /usr/local/Cellar/mysql/5.5.10/bin/mysqld --skip-grant &

and use the command line tool /usr/local/Cellar/mysql/5.5.10/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /usr/local/Cellar/mysql/5.5.10/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /usr/local/var/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/local/Cellar/mysql/5.5.10/
scripts/mysqlbug script!

"

How can I fix this please?

On Jun 17, 9:24 pm, Adam Stegman <asteg...@gmail.com> wrote:
> On Thu, Jun 16, 2011 at 8:03 PM, Maze <markmuss...@me.com> wrote:
> > Hi,
>
> > So I'm new to MYSQL and RoR. I am trying to learn ruby on rails, but
> > i'm having a problem with MYSQL.
>
> > I am using Mac OS X 10.6 Snow Leopard (10.6.7).
>
> > To install MYSQL i done:
>
> >    brew install mysql
>
> > Which installed mysql, but when I do "mysql_install_db" this comes up:
>
> > "
> > FATAL ERROR: Could not find ./bin/my_print_defaults
>
> > If you compiled from source, you need to run 'make install' to
> > copy the software into the correct location ready for operation.
>
> > If you are using a binary release, you must either be at the top
> > level of the extracted archive, or pass the --basedir option
> > pointing to that location.
> > "
>
> > and when I do "mysql -u root" this comes up:
> > "
> > ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> > '/tmp/mysql.sock' (2)
> > "
>
> You can't connect to it because you haven't started it yet. homebrew gives
> you specific instructions to perform after installation:
>
> $ brew info mysql
>
>
>
>
>
> > mysql 5.5.10
> >http://dev.mysql.com/doc/refman/5.5/en/
> > Depends on: cmake, readline, pidof
> > /usr/local/Cellar/mysql/5.5.10 (6232 files, 219M)
> > Set up databases to run AS YOUR USER ACCOUNT with:
> >     unset TMPDIR
> >     mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix
> > mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
> > To set up base tables in another folder, or use a differnet user to run
> > mysqld, view the help for mysqld_install_db:
> >     mysql_install_db --help
> > and view the MySQL documentation:
> >   *http://dev.mysql.com/doc/refman/5.5/en/mysql-install-db.html
> >   *http://dev.mysql.com/doc/refman/5.5/en/default-privileges.html
> > To run as, for instance, user "mysql", you may need to `sudo`:
> >     sudo mysql_install_db ...options...
> > Start mysqld manually with:
> >     mysql.server start
> >     Note: if this fails, you probably forgot to run the first two steps up
> > above
> > A "/etc/my.cnf" from another install may interfere with a Homebrew-built
> > server starting up correctly.
> > To connect:
> >     mysql -uroot
> > To launch on startup:
> > * if this is your first install:
> >     mkdir -p ~/Library/LaunchAgents
> >     cp /usr/local/Cellar/mysql/5.5.10/com.mysql.mysqld.plist
> > ~/Library/LaunchAgents/
> >     launchctl load -w ~/Library/LaunchAgents/com.mysql.mysqld.plist
> > * if this is an upgrade and you already have the com.mysql.mysqld.plist
> > loaded:
> >     launchctl unload -w ~/Library/LaunchAgents/com.mysql.mysqld.plist
> >     cp /usr/local/Cellar/mysql/5.5.10/com.mysql.mysqld.plist
> > ~/Library/LaunchAgents/
> >     launchctl load -w ~/Library/LaunchAgents/com.mysql.mysqld.plist
> > You may also need to edit the plist to use the correct "UserName".
>
> >http://github.com/mxcl/homebrew/commits/master/Library/Formula/mysql.rb
>
> Note the specific commands:> unset TMPDIR
> > mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix
>
> mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
>
> > mysql.server start
> > mysql -uroot
>
> Just copy & paste them from the instructions.
>
> Adam Stegman

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.