由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - How to get authorized using JDBC with MySql databses?
相关主题
configuration about mysql!!!请问MYSQL JDBC如何获得插入记录的编号
MySQL Quietly Drops Support For Debian Linux(ZZ) (转载)MySQL安全问题
Is there any small free database support Java ?请教怎么关闭MYSQL的debug信息
How about JDBC for mysql?求救,咋样架起来自己的database?
问个关于JDBC和MySQl的问题[转载] jdbc with access 2000 problem
怎样从mysql换成sql server?mysql question
HELP!!!Connect to MySQL in JSPwhere is password file for mysql
纪录查找问题下载mysql问题
相关话题的讨论汇总
话题: mysql话题: user话题: jdbc话题: import话题: databses
进入Database版参与讨论
1 (共1页)
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.*;

1 (共1页)
进入Database版参与讨论
相关主题
下载mysql问题问个关于JDBC和MySQl的问题
忘记mysql root的password了要怎么重设?怎样从mysql换成sql server?
how to get the result in the middle of resultset?HELP!!!Connect to MySQL in JSP
database developer 有必要学hadoop以后转行成hadoop develoepr纪录查找问题
configuration about mysql!!!请问MYSQL JDBC如何获得插入记录的编号
MySQL Quietly Drops Support For Debian Linux(ZZ) (转载)MySQL安全问题
Is there any small free database support Java ?请教怎么关闭MYSQL的debug信息
How about JDBC for mysql?求救,咋样架起来自己的database?
相关话题的讨论汇总
话题: mysql话题: user话题: jdbc话题: import话题: databses