Is there any way to make the databases be tables in an existing database? Or default setup here is for users to only have one database and for everything to just make tables in it. Ordinary users can't make new databases.

I have a problem with the mysql gem insallation on fedora 11.

sudo gem install mysql – –with-mysql-config=/usr/bin/mysql_config

results in the following error: /usr/bin/ld: /usr/local/lib/libssl.a(t1_srvr.o): relocation R_X86_64_32 against `.data' can not be used when making a shared object; recompile with -fPIC /usr/local/lib/libssl.a: could not read symbols: Bad value collect2: ld returned 1 exit status make: *** [mysql_api.so] Error 1

any ideas on how to resolve this?

I have a problem with the install of the mysql driver on mac os x server. I've tried just about everything and still get the same error:

Building native extensions. This could take a while… ERROR: Error installing mysql:

ERROR: Failed to build gem native extension.

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby extconf.rb ——with-mysql-config=/Applications/MAMP/Library/bin/mysql_config mkmf.rb can't find header files for ruby at /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ruby.h

Here are the list of commands I've tried (keep in mind that between the 64 and 32-bit versions I have been reinstalling): sudo env ARCHFLAGS=“-arch x86_64” gem install mysql ——with-mysql-config=/Applications/MAMP/Library/bin/mysql_config sudo env ARCHFLAGS=”-arch i386” gem install mysql – ——with-mysql-config=/Applications/MAMP/Library/bin/mysql_config

sudo gem install mysql ——with-mysql-include=/usr/local/mysql/include —with-mysql-lib=/usr/local/mysql/lib —with-mysql-config=/usr/local/mysql/bin/mysql_config

sudo env ARCHFLAGS=”-arch i386” gem install mysql – ——with-mysql-config=/usr/local/mysql/bin/mysql_config sudo env ARCHFLAGS=”-arch x86_64” gem install mysql – ——with-mysql-config=/usr/local/mysql/bin/mysql_config

Any ideas as to how to resolve this? I've seen tons of forums online and it appears that a large number of people have the same problem.

It should be noted that on maverick it is now: sudo apt-get install mysql-server mysql-server-5.0 libmysqlclient15off libmysqlclient15-dev mysql-client-5.0 mysql-common

to get mysql/deps installed.

**Note that the MySQL install for Ubuntu puts the mysql.sock file in /var/run/mysqld instead of /tmp, so you'll want to make sure your database.yml reflects this location. - this is transparent in rails3 with mysql-ruby gem.

works in spades for me on 1.9.2 trying it out for ree and 1.8…also i am using rvm so it could be a tweak there…rvm should be required to run ruby on debianized.

evidently repo updated again…with less than 5 minutes of tinkering the new line is sudo apt-get install mysql-server mysql-server-5.1 libmysqlclient-dev mysql-client-5.1 mysql-common mysql-client-core-5.1 mysql-client-5.1,,,,testing it now thinking it was during the 5.0 to 5.1 up

and in maverick its service mysql restart