Re: Remote MySQL
- From: tristram.scott@xxxxxxxxxxxx (Tristram Scott)
- Date: Thu, 06 Apr 2006 15:10:06 GMT
keiler <keilerg@xxxxxxxx> wrote:
I need to connect to a remote MySQL data base, but I don?t find the way.
I have a similar data base in my computer and I get the connection in this
way:
conn=database('red_neuronal','root','','com.mysql.jdbc.Driver',
'jdbc:mysql://localhost/red_neuronal')
When I try to connect to other computer, where there is the same data
base, I use:
conn=database('red_neuronal','root','','com.mysql.jdbc.Driver',
'jdbc:mysql://10.34.13.50/red_neuronal')
but I get the error:
null, message from server: "Host 'biouci-14.uci.cu' is not allowed
to connect to this MySQL server"
Please help me
That would likely be a problem with the permissions you have on the remote
server. To confirm, try connecting using the command line mysql client
application (i.e. without MATLAB at all) and see what it tells you.
I expect you are going to need to give yourself permission to connect from
your localhost explicitly, or from all hosts.
Ask you database administrator for some help with that, or read about the
grant command in the mysql manual. Something like this:
GRANT all ON red_neuronal.* TO 'scott'@'%' IDENTIFIED BY 'tiger';
And if you have not already done so, make sure you set a root password for
the database.
--
Dr Tristram J. Scott
Energy Consultant
.
- References:
- Remote MySQL
- From: keiler
- Remote MySQL
- Prev by Date: Re: student t-distribution
- Next by Date: Re: Summing every x elements
- Previous by thread: Remote MySQL
- Next by thread: get the coefficients and degree of a polynomial
- Index(es):
Relevant Pages
|
