hi, all,
I have a window mysql verison, which works really well with SyncLog.
Now I have a vm linux, and install MySql4.0 server on it. I can use
command line, mysql-administrator to access it very easily on linux.
But I can not access it via SyncLog on my windows.
For example, my Linux server ip is 192.168.10.204, and my windows is
192.168.10.95, window host name is "MyHostWin" , and then I created a
linux user test with passwd xxx, and then I use mysql-administrator
create a same mysqls user test with the same passwd,and then i run :
grant all on test.* to test@'%';
everything looks fine, i can access the mysql in linux in comman line,
but then i go back to my windows, connect to 192.168.10.204, user name
is test, passwd is xxx, and database is test, the problem is the
synclog always show "Error No:1054, Access denied, for user
test@MyHostWin (Using Passwod Yes)"
I don't know where i did wrong, test@% means i should be able to access
it at anywhere, no matter the client ip address is, right?
Thanks.
I have a window mysql verison, which works really well with SyncLog.
Now I have a vm linux, and install MySql4.0 server on it. I can use
command line, mysql-administrator to access it very easily on linux.
But I can not access it via SyncLog on my windows.
For example, my Linux server ip is 192.168.10.204, and my windows is
192.168.10.95, window host name is "MyHostWin" , and then I created a
linux user test with passwd xxx, and then I use mysql-administrator
create a same mysqls user test with the same passwd,and then i run :
grant all on test.* to test@'%';
everything looks fine, i can access the mysql in linux in comman line,
but then i go back to my windows, connect to 192.168.10.204, user name
is test, passwd is xxx, and database is test, the problem is the
synclog always show "Error No:1054, Access denied, for user
test@MyHostWin (Using Passwod Yes)"
I don't know where i did wrong, test@% means i should be able to access
it at anywhere, no matter the client ip address is, right?
Thanks.