m****f
发帖数: 32 | 1 I run MySql under Solaris 8 very well. I inserted a user called
jack into the user table of mysql database like this:
mysql>INSERT INTO user (Host, User, Password)
-> VALUES('localhost', 'jack', PASSWORD('johnson'));
Query OK, 1 row affected (0.00 sec)
I checked the table, and see that user jack is there.
Here is a part of my JDBC test code, which accesses the demodb database
I have created for test use.
import java.net.*;
import java.sql.*;
import java.io.*;
import java.util.*;
class MyS | e**c
发帖数: 195 | 2 My guess is sth missing from the user table,
did you add your host IP to the user table?
You might want to add a % as host IP, which means query
from any host are allowed, in the user table.
【在 m****f 的大作中提到】
: I run MySql under Solaris 8 very well. I inserted a user called
: jack into the user table of mysql database like this:
: mysql>INSERT INTO user (Host, User, Password)
: -> VALUES('localhost', 'jack', PASSWORD('johnson'));
: Query OK, 1 row affected (0.00 sec)
: I checked the table, and see that user jack is there.
: Here is a part of my JDBC test code, which accesses the demodb database
: I have created for test use.
: import java.net.*;
: import java.sql.*;
|
|
