Look, I'm still a beginner with Ruby, Rails and MYSQL. All this is gibberish to me at the moment. Now you either want to help me or you don't.
I tried examining the logs, etc.., etc... but I don't understand whats wrong. I once got this to work, then I uninstalled because of some other problems, and now I can't get it work anymore. On Jun 18, 5:17 pm, Maze <[email protected]> wrote: > 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 athttp://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 <[email protected]> wrote: > > > > > On Thu, Jun 16, 2011 at 8:03 PM, Maze <[email protected]> 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
