mysql 4.0.2 preoblem

2004-08-03 Thread Cres Justado
can anyone help me with my problem regarding mysql 4.0.2. I'm having a 
problem with the sequencing of the auto incremnt field. if my application 
makes an insert mysql inserts the new row somewhere in the middle of the 
sequence. example

autoinc_field   data_field
1   qwe
2   ert
3   ou
20 oiu
4  ngf
5  ljn
.
.
.
.
18okj
19thd
in my example the row 20 was inserted in the middle of the sequence instead 
of inserting  it in the last row.

_
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


connecion error

2004-01-04 Thread Cres Justado
Hi!

I am new in using mysql database server. I have installed MySQL Database 
server on redhat advance server. But when I try to access the database 
server using a the mysql client software for windows it gives an error Host 
my IP Address is not allowed to connect to this MySQL Server.. How will I 
solve this problem?



Thanks,

Cres

_
The new MSN 8: advanced junk mail protection and 2 months FREE* 
http://join.msn.com/?page=features/junkmail

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]