Hai
While setting up the replication environment i am
getting the following error in the master ..what might
be the problem
020108 13:20:00 Slave thread: error connecting to
master: Can't connect to MySQL server on '' (10049)
(0), retry in 60 sec
I followed all the steps correctly given in the
Im using the NOW() function to store the date and time in my database table
that a person fills out my form. But I noticed that its 2002-01-07 11:51pm
but the time shows up as 2002-01-08 01:51:18. It appears to be two hours
off. How can I adjust the time to match my time zone?
"Always an Ema
--- D Bamud <[EMAIL PROTECTED]> wrote:
> version of MySQL 3.23.39 / MySQL 4.0.x. I do not
> want to buy a book that is
> outdated or going to be outdated. Please comment.
Yes, but good books are good books. This is a good
book.
I use SuSE 7.3, but get a lot of information from 2
books I favor
Hi!
I need to syncronize two indentical MySQL databases.
The A database is on a server permanently connected to the Internet
trough an ADSL connection, while the B database is on a server equipped
with an ISDN connection.
How can I keep the two databases identical?
Thanx
Marco Frazzoli
PS: S
I installed MySQL in my local dir (~) (RH Linux7.2). Created database
successfully. Can operate on this database at mysql> prompt. I am trying to
access the same database from my Java application THAT WAS working fine with
the RMP installation of MySQL. When I run the program it gives SQLException
suitable for 3.22.x & 3.23.x, but not enough good for 4.x
--
Zu Zhihui <[EMAIL PROTECTED]>
- Original Message -
From: "D Bamud" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 08, 2002 1:51 PM
Subject: Re: MySQL Book
> Ok. So majority is towards Paul DuBois. I went to
I wondering how to know a MySQL version is stable or development. I knew
3.23.* are stable, 4.0 and 4.0.1 are development. But what's the future
MySQL versions? Is there a regular habits like the version number of Linux
Kernel?
Thanks in advance!
--
Zu Zhihui <[EMAIL PROTECTED]>
On the MySQL download page, there is a warning for GCC 2.96/x86/Linux that
reads thus: "Several of our users have reported random crashes and table
corruption with MySQL binaries compiled with gcc 2.96 on the x86 Linux
platform."
I was wondering what kind of crashes users had experienced. Cra
Ok. So majority is towards Paul DuBois. I went to the
http://www.newriders.com/ to see about this book and found that this book
was published in Dec 1999. Is new edition out. Is it good enough for new
version of MySQL 3.23.39 / MySQL 4.0.x. I do not want to buy a book that is
outdated or going to
Hi,
I was wondering how I would insert a value which is present in another
table, specifically, this is a member_id field from a main members table
which acts as a foreign key in this table (Although I know this not
truly possible in MySQL). I think this attempted, although non
functional, insert
We have been using LDAP for our user database for some years. We are
now getting into MySQL, and I would like to be able to grant or deny
access within MySQL based on LDAP user information, rather than having
to maintain a separate database of users within MySQL. I understand
that there is prese
Dear "- -":
I would revoke all permissions for dummy, then create new permissions for
users on a database-by-database basis. If you look at the syntax for GRANT
in the manual, you can stipulate which databases a user would have access
to.
A word of caution: don't use root. Create a user for your
Hi all,
I have set up mySQL database server on my web server running on RH Linux7.2.
There are 2 user accounts, root and dummy who can access to databases. I'm
wondering how to restrict the accesss to mysql (the db which stores user id,
password, etc...). Right now, both users can run select, de
My situation is to access a remote MySQL server, and of course
I do care about traffic. Suppose In a script there's a query:
$result = mysql_query ("select * from employ where age>45")
or die ("Invalid query");
I am just wondering that if MySQL server would return all the query
result in tot
At 16:52 -0600 1/7/02, Rick Emery wrote:
>I don't know if this is a bug or a feature. Just an observation concerning
>creating MYISAM tables with auto_increment.
>
>CREATE TABLE mytable (myval int auto_increment unique ) AUTO_INCREMENT=9000;
>INSERT INTO mytable VALUES(NULL);
>INSERT INTO mytable
Use decimal(10,2) for fields that will contain monetary values. If you
use a float it will round the values, while decimal won't.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Keith W [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 3:07
hi
i want to know, about
after i make new user in mysql , i try to check in user tables and i get it
but if i look for in another table ( like : db, host, columns_priv, tables_priv)
why ??
thx for all
Yuyun Kusuma
--
Hi-
I know this is wrong because it doesn't work:
select name from table1
where id="03" and not in (select id from table1 where (id <> "10") AND (id
<> "20") AND (id <> "37")
table1
name id
a 03
a 11
a 12
a 13I want a returned because it has a 03 and not a 10, a 20,
* David V. Edelstein
> I'm trying to create a select statement that will go into a table find the
> number of rows in the table then select a single random row and
> return it. I
> am using Java/mySQL with the mm.mysql JDBC drivers. I've been
> playing around
> with the following statement but it
Hi,
I'm starting a reporting application project and I want to use mysql as
the backend to store the data... The only problem is my data I'm
grabbing the information off a message bus and each object has an
undefined number of
"field=value" pairs...
does anyone know of documentation or w
-Original Message-
From: Investor [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 12:37 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: ms acess to mysql
Hi, I am new to mysql and this list.
Has anyone converted data in MS Access to Mysql?
---yes.
I would thi
You can also set the auto_increment start value in the CREATE table:
CREATE TABLE mytable (
myval int auto_increment)
AUTO_INCREMENT=100;
Note that the AUTO_INCREMENT=100 is set outside of the fields' definitions.
However, when you delete all records with "DELETE FROM mytable", the counter
will
I don't know if this is a bug or a feature. Just an observation concerning
creating MYISAM tables with auto_increment.
CREATE TABLE mytable (myval int auto_increment unique ) AUTO_INCREMENT=9000;
INSERT INTO mytable VALUES(NULL);
INSERT INTO mytable VALUES(NULL);
these above INSERTS create entr
Hi!
Please upgrade to 3.23.47. Many bugs have been fixed since .41.
This is a bug in gcc-2.95.3, at least in some builds of the compiler.
Fix: edit mysql/innobase/btr/btr0sea.c
and replace
UNIV_INLINE
about on line 455 (in MySQL-3.23.47) of the file by
static
Or download a ready binary fro
I'm porting a MS-SQL system to a Solaris machine running Mysql.
In the MS-SQL there is a datatype of money what would be the proper
datatype in mysql to use as a replacement for this?
Keith
-
Before posting, please check:
Try the -q option to mysqldump so it doesn't buffer up the whole thing.
Quentin Bennett wrote:
> Hi,
>
> Doing a mysqldump of a large table to /tmp, I filled up /tmp, which caused
> mysqld to reset.
>
> This is while using 3.23.40 on Solaris 2.6
>
> What additional information should I provi
Hi,
Doing a mysqldump of a large table to /tmp, I filled up /tmp, which caused
mysqld to reset.
This is while using 3.23.40 on Solaris 2.6
What additional information should I provide to help address this problem?
From: Quentin Bennett
To: [EMAIL PROTECTED]
Subject: [Mysql crash]
>Descriptio
On Mon, Jan 07, 2002 at 03:52:10PM -0800, Viorel C wrote:
> I'm a newbie in DB administration. Could somebody tell me what do I need to
> start a web-based project for book listing, mail lists etc, all retrieved
> from a database updated by LAN users and listed on a web page?
Go for www.freshmeat
From: Jens Mildner <[EMAIL PROTECTED]>
> Every year from years.year should be returned along with the
> number of games that have been released in that year...
> Years in which no games were released are returned with a
> gamecount of 1.
This is a side effect of the JOIN syntax. Try this:
Jens Mildner wrote:
> Hello MySQL-users !
>
> Houston, I've got a problem here.
>
> I'm running the following query from a PHP-Script:
>
> SELECT years.year AS yearlist, count(years.year) AS gamecount
>
> FROM years
>
> LEFT JOIN games
>
> ON years.year = games.release_year
>
> GROUP
Jens,
You need to select on the games on the left, to ensure that you don't end up
with years on the left with no corresponding game records. Try this:
SELECT years.year AS yearlist, count(years.year) AS gamecount
FROM games
LEFT JOIN years
ON games.release_year = years.year
GROUP BY years.y
Hello MySQL-users !
Houston, I've got a problem here.
I'm running the following query from a PHP-Script:
SELECT years.year AS yearlist, count(years.year) AS gamecount
FROM years
LEFT JOIN games
ON years.year = games.release_year
GROUP BY years.year
ORDER BY gamecount DESC, yearlist
T
try restarting port mapper on the linux box.
also make sure swap is not almost used as sockets uses tmp to swap out tcp
requests.
-Original Message-
From: Michael J. Cermak, Jr. [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 19:36
To: [EMAIL PROTECTED]
Subject: Newbie needs serious he
Hi,
I have another example of this strange behaviour. I've managed to dump
most of the table and then after certain row got the error 127. This
machine is linux 2.2.17 in this particular example operating on table
close to the 2GB limit.
mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686)
>Description:
Make failed with the following errors:
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti
-fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic -o mysqld sql_lex.o item.o
item_sum.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item
I'm running RedHat Linux 7.0 (2.2.16-22) with MySQL 3.23.32... It's been
working perfectly until suddenly this morning at 1:40AM it stopped
responding.
I restarted the whole system, and still nothing. It says "Running" with
the PIDs when I do a "mysqld status" and when I do a "mysqld start" it
r
Recently mysql query's fail on different type of errors.
Mysql processes are restarting every few minutes !
I found out that if I disable the quota on the disk the mysql
is install the problems are workaround.
mysql user and group got lot of free disk space :
>/sbin/quotaoff /dev/hda4
>quota -v
> D Bamud wrote:
>
> > Which is the **best, easy, compact** book available on MySQL. Delhi India.
>
MySQL by Paul Dubois, New Riders Publishing, ISBN 0-7357-0921-1
--
Regards,
Doug
-
Before posting, please check:
http://w
D Bamud wrote:
> Which is the **best, easy, compact** book available on MySQL. Delhi India.
I found that MySQL by Michael Kofler (Apress, ISBN 1-893115-57-7) was a
rather good and informative book.
Cheers,
Markus
--
Markus Lervik
UNIX-administrator with a kungfoo grip
Vaasa City Library - Reg
--- Simon Green <[EMAIL PROTECTED]> wrote:
> Hi Jeff
> As long as you have a user that has access to all of
> MySQL and can enter
> from root on the systems, what you call it is not
> important.
> Infact it is a good thing to change the root user
> name for security.
> Simon
Thanks for the respon
Have you verified that the mysql internal data bases don't exist?
If you are running a Win binary, they should already exist. I don't even
think mysql_install_db is part of the Win dist. It is a shell script used
in UNIX installations.
~rob
Sent: Monday, January 07, 2002 11:38 AM
To: [EMAIL
I am using mysql 3.23.39 on Linux Redhat 7.1...
I use the following queries,
CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY,
message CHAR(20));
CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY,
message CHAR(20));
INSERT INTO t1 (message) VALUES
("Testing"),("table"),("t1");
INSERT INTO t2 (me
Hi Erwin
Try
Select afield from atable where index=(select max(index) from atable);
[]s
Paulo Botelho
- Original Message -
From: "Erwin Hogeweg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 07, 2002 12:47 PM
Subject: Neede MySQL query Equivalent.
> Hi,
>
> Coul
Hi Simon,
Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the
error:
"mysql not found". How can I find mysql server?
Cindy
>>> Simon Green <[EMAIL PROTECTED]> 01/07 10:05 AM >>>
No but you can start MySQL with out grant tables.
See on line manual and don't know
I'm trying to create a select statement that will go into a table find the
number of rows in the table then select a single random row and return it. I
am using Java/mySQL with the mm.mysql JDBC drivers. I've been playing around
with the following statement but it doesn't seem to like the MAX(user
No but you can start MySQL with out grant tables.
See on line manual and don't know password.
Or ./mysql --help
Simon
-Original Message-
From: Cindy Yu [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 17:48
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Mysql con
Hello list,
The problem:
I have two mysql-servers A and B with the same Database DB. Sometimes, I
would like to make a snapshot of DB from A and then synchronize DB on B
with this snapshot. OK, logical dump on A, destroy DB on B and import
would work, but this ain't elegant, or?
Is there a bette
My ISP has version 3.22.23b-log installed on my hosting service machine,
and I have repeatedly encountered problems importing tables to the database
that have indexes that are not given a default value or that are not
specifically stated to be NOT NULL.
Others using the same programs have said
Hello,
I have a question for you. I have a Solaris 5.6 server running Mysql. It is our
company' website. I just know the server's root password and I don't know mysql
database user name and password. Is it possible to login to Mysql database by using
the server root and its password? How can
>> MySql & mSQL O'Reilly press isbn 1-56592-434-7
is probably the worst book about mysql.
Please note that the O'Reilly book was originally suppose to be about msql
but near the end of the project they noticed that mysql was gaining
popularity on msql so they threw in some information on
mysql.
I am running mysql on windows 98 & could not get the
mysql_install_db to work.
Anyone familar with this problem or know a way around?
I checked the folder 'scripts' but did not see
mysql_install_db in there ???
thanks in advance
=
Regards,
Investorclb
Hi Gerald,
Sorry ... the OS is Solaris 7, running on a Sun Ultra
Sparc 5. I downloaded the Sun Solaris 2.7 Sparc
static binary of MySQLGUI 1.6
(mysqlgui-solaris-2.7-sparc-static-1.6.gz). I
gunzipped the file and attempted to execute it and got
this error message:
"ld.so.1: mysqlgui-solaris-2.
apologies, I don't have the space to keep all mails as this group puts out a
100+ messages a day I glance through them and if they are not relevant I
delete them unless I know I'll need them in the future.
-Original Message-
From: Doug Thompson [mailto:[EMAIL PROTECTED]]
Sent: 07 January
thank god, thought I had pissed off the gods of the list by asking to many
questions.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 16:45
To: Matthew Darcy
Cc: MySql List
Subject: Re: just got this through whats going on ???
The unsubscribe
The unsubscribe request came from [EMAIL PROTECTED] according to the
headers. I'd bet this was an accident. The same thing happened to me a
while back. If you'll look at the bottom of my reply, you'll notice that
*my* unsubscribe info is included. (Usually, I cut that section out of my
replie
You need to create a user with login privileges from any location.
GRANT ALL PRIVILEGES ON *.* TO foo@"%" IDENTIFIED BY 'apassword' WITH
GRANT OPTION;
AND, as is appended to each post,
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Mon, 7 Jan 2002, Arne Mueller wrote:
> I wonder whether one can use the full text indexes in mysql to find out
> what words in a document are likely to be relevant key words.
>
> . . .
>
> I'd be nice to have a command like this:
>
> select keywords(10.0) from MyDocs where DocId = 666;
>
> . .
I never sent a mail to unsubscribe ???
have I been booted from the list or what ??
Hi! This is the ezmlm program. I'm managing the
[EMAIL PROTECTED] mailing list.
To confirm that you would like
[EMAIL PROTECTED]
removed from the mysql mailing list, please send an empty reply
to this addr
Yes you can..
We have a log called mysql.log that has user@IP/domain and then the
question.
All you need to do is edit my.cnf to make shore it is on.
We keep all the logs can just gunzip them up.all you need is a perl
script to get the data back out.
Simon
-Original Message-
From: Fr
>>
>> If you have rights to access other database then simply type
>>
>>
>> Bye
>>
>>
>> I want to select from two databases at one time, like
>> use forum
>> select from users a, auth.users b where a.name = b.name
>> The databases are running on the same mysql server. Do I have
Hi,
I've installed MySql on a RedHat box and configured log-bin. Everything is
running OK.
My question is, if a user does any insert, delete or update, can I see which
user (username) has performed that action?
Where can I log this information and retrieve it later, for auditing
purposes?
Thanks
I am having the same problem.
My laptop jaguar is not allowed to connect to my server (jordan)
I get jaguar is not allowed. I think it is something to do with granting
user root from jaguar to root@jordan ??? I am trying to figure out what is
going on ?
If you read back I posted a couple o
After a long day of trying and reading all sorts of manuals and faqs and
newsgroups
I still can't create tables with the mySQLgui (1.7.5.2 windows) running in
win 2000 pro standalone feature
I can read the test database (empty of course)and the users dbase
in neither of them I'm able of creating
Jean-Luc,
for InnoDB variables look at section 2 of http://www.innodb.com/ibman.html
Regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
.
I would need those to fini
I've downloaded and am trying to use the MySQLGUI as well
and had the same problem, but figured it had to me a
firewall problem so I opened up port 3306 in my IPchains
and it let me through only now it's telling me that the
computer I am coming from is not allowed to connect to
MySQL server.
* Manjeet
> I am inserting user details from a file. The file has users seperated by
> commas(,)
>
> example of file
>
> manjeet,tom,tim,,john,alexander
>
>
> Using perl script i am reading the file and seperating user info at commas
> and inserting into database.
>
> Now my problem is that i don'
Hi Jeff
As long as you have a user that has access to all of MySQL and can enter
from root on the systems, what you call it is not important.
Infact it is a good thing to change the root user name for security.
Simon
-Original Message-
From: Jeff Corliss [mailto:[EMAIL PROTECTED]]
Sent:
Hi All,
New to mySql. I've setup ok, running ok, read thru
the privilege system docs. My question is about the
user "root": is it absolutely necessary to keep this
user or is it ok to delete the root user (after
setting up an equivalent "super-user" under another
name)?
Thanks,
Jeff
___
I am inserting user details from a file. The file has users seperated by
commas(,)
example of file
manjeet,tom,tim,,john,alexander
Using perl script i am reading the file and seperating user info at commas
and inserting into database.
Now my problem is that i don't want to insert the fourth u
Hi!
Are you running mysqld under the safe_mysqld script, which automatically
restarts mysqld after a crash?
If yes, look at the 'hostname'.err file and send its contents to me.
Or, if you run mysqld from the command prompt, capture what mysqld prints to
the command prompt window.
If mysqld doe
Hi Fred,
You might want to look into www.netsaint.org . The mysql plugin is
in the contrib directory, you can add functions like restart,
althougth safe_mysqld should restart the daemon itself.
best of luck,
Ken
- Original Message -
From: "Fred Taurus" <[EMAIL PROTECTED]>
To: <[EMAIL P
Your question is too vague to answer.
What operating system and hardware are you running.
Which file did you download?
What EXACTLY was the error message?
EDA Peach wrote:
> Hi,
>
> Wondering if anyone might be able to help me with a
> slight problem. I downloaded the static version of
> the
This is not a MySQL question.
You should take it to a Linux list.
The answer, I think, is "You don't."
SankaraNarayanan Mahadevan wrote:
> Hi,
>
> I have developed an application in PHP/MySQL in Linux
> environment. I need to burn it in a CD and give it to
> the client. I need to do one thing -
Hello
I am using MySql 3.23.47 on Linux (2.2.17-14smp) and InnoDB
I do Intensive test (=Insert + Update + Select) using C API and
running the processes on the same machine.
Every thing work fine, BUT,
some time to time I got some "Lost connection to MySQL ..." (errno = 2013)
The query concer
Hi,
Could somebody please help me with the following. I want an equivalent for:
select afield from atable where max(index) = index;
I tried this, and that works, but it seems to me that there is a better
(cleaner) way to accomplish the same.
select afield from atable order by ind
Sascha Kettner wrote:
> Hi!
>
> I have the following script to be executed via post from a web-form; the
> var. Pin, msisd and knd are given by the form but however, the script is
> not working. I always get no results as if there are no matches, but
> this isnt right! This is regardless which
I have changed a fulltext variable ft_min_word_len from the default 4 to
1, and the manual says to rebuild my fulltext indexes once again.
I verified that this variable changed with SHOW VARIABLES and it did change.
I have tried optimize table, analyze table, repair table which all
finished wit
> -Original Message-
> From: Viorel C [mailto:[EMAIL PROTECTED]]
> Sent: 07 January 2002 23:52
> To: [EMAIL PROTECTED]
> Subject: hey folks!
>
>
> I'm a newbie in DB administration. Could somebody tell me what do I need
> to start a web-based project for book listing, mail lists etc, all
If you are using php, the function you want is mysql_data_seek($result,0) to
reset the result set.
John Lodge
-Original Message-
From: Walter D. Funk [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 2:04 PM
To: [EMAIL PROTECTED]
Subject: TEMPORARY TABLES
Ive just another quest
Dear All,
I wonder whether one can use the full text indexes in mysql to find out
what words in a document are likely to be relevant key words.
I've several thousand text documents in a table with a full text index,
and I can search for documents corresponding to some given keywords
using the
Me...
I would use MySQL (as it if very fast, and never brakes)
I also like PHP as it just fits in with MySQL so well!
Simon
-Original Message-
From: Viorel C [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 23:52
To: [EMAIL PROTECTED]
Subject: hey folks!
I'm a newbie in DB administrati
I've read the TODO list regarding the fulltext search
and noticed that it doesn't include any more options
for truncating. I'm in need of a database which
supports pre-truncating - masking would be great too
:) It would be great if my favourite database would
get full pre-truncation :)
Q: Will pr
I´ve just another question,
I couldn´t get the info from the manual, I suppose that´s because
I don´t know other basics on Mysql .. :-(
I´ve been using the temporary table, and it works well, but, I can only
display the results set just once in my script, is that normal?
I´ve been trying to pagi
I'm a newbie in DB administration. Could somebody tell me what do I need to
start a web-based project for book listing, mail lists etc, all retrieved
from a database updated by LAN users and listed on a web page?
Thanks in advance!
Viorel C
-
Initially you will have had no password, so
setting root's password to 'test1' would be done with:
mysqladmin -u root password test1
To change this password to test2 use:
mysqladmin -u root -ptest1 password test2
Regards
M
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PRO
look for 'GRANT SYNTAX' in the manual.
Regards
M
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 13:16
To: MySql List
Subject: creating users ??? I must be blind.
Hi,
the manual referes to creating users using mysqladmin and mysqlaccess, I
have
MySql & mSQL O'Reilly press isbn 1-56592-434-7
-Original Message-
From: D Bamud [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 1:04 PM
To: [EMAIL PROTECTED]
Subject: MySQL Book
Which is the **best, easy, compact** book available on MySQL. Delhi India.
--
Hi,
[..]
> produces the following error messages.
>
> /tmp/ccPhnnJk.o: In function `main':
> /tmp/ccPhnnJk.o(.text+0x14): undefined reference to `mysql_init'
> /tmp/ccPhnnJk.o(.text+0x5a): undefined reference to `mysql_real_connect'
> /tmp/ccPhnnJk.o(.text+0x6d): undefined reference to `mysql_que
Hi,
the manual referes to creating users using mysqladmin and mysqlaccess, I
have looked at these commands and cannot see how I can create mysql users.
Am I missing something that is staring me in the face ?
Thanks,
Matt.
(slowing getting the hang of what is going on now)
---
Hi,
my laptop is running windows 2000 and is called jaguar.
I have mysql running on a linux server called jordan.
when I fire up mysqlui and tell it to connec to jordan as root I get
prompted for a password. I enter the password (that I have tested and is
correct) and it say at the bottom of th
MySQL by Paul DuBois
www.newriders.com
ISBN 0-7357-0921-1
This book is easy to use.
It gets it right when it commes to newuser V olduser.
Its not that compact but it is to the pont.
Simon
PS you also helps on the list some times..
-Original Message-
From: D Bamud [mailto:[EMAIL PRO
Hello,
I have corrected the code as I would have written it. Also are you sure the
file mysql.h
is where you think it is?
#include
#include
main()
{
int sel;
MYSQL mysql=NULL;
MYSQL *connection;
MYSQL_RES *result;
mysql_init(&mysql);
if(mysql == N
I would need those to finish the on-line help in my mystatus and myvars
moodss modules for the 4.0.1 server.
Please let me know if this is not the right place to post this.
in SHOW STATUS:
Com_ha_close
Com_ha_open
Com_ha_read
Com_show_binlogs
Qcache_queries_in_cache
Qcache_inserts
Qcache_hits
Qc
Which is the **best, easy, compact** book available on MySQL. Delhi India.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request thi
I just installed mysql under my new linux system.
I did a test command of
./mysqladmin -u root password new-password
thus setting the root users password to "new-password"
this appeared to work.
I now want to change the root users password now that I have the syntax
correct.
I do a
./mysqla
hi.
yes it is possible.
1. Create an new column which has an auto_increment option
2. Insert the first dataset manually as followed:
" INSERT INTO test (auto, char) VALUES ('100', 'Hello World!') "
3. From there on your auto column will count starting from 100, 101, 102,
...
Greeting
- D
Manish,
If you manually insert a record with a value of 100 in the auto_increment
field, then it will work from then on.
If there is a way to create the table telling the value to start at 100,
then I don't know what it is.
Hope this is a help
John Lodge
-Original Message-
From: Manish
Hi
Is it possible auto_increment start 100 instead of 1 .
for example
create table a
( a int(10) primary key auto_increment 100);
Manish Mehta
E-mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.
Prabhu,
4.0.x is the development version. 3.23.xx is better tested. But 4.0.1 looks
good now that it has been out a couple of weeks. Upgrading to 4.0.1 is
another possibility.
Regards,
Heikki Tuuri
Innobase Oy
---
MySQL/InnoDB - transactions, row level locking, and foreign key support for
MySQL
I can report a major crash, when entering passwords and mail it to the
list as written in the file "mysqlbug".
If you are interested please read the following lines and the .crash.log
(perhaps you can give me a hint what could have been wrong):
I am working with an Apple PowerBook G3 with MacO
1 - 100 of 128 matches
Mail list logo
