We're getting a little far afield...but here is the incantation:
mysql> grant all on DBNAME.* to 'USER'@'IP-ADDRESS' identified by
'PASSWORD';
mysql> flush privileges;
cheers,
Travis
On Tue, Oct 30, 2012 at 2:40 PM, Amit Nithian wrote:
> This error is typically because of a mysql permissions
This error is typically because of a mysql permissions problem. These
are usually resolved by a GRANT statement on your DB to allow for
users to connect remotely to your database server.
I don't know the full syntax but a quick search on Google should yield
what you are looking for. If you don't c
Like Amit said, this appears not to be a Solr problem. From the command
line of your machine, try this:
mysql -u'readonly' -p'readonly' -h'10.86.29.32' hpcms_db_new
If that works, and 10.86.29.32 is the server referenced by the URL in your
data-config.xml problem, then at least you know you have
Hi,
This is my data-config file:-
and password is not null. and 10.86.29.32 is my unix server ip.
regards,
kunal
On Tue, Oct 30, 2012 at 2:42 PM, Dave Stuart wrote:
> It looks as though you have a password set on your unix server. you will
> need to either remove this
It looks as though you have a password set on your unix server. you will need
to either remove this or ti add the password into the connection string
e.g. readonly:[yourpassword]@'10.86.29.32'
>> 'readonly'@'10.86.29.32'
>> (using password: NO)"
On 30 Oct 2012, at 09:08, kunal sachdeva wrote:
Hi,
I'm not getting this error while running in local machine. Please Help
Regards,
Kunal
On Tue, Oct 30, 2012 at 10:32 AM, Amit Nithian wrote:
> This looks like a MySQL permissions problem and not a Solr problem.
> "Caused by: java.sql.SQLException: Access denied for user
> 'readonly'@'10.86.
This looks like a MySQL permissions problem and not a Solr problem.
"Caused by: java.sql.SQLException: Access denied for user
'readonly'@'10.86.29.32'
(using password: NO)"
I'd advise reading your stack traces a bit more carefully. You should
check your permissions or if you don't own the DB, chec
