This:
SELECT * FROM machines INNER JOIN people ON
machines.machinesID=people.peopleID;
Is not producing the same results as this:
SELECT lastname, model FROM people, machines WHERE machines.peopleID =
people.peopleID;
Can someone please tell why, what's wrong?
(What happens is that the wrong
I needed to add a new, autoincrementing, primary key column
to a table and have been struggling to figure out how to
assign an initial, unique value to each row.
I finally accomplished my task, but feel sure there's an
easier way.
Here is my solution:
1. Add the column:
alter table mytable
Ok, should be this:
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.peopleID;
Ted
This:
SELECT * FROM machines INNER JOIN people ON
machines.machinesID=people.peopleID;
Is not producing the same results as this:
SELECT lastname, model FROM people, machines WHERE
Hi,
I am created a user by using:
GRANT ALL ON *.* TO username@% IDENTIFIED BY
password
I did this from the mysql command line tool, logged in
as root. The command succeeds and the new user is
created in the mysql.user table, but the password does
not work. I can only use this new user if I use
Erm, the first sql as i can see doesn't connect on the same field as the
second one that produces the correct result.
George Christoforakis
- Original Message -
From: [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 9:01 AM
Subject: Join vs. Where (help)
2003 6 25 15:[EMAIL PROTECTED] :
This:
SELECT * FROM machines INNER JOIN people ON
machines.machinesID=people.peopleID;
Inludes NULL records
Is not producing the same results as this:
SELECT lastname, model FROM people, machines WHERE machines.peopleID =
people.peopleID;
Dosent
Hi tlr7425,
Besides what I said in my last e-mail I completely overlooked that
SELECT * FROM machines INNER JOIN people ON
machines.machinesID=people.peopleID;
should be
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.peopleID;
Even though my first statement should
Hi All,
Just a quick question: How do I set the auto increment
for a field to start from an integer other than 1.
For example, I would like to be able to have the auto
increment counter start from 1000.
Thanks,
Javan.
When should I use the autoextend option for the InnoDB file...Even after emptying the
tables the files keeps its size and for new insertions it gets even bigger instead of
using the already allocated space(which I suppose should be available after emptyibg
the tables).
thank you friends
aik_b
Hi MySQL Fans ;-),
I have a question regarding the MySQL feaures.
From Version 4.1 Full subselect support was/is announced.
However if I understood correctly then already from Version3.23-41 (or
earlier) there are some subselect functions already included. For xample if I
try this:
CREATE
I don't know if this apply when using GRANT but have you tried afterwards:
flush privileges;
HTH,
Lian
-Original Message-
From: Riaan Oberholzer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 9:19 AM
To: [EMAIL PROTECTED]
Subject: Problem setting/activating password
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 24 Jun 2003, David Griffiths wrote:
I'm surprised there is not more interest in this; is it that not many
work with large-ish (10+ gig) databases that need high-end performance?
Many of our customers do.
A 64-bit CPU won't have the
Hi all,
Is there any way to do a mysql dump in which each table is dumped into a
separate file. I know I can use the --tables option to specify a table,
but this means I have to type out each table name (and there are a lot
of them). Is there any way to get mysql to automatically iterate
I.-A.,
- Original Message -
From: I-A.Kotopoulos [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, June 25, 2003 10:05 AM
Subject: InnoDB file...
--=_NextPart_000_00B5_01C33B01.642AD2C0
Content-Type: text/plain;
charset=Windows-1252
Hi all,
I have a question about MyISAM, during an UPDATE for a row, is it a row
locking or a table locking?
--
Cedric Gavage [EMAIL PROTECTED]
http://unixtech.be - http://gavage.com - OpenPGP: 0xED325C64
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
What do you mean when you say, in this case, "does not return the NULL
(Brecord"?
(B
(BI have no records that are completely "NULL" though some records do
(Bhave a NULL field or two?
(B
(BThanks,
(BTed
(B
(B
(BOn Wednesday, June 25, 2003, at 02:42 AM, Nils Valentin wrote:
(B
(B Hi
Hi to all,
I will have to do with a very big file (approx 600 millions of records).
Which is the best table handler for this king of table : InnoDB or MyISAM
(many INSERT and MANY SELECT, no UPDATE - statistics file).
Best regards.
--
MySQL General Mailing List
For list archives:
On 25-Jun-2003 MaFai wrote:
Hello, mysql,
After create a table,it can use desc tablename to describe the table
scheme.
But it can not demonstrate that the column is unique or not.It just
simplely show the column is MUL type.
How can I get more information from the table by
On 25-Jun-2003 Ralph wrote:
I am getting a list of all countries from database, and then I am
sorting by country name. However since most orders will be from US I
want the US to appear first over the rest of the countries. How can I go
about doing this?
Currently, this is my query:
Installed MySQL v4.0.13 on RH8, with phpMyAdmin-2.5.1 and PHP v4. The phpMyadmin is
installed on another server (gateway) while MySQL and PHP is installed on a separate
server. When the programmer tries to access MySQL he gets the following message:
Error 2003 Cannot connect to MySQL server
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 24 Jun 2003, Dyego Souza do Carmo wrote:
try to bk pull the mysql 4.0 from CVS tree...
after I run:
aclocal; autoheader; autoconf; automake
inside dir...
the error is:
autoconf: Undefined macros:
# [EMAIL PROTECTED] / 2003-06-25 12:05:49 +0800:
//Wrong sql statement
alter table p_asset add mydate datetime default now();
alter table p_asset add mydate datetime default time();
alter table p_asset add mydate datetime default now;
alter table p_asset add mydate
alter table p_asset add mydate datetime default 'now()';
- you need the '' around now(); apparently
http://www.mysql.com/doc/en/DATETIME.html
and scroll down to the comment made by
Lazy Soul on Tuesday May 27 2003, @8:15am
Jan
Janice Wright
Ingenta plc
[EMAIL PROTECTED]
Hi !
Just wanted to know if there is any installation procedure available on =
UnixWare 7.1.x. There is patch available for SCO UnixWare libz.so, which =
I have downloaded but Iam not able to initialize ./Configure script. =
Any help/support will be appreciated.
Thanks In Advance
Regards
Sudhipan
# [EMAIL PROTECTED] / 2003-06-25 15:18:09 +1000:
From: Roman Neuhauser [EMAIL PROTECTED]
please don't piggyback on other people's threads. you can start your
own for free.
Although it was the first time for me to send the post on this list, I was
sure that I did not follow other
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.peopleID;
Inludes NULL records
I meant the first statement returns also empty record fields or should I say
incomplete data records ?
Is not producing the same results as this:
SELECT lastname, model FROM
insert one space before US ;)
in recieving do trim if not HTML output
-Original Message-
From: Ralph [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 7:32 AM
To: mySQL Mailing List
Subject: Sorting Countries
I am getting a list of all countries from database, and then I am
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 24 Jun 2003, Daevid Vincent wrote:
It would be really nice if ANY of these kinds of configuration options
were settable via the /etc/my.cnf file. I use RPM's almost exclusively
for their ease of maintenance, compatibility and
# [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100:
Sometime recently MaFai said:
A table contains a column named mydate.
//Wrong sql statement
alter table p_asset add mydate datetime default now();
alter table p_asset add mydate datetime default time();
alter
You're right, just tested it myself on 3.23.41; and I get exactly
the same result as you. We should post an amendment to the docs
on the website.
However, (still with 3.23.41):
mysql create table autotime2 (foo int, bar timestamp default now());
ERROR 1064: You have an error in your SQL syntax
Nils Valentin [EMAIL PROTECTED] wrote:
I have some questions about temporary tables. I would appreciate any replies:
I created a temporary table f.e. like this:
mysql create temporary table temp SELECT * FROM relations;
Query OK, 4 rows affected (2.35 sec)
Records: 4 Duplicates: 0
Hi
My server www has Suse 8.2, apache-1.3.27, mod_php4-4.3.1,
and my server mysql has Suse 8.2, and mysql.4.0.12-Max-log
Sometimes, not always, it appears an error in www.
Warning: mysql_pconnect() [function.mysql-pconnect]: Link to server lost,
unable to reconnect in db_mysql.inc on line 73
# [EMAIL PROTECTED] / 2003-06-25 07:10:46 +0100:
Sometime recently Roman Neuhauser said:
# [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100:
alter table p_asset add mydate datetime default 'now()';
- you need the '' around now(); apparently
any one can tell me how can i use the MySQL ++ function in CBuilder 6??
i include it in my project but i got linker error
Javan B. [EMAIL PROTECTED] wrote:
Just a quick question: How do I set the auto increment
for a field to start from an integer other than 1.
For example, I would like to be able to have the auto
increment counter start from 1000.
Use AUTO_INCREMENT option of CREATE TABLE statement:
Compiler errormessage ver 1.3
C:\mysql\bincomp-err.exe -I
comp-err.exe (Compile errormessage) Ver 1.3
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Usage: comp-err.exe [-?] [-I] [-V]
# [EMAIL PROTECTED] / 2003-06-25 02:11:05 -0400:
I needed to add a new, autoincrementing, primary key column
to a table and have been struggling to figure out how to
assign an initial, unique value to each row.
I finally accomplished my task, but feel sure there's an
easier way.
Here
Cedric Gavage [EMAIL PROTECTED] wrote:
I have a question about MyISAM, during an UPDATE for a row, is it a row
locking or a table locking?
MySQL locks the whole MyISAM table.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
Morten Gulbrandsen [EMAIL PROTECTED] wrote:
Compiler errormessage ver 1.3
C:\mysql\bincomp-err.exe -I
comp-err.exe (Compile errormessage) Ver 1.3
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the
Nils Valentin [EMAIL PROTECTED] wrote:
I have a question regarding the MySQL feaures.
From Version 4.1 Full subselect support was/is announced.
However if I understood correctly then already from Version3.23-41 (or
earlier) there are some subselect functions already included. For xample
Also doesnt work in 4.1 alpha.
Best regards
Nils Valentin
Tokyo/Japan
(As requested I took Roman of , as he doesnt like direct e-mails ;-)
2003 6 25 19:12Roman Neuhauser :
# [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100:
Sometime recently MaFai said:
A table contains a column named
At 12:54 25/6/2003 +0200, Morten Gulbrandsen wrote:
Hi,
for which purpose is this file included in the file
C:\mysql\bin directory ?
For to build the errmsg.sys files:
Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
c:\mysql\bincomp-err
I use unicode to store farsi data in mysql database but I have problems sorting it
using ORDERBY command...(ORDER BY does'nt work properly)
I don't know what to do .
1---)pleases help me if there is any solution for me to define a charset in the order
that I want .
2---) how can I replace
Yes, I installed by RPM. I have now found the error file as you
mentioned. The output for the last few days is:
030621 06:49:27 mysqld started
030621 6:49:28 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on
Hi Egor,
Thank you for the reply. Do you mind to go abit mor into details ? It seems
that I got domething wrong here.
If nested queries are not only subselects, which other nested queries exist
there ?
Do you mind just writing a few samples, please ?
Sorry if this seems a simple question -
Hi,
Try mysqldump -T:
-T| --tab=...
Creates tab separated textfile for each table to given path.
(creates .sql and .txt files). NOTE: This only works if mysql
dump is run on the same machine as the mysqld daemon.
This was taken from the man page.
On Wed, 2003-06-25 at 08:56, Rob
Todd Burke wrote:
Hello
1/ I have a search engine which crawls auction sites and returns
information which is inserted into a mysql database. This activity
represents on average about 3 inserts per second with a combined payload
of 450 bytes per second added to the database. This updating
This follows on a previous mail from me:
When using
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
password
I could not get the password authentication to kick
in. Only supplying no password (empty string)
succeeded. Even after doing SET PASSWORD
and FLUSH
PRIVILEGES.
Then I tried
WOW Victoria,
thats a good explanation. That makes many things clearer now.
Thank you very much.
However, when not having the set the tmpdir variable were are the temporary
tables stored ? (I searched the whole harddisc) I assume in this case that
they must be stored in the memory, is that
Note: forwarded message attached.
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!---BeginMessage---
I use unicode to store farsi data in mysql database but I have problems sorting it
using ORDERBY command...(ORDER BY does'nt work properly)
I don't know what to do .
1---)pleases
hi!! i wrote a simple function that returns a string in C
the function fetches values from a table and stores all the value in a string variable
and then returns it ...This is small part inside the function i wrote!
while((row = mysql_fetch_row(res)))
{
unsigned long
Hello,
I currently am
struggling to get the permissions and table restrictions to
work.
Description of the
case:
--
For a database
"examp", where table "foobar" which contains colums "A", "B" and C ,only a
restricted access is allowed.
Lets say that user
# [EMAIL PROTECTED] / 2003-06-24 20:32:48 -0700:
insert into table1 select * from table2;
Table2 has some 10,000 records while table1 has around
11,00,000 records. The time reqd. to execute the above
query is round about 80- 90 secs.
The table1 has 7 columns out of which 5 are composite
Prem Soman wrote:
hi!! i wrote a simple function that returns a string in C
the function fetches values from a table and stores all the value in a string variable
and then returns it ...This is small part inside the function i wrote!
while((row = mysql_fetch_row(res)))
{
Alternatively you can create a priority column defaulting to one number (99)
this will allow you to easily change the country sequence as needed.
SELECT countries_id, countries_name FROM TABLE_COUNTRIES ORDER BY
priority,countries_name;
I hope this helps...
Pat...
[EMAIL PROTECTED]
CocoNet
Hi,
I am running two identical systems, the only difference between the two are
the database name and username. The problem I am getting only occurs on one
of the systems. I am running
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi All,
Im altering a number of table from MyISAM to innoDb and adding foreign keys.
The alteration of the table type works.
Adding the row as an index works.
Adding the foreign key fails, generating the error:
alter table project add FOREIGN KEY (company_id) references company (id)
[mySQL]
Nils Valentin wrote:
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.peopleID;
Inludes NULL records
I meant the first statement returns also empty record fields or should I say
incomplete data records ?
Is not producing the same results as
I think we need more info: Table definition, MySQL version etc..
Med venlig hilsen
Lars Geisler
-Original Message-
From: Roman Neuhauser [EMAIL PROTECTED]
To: Amit Lonkar [EMAIL PROTECTED]
CC: [EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: Query Execution Time in mysql
Sent:
# [EMAIL PROTECTED] / 2003-06-25 14:03:17 +0100:
Im altering a number of table from MyISAM to innoDb and adding foreign
keys.
The alteration of the table type works.
Adding the row as an index works.
Adding the foreign key fails, generating the error:
alter table project add FOREIGN KEY
your MUA doesn't properly represent quotation marks, breaking them
in other MUAs.
# [EMAIL PROTECTED] / 2003-06-25 04:51:49 -0700:
This follows on a previous mail from me:
When using
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
?password?
I could not get the password
In the second query, the server may switch the order of the join,
producing the same output in different order.
Try adding an ORDER BY to both and see what happens.
[EMAIL PROTECTED] wrote:
Ok, should be this:
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.peopleID;
Ted
To also add priviliges on the local machine
GRANT ALL ON *.* TO username@localhost IDENTIFIED BY
password
Riaan Oberholzer wrote:
Hi,
I am created a user by using:
GRANT ALL ON *.* TO username@% IDENTIFIED BY
password
I did this from the mysql command line tool, logged in
as root. The
Nils Valentin [EMAIL PROTECTED] wrote:
WOW Victoria,
thats a good explanation. That makes many things clearer now.
Thank you very much.
However, when not having the set the tmpdir variable were are the temporary
tables stored ? (I searched the whole harddisc) I assume in this case
mohammad kh.tajer [EMAIL PROTECTED] wrote:
I use unicode to store farsi data in mysql database but I have problems sorting it
using ORDERBY command...(ORDER BY does'nt work properly)
I don't know what to do .
1---)pleases help me if there is any solution for me to define a charset in
PAUL MENARD [EMAIL PROTECTED] wrote:
I'm having an intermittent problem with a MySQL server that I have running on a
Windows 2000 Advance server systems. This issue occurs every few days depending on
the load of the system.
Here are the details.
MySQL version 3.23.42-nt (I know I
I believe % doesn't include localhost, but I could be wrong.
% Does indeed include localhost. At least it does on 4.0.13.
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Maybe it does, or maybe it doesn't; but if you're connecting to your
server on the localhost, you're probably connecting through a pipe/UNIX
type socket instead of over the network. This might be the distinction
that matters in this case; does @localhost in this context mean through a
non-network
On Wed, 25 Jun 2003, Sudhipan Sharma wrote:
Hi !
Just wanted to know if there is any installation procedure available on =
UnixWare 7.1.x. There is patch available for SCO UnixWare libz.so, which =
I have downloaded but Iam not able to initialize ./Configure script. =
Any help/support will
I simply followed the directions listed here:
http://www.mysql.com/doc/en/SCO_UnixWare.html
And I had no problems.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Sudhipan Sharma [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 3:08 AM
To: [EMAIL PROTECTED]
And what would that be?
Phil Dowson wrote:
Hi,
I am running two identical systems, the only difference between the two are
the database name and username. The problem I am getting only occurs on one
of the systems. I am running
--
MySQL General Mailing List
For list archives:
In a situation with many concurrent reads and writes an InnoDB table
would be preferable.
See http://www.mysql.com/doc/en/Table_types.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: JOUANNET, Rodolphe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 2:30
Riaan Oberholzer [EMAIL PROTECTED] wrote:
This follows on a previous mail from me:
When using
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
?password?
I could not get the password authentication to kick
in. Only supplying no password (empty string)
succeeded. Even after doing
Phil Dowson [EMAIL PROTECTED] wrote:
I am running two identical systems, the only difference between the two are
the database name and username. The problem I am getting only occurs on one
of the systems. I am running
What exactly problem do you have?
--
For technical support contracts,
MyISAM tables do not support row-level locking, only table locking.
See http://www.mysql.com/doc/en/Table_locking.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Cedric Gavage [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 2:14 AM
To: [EMAIL
I am attempting to modify the GRANT table using the syntax specified in the
MySQL 4.0.13 documentation, and am getting error messages claiming the
syntax is incorrect. (I'm running MySQL on Windows 98, by the way.) I used
mysqlc with root access.
mysql USE mysql;
Database changed
mysql GRANT
yesterday i had same problem on 4.0.13 for win
added [EMAIL PROTECTED] - and was rejected
added [EMAIL PROTECTED] - then accepted
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 4:54 PM
To: Roman Neuhauser; Riaan Oberholzer
Cc: [EMAIL
I think you need the -T option, which will break out table data to
separate files. Here's a description from the manual:
QUOTE
-T, --tab=path-to-some-directory
Creates a table_name.sql file, that contains the SQL CREATE commands,
and a table_name.txt file, that contains the data, for each give
I am not sure that could be viewed as a subselect, as it in not a SELECT
within an SELECT, but is instead a SELECT within a CREATE. I would
imagine that the SELECT within the CREATE is easier to implement that
the actual SELECT within a SELECT.
Regards,
Mike Hillyer
www.vbmysql.com
Thanks you Nils .
(B
(B I truly appreciate how helpful you have been !! I have now got the
(Berror sorted out now.
(B
(BI re-installed MySQL on my Mac OS Jaguar 3 times. Finally the third
(Btime I got it to run. Somehow I had corrupted my User.MYI file
(BI did have to delete the
You need simply add the column predefined as AUTO_INCREMENT and PRIMARY
KEY:
CREATE TABLE incrtest (
name varchar(100) NOT NULL
) TYPE=MyISAM;
INSERT INTO incrtest VALUES(ben);
INSERT INTO incrtest VALUES(bob);
INSERT INTO incrtest VALUES(bom);
INSERT INTO incrtest VALUES(gddo);
INSERT INTO
What about using the username only instead of username@% ?
According to manual (section 7.34) it should be identic in behaviour:
[...]
The simple form user is a synonym for user@%.
[...]
Does it do the same?
Lian
P.S. Andy, sorry for posting by mistake to you. ;-|
-Original Message-
The TIMESTAMP column type does this for you:
See: http://www.mysql.com/doc/en/DATETIME.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: MaFai [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 11:01 AM
To: [EMAIL PROTECTED]
Subject: datetime column dummy
You can change your charset by adding a line in your mysql configuration
file like this.
default-character-set = cp1256
Here cp1256 means that mysql will use Windows Arabic character set. I
don't know the difference between farsi and arabic charsets. And also I
don't know if mysql has a
You may want to try disabling the index during the insert:
ALTER TABLE table1 DISABLE KEYS;
insert into table1 select * from table2;
ALTER TABLE table1 ENABLE KEYS;
And see what that does.
See: http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original
-Original Message-
From: Lenz Grimmer [mailto:[EMAIL PROTECTED]
Actually, you can create larger files on 32bit Linux systems
as well. It's
just that the file system and the C library must have support for LFS
(Large File Support):
http://www.suse.de/~aj/linux_lfs.html
I can
The problem is that when I only define the % host,
then no password is required to log in... (not a
wanted feature!). I CAN log in, i just have to specify
no password.
The password checking is only done for localhost
--- [EMAIL PROTECTED] wrote:
What about using the username only instead
On Wed, Jun 25, 2003 at 10:09:58AM -0400, Adam Lawrence wrote:
I am attempting to modify the GRANT table using the syntax specified in the
MySQL 4.0.13 documentation, and am getting error messages claiming the
syntax is incorrect. (I'm running MySQL on Windows 98, by the way.) I used
mysqlc
Does enclosing the username and host in single quotes help?
I.E. GRANT SELECT ON *.* TO 'update'@'localhost' IDENTIFIED BY 'update';
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Adam Lawrence [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 8:10 AM
To:
Sorry the problem fixed itself, and I mistakenly sent this email
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Phil Dowson [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 9:01 am
Subject: Re: CREATE TEMPORARY TABLE
And what would that be?
Phil
I'm not sure what errors are being reported to the server. I'm not sure how
to get those. I am not local to the box.
Is there a way to look at the log files without being at the box?
Karl
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
To: 'Karl J. Stubsjoen' [EMAIL
I installed the RPM version of MySQL 3.23.56 on Red Hat 9.0
When it installed, it started up mysql, no problems, I could do all mysql functions
I recently rebooted the box, and mysql did not start automatically. I can start it if
I run /etc/rc.d/init.d/mysql start
Is there any know problems why
update is a reserved word in MySQL. Choose another username.
Lian Sebe
Freelance Analyst-Programmer
www.programEz.net
-Original Message-
From: Adam Lawrence [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 5:10 PM
To: [EMAIL PROTECTED]
Subject: MySQL 4.0.13 GRANT syntax
I
Something interesting that may be my problem
This is a known working install
# mysql --version
mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686)
# find /etc/rc.d -name *mysql
/etc/rc.d/init.d/mysql
/etc/rc.d/rc0.d/K90mysql
/etc/rc.d/rc1.d/K90mysql
/etc/rc.d/rc2.d/S90mysql
Hi All,
Im a member of a similar PHP email list and posed the question to community about
issues anyone has experienced with being able to connect to MySQL 4.1. Below are my
email and a response. Is this reply statement correct? Why would MySQL break an
interface to clients? Read his
At 10:55 -0400 6/25/03, Luc Foisy wrote:
I installed the RPM version of MySQL 3.23.56 on Red Hat 9.0
When it installed, it started up mysql, no problems, I could do all
mysql functions
I recently rebooted the box, and mysql did not start automatically.
I can start it if I run
Hello,
I have a MySQL server running with some users besides root, that I want to grant all
privileges for their own databases, but no rights for anything else.
So to say, I have a user web01 that shall be able to do whatever he wants with the
database db01. There are more databases, like db02
On 25-Jun-2003 Rob wrote:
Hi all,
Is there any way to do a mysql dump in which each table is dumped into a
separate file. I know I can use the --tables option to specify a table,
but this means I have to type out each table name (and there are a lot
of them). Is there any way to get
Do you have any sort of `shell` access to the box? SSH? Telnet?
-Original Message-
From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 9:51 AM
To: [EMAIL PROTECTED]
Subject: Re: Strange Mull in show fields and table keeps crashing
I'm not sure what errors
Yes, I turned those runlevels on already and now it works.
The problem is that it was a practically default install, that is the way the
runlevels were set out of the box
3.23.56 was this way after install
mysql 0:off 1:off 2:on3:off4:on5:off6:off
3.23.52 was this
1 - 100 of 154 matches
Mail list logo