connect mysql
delete from user where user='xxx' ;
flush privileges;
and you also can use revoke statement
- Original Message -
·¢¼þÈË: behrens <[EMAIL PROTECTED]>
ÊÕ¼þÈË: <[EMAIL PROTECTED]>
·¢ËÍʱ¼ä: 2001Äê11ÔÂ20ÈÕ 16:17
Ö÷Ìâ: how to delete user from the usertable
> How do i delete
What's your mysql version
if use mysql 3.23 , you can use mysqlcheck -r -A
to repair all database. or
mysqlcheck -r webbbs
if use mysql 3.22
isamchk -r abc1212.ISM to repair .ISM table
myisamchk -r abc1212.MYI to repair .MYI table
- Original Message -
·¢¼þÈË: JunSeon Oh <[EMAIL PRO
Hi,
I want to insert 5M text into a table, and I execute the statement 10
times at one time.
And then it execute very slowly, it use 27 minutes to insert all the 10
sql statements.
Can anyone tell me how to optimize it, let it faster ?
And Is the mysql locked on table or on the row?
hi,
I execute two check command using C, it report "Command out of sync
error".
the original statement is as below:
sprintf(ls_sql, "check table aa");
mysql_real_query(dbfd, ls_sql, strlen(ls_sql));
num = mysql_affected_rows(dbfd);
sprintf(ls_sql, "check table bb");
mysql_real_qu
My mysql is 3.23.42
I use the mysqlcheck -A to check my database first,
it report ok
and then I try the myisamchk
use it as: myisamchk /var/lib/mysql/*/*.MYD
it report:
myisamchk: error: -1 when opening MyISAM-table '/var/lib/mysql/xx/dd.MYD'
myisamchk: error: '/var/lib/mysql/xx/cc.MYD' doesn
hi,
I have two machine, install mysql, create same database.
I want these two database can be the same at any time. in other word, if
one table be inserted a record in one machine, then the same table in
another machine can be inserted same record also.
Who can tell me how to realize this fu
My pc is linux os, install mysql , one table have a field longtext, and
when it become 26M, when insert recode, it report "get 127 error table
handle".
I do not know what can let mysql occured this error, and how to protect
it.
when it occur error, I have to stop the mysql, repaire it
Hi, what is the default port to listen to on MySQL?
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-
Before posting, please
I insert a sql statment, size is 30M, a field type is longtext
using
mysql dbname < filename
in file, it is a sql as insert into table ... values ...
where file size is 10 M, it execute well, but report error when file size is to 30M
it report:
ERROR 2006 at line 1: MYSQL server has
