Sorry, Sean, I think I forgot in the emails to you to mention that the
MySQL server is running on a Solaris machine, I am trying to connect the
database from a XP machine which is the one I am using.
I tried the same program in other Solaris machine, it works fine. I also
noticed that the other So
Thanks for your speedy reply.
I already turn off the firewall in the XP machine. I have no idea about
the system sonfiguration on the Solaris machine.
I did this experiment as well: I installed Mysql 4.1.5 on XP machine, then
use the same java program to connect to the 'test' data base from the
i
Its been a while since i've dealt much with MySQL permissions, but do you need
to explicitly state 'localhost' as the machine in some circumstances.
The other thing i thought of is a guess, as i don't program Java, but have had
an analogous problem using Perl. It it possible that Java is dealin
Answers intermixed. See below
"Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 11/03/2005 04:28:08 PM:
> Thank so much for the detailed explaination. I do appreciate it.
>
> It's more clear now. But I still have a question:
>
> I do see 'root' after: select user,host from mysql.user;
>
> Then I
Thank so much for the detailed explaination. I do appreciate it.
It's more clear now. But I still have a question:
I do see 'root' after: select user,host from mysql.user;
Then I did this as you said:
GRANT SELECT ON mydatabase.* TO [EMAIL PROTECTED] IDENTIFIED BY 'mypassword';
then I issue:
"Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 11/03/2005 02:54:16 PM:
> I have a question related to connection control.
>
> If I want to connect to one database A in the server from another
> computer. I am using 'root' and it password. But how shall I add the
host
> in which table of which databa
I have a question related to connection control.
If I want to connect to one database A in the server from another
computer. I am using 'root' and it password. But how shall I add the host
in which table of which database (mysql?) so that the user 'root' can
connect to the database?
A little expl
