Select statements do not work on MySQL

rubyonrails-talk
1

Perhaps you should look up at the database user priviledges that you have.

Thanks & Regards, Dhruva Sagar.

Marie von Ebner-Eschenbach - “Even a stopped clock is right twice a day.”

2

No, what I meant was to check for the permissions of the database user from the database configurations.

Not from rails side. From mysql there might be some configuration errors, some missing grant’s or something, if you can’t directly access those permission settings from some cpanel or something then you might need to contact your hosting support.

This doesn’t seem to be a problem from rails side in my knowledge.

Thanks & Regards, Dhruva Sagar.

Mike Ditka - “If God had wanted man to play soccer, he wouldn’t have given us arms.”

3

Dhruva Sagar wrote:

No, what I meant was to check for the permissions of the database user from the database configurations.Not from rails side. From mysql there might be some configuration errors, some missing grant's or something, if you can't directly access those permission settings from some cpanel or something then you might need to contact your hosting support.

This doesn't seem to be a problem from rails side in my knowledge.

Thanks & Regards, Dhruva Sagar.

Mike Ditka <http://www.brainyquote.com/quotes/authors/m/mike_ditka.html&gt; - "If God had wanted man to play soccer, he wouldn't have given us arms."

On Wed, Oct 14, 2009 at 12:46 PM, Adam Meyer <

Yes, I know. I installed and configured the Production Server on my own. I set the grantt's as it is shown in this HowTo:

CREATE DATABASE your_database_development; $ GRANT ALL PRIVILEGES ON your_database_development.* TO 'your-non-root-user'@'localhost' IDENTIFIED BY   'your-non-root-password';

Obviously with my specific parts. It's really unbelivable.

4

Dhruva Sagar wrote:

No, what I meant was to check for the permissions of the database user

from

the database configurations.Not from rails side. From mysql there might

be

some configuration errors, some missing grant’s or something, if you

can’t

directly access those permission settings from some cpanel or something

then

you might need to contact your hosting support.

This doesn’t seem to be a problem from rails side in my knowledge.

Thanks & Regards,

Dhruva Sagar.

Mike Ditka <http://www.brainyquote.com/quotes/authors/m/mike_ditka.html>

“If God had wanted man to play soccer, he wouldn’t have given us arms.”

On Wed, Oct 14, 2009 at 12:46 PM, Adam Meyer <

Yes, I know. I installed and configured the Production Server on my own.

I set the grantt’s as it is shown in this HowTo:

CREATE DATABASE your_database_development;

$ GRANT ALL PRIVILEGES ON your_database_development.* TO

‘your-non-root-user’@‘localhost’ IDENTIFIED BY

‘your-non-root-password’;

Obviously with my specific parts.

It’s really unbelivable.

What happens when you attempt to access the database via the MySQL client program? For example

mysql -u your-non-root-user -p your-non-root-password your_database_development

After connecting, try doing something like the following:

select * from

-Conrad

5

Conrad Taylor wrote: