Problem installing Mysql for use with ROR

luislavena · June 17, 2011, 9:00am

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)
"

Can anybody please help me? As I would like to continue learning ror
ASAP, but this is holding me back…

Thank You

Mark M
Maze

Maze · June 17, 2011, 9:59am

You can always use the default sqlite db. I’ve given up on mysql due to
the same issue.

If you google mysql install 10.6 youll find a few good solutions.
Hivelogic.com worked for me awhile back.

Kind Regards,
Chad E.
The Code Boutique

Sent from my iPhone

Maze · June 17, 2011, 1:16pm

Have you tried the installer from MySQL?

<http://www.mysql.com/downloads/mirror.php?id=402874>

It includes a Prefs Panel for starting and stopping the server. I’ve
also found these to be very helpful developing RoR/MySQL apps:

<http://www.sequelpro.com/>
<http://www.phpmyadmin.net/>

**Leigh

Maze · June 17, 2011, 1:02pm

Is Postgres any easier in ROR v 3 or wiser to give up and default to
sqlite3?

Maze · June 17, 2011, 9:25pm

On Thu, Jun 16, 2011 at 8:03 PM, Maze [email protected] wrote:

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_install_db --help
server starting up correctly.
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 S.

Maze · June 18, 2011, 5:25pm

On Sat, Jun 18, 2011 at 8:17 AM, Maze [email protected] wrote:

How can I fix this please?

Personally, I’d start by following the rather thorough instructions in
the
error message

–
Hassan S. ------------------------ [email protected]

twitter: @hassan

Maze · June 18, 2011, 7:25pm

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.

Maze · June 18, 2011, 8:26pm

Using this installer, it took me less than 4 minutes to have a fully
working version of MySQL 5.5.13 running on my Macbook Air with OS X
10.6.7.

**Leigh

**Leigh

Maze · June 19, 2011, 12:25am

I downloaded the installer, and installed it. Still same problem

Maze · June 18, 2011, 5:18pm

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?

Maze · June 19, 2011, 4:14am

On Sat, Jun 18, 2011 at 10:24 AM, Maze [email protected] wrote:

Now you either want to help me or you don’t.

Excuse me?? I wouldn’t have bothered to answer in the first place if
I wasn’t trying to help.

I tried examining the logs, etc…, etc… but I don’t understand whats
wrong.

And yet it doesn’t occur to you to share those log entries with anyone
who might understand them? Sorry, my crystal ball is in the shop at
the moment, so I’m afraid I won’t be able to comment further

Good luck,

Hassan S. ------------------------ [email protected]

twitter: @hassan

Maze · June 19, 2011, 3:39am

I had the same issue this morning on a fresh machine. Rather than
bothering with MySQL once again (this sort of thing is a common
problem) I switched to Postgres.

brew installl postgress
gem install pg

Then point rails to the PG server:
development:
adapter: postgresql

Maze · June 23, 2011, 11:14am

Hi Maze,

Do you solve this problem? I got the same problem too.

Regards,

David

Maze · October 22, 2012, 9:05am

Man its frustrating when you finally find someone who has the exact same
problem you have and no one was willing to help.

Maze · October 22, 2012, 9:17am

FYI I ended up just completely removing mysql and doing a fresh install,
make sure you get all of the lingering mysql folders and files.

Maze · October 22, 2012, 10:02am

Which OS Your Using ?

If your using Ubuntu

Install mysql first ( sudo apt-get install mysql-server)

and install install mysql libs :

sudo apt-get install mysql-server mysql-server-5.0 libmysqlclient15off \

libmysqlclient15-dev mysql-client-5.0 mysql-common

sudo apt-get install libmysql+±dev

sudo gem install mysql

change database.yml
*
*

#For MySql you want something like

development:
adapter: mysql
encoding: utf8
database: temp_development
username: root
password:( give your root mysql password )
socket: /tmp/mysql.sock

Warning: The database defined as ‘test’ will be erased and

re-generated from your development database when you run ‘rake’.

Do not set this db to the same as development or production.

test:
adapter: mysql
encoding: utf8
database: temp_test
username: root
password:
socket: /tmp/mysql.sock

production:
adapter: mysql
encoding: utf8
database: temp_production
username: root
password:
socket: /tmp/mysql.sock

Cheers,
Sai