At 21:39 -0800 12/7/02, Ryan McDougall wrote:
Hey everyone,
Ok if I issue this command:
mysql> grant select,insert,update,delete,create,drop
-> on *.* to someusr@"%" identified by 'passwrd';
I already know that this statement creates the user someusr w/
password=passwrd
and it can connect from
Hey everyone,
Ok if I issue this command:
mysql> grant select,insert,update,delete,create,drop
-> on *.* to someusr@"%" identified by 'passwrd';
I already know that this statement creates the user someusr w/ password=passwrd
and it can connect from anywhere. What I don't know: Can this user no
On Sat, 2002-12-07 at 21:50, Deepak Suthar wrote:
> I'm using Phpadmin to add these fields with these values, and it keeps
> crashing...what am I missing?
>
> -Deepak
>
> Error
>
> SQL-query :
>
> CREATE TABLE `db` (`host` VARCHAR(localhost) NOT NULL, `db` VARCHAR(dsuthar)
> NOT NULL, `user` VA
I'm using Phpadmin to add these fields with these values, and it keeps
crashing...what am I missing?
-Deepak
Error
SQL-query :
CREATE TABLE `db` (`host` VARCHAR(localhost) NOT NULL, `db` VARCHAR(dsuthar)
NOT NULL, `user` VARCHAR(dsuthar) NOT NULL, `select_priv` VARCHAR(Y) NOT
NULL, `insert_priv
Hi,
I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2
there was no problem with the configure, but for the make I got this :
[...]
gmake[3]: Entering directory `/tmp/mysql-3.23.53/sql'
g++ -s -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME="\"/usr/local\""
-DDATADIR="\"/usr/local/v
I finally found the solution :
I had bad old include files in
/usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/
that come from a old gcc installation.
I removed them and now it's ok.
Pierre.
On 2002.11.13 06:50 Pierre wrote:
Hi,
I try to compile mysql-3.23.53 on my GNU/Linux system with gc
Hello.
On Sat 2002-12-07 at 18:20:07 -0600, [EMAIL PROTECTED] wrote:
> Hello:
>
> We are running a large e-commerce site currently with ASP/MSSQL. The ever
> increasing number of hits, complexity of the site and request for reporting
> is slowly but surely bringing us to the point were the curren
Hello.
On Sat 2002-12-07 at 14:15:59 -0800, [EMAIL PROTECTED] wrote:
> I would like to lock a specific record in a MySQL table so that no other
> user can update it while another user is is update the record via the
> user interface. Can someone please tell me the easiest way to do this?
Depen
Thank you all for your input.
I've gathered the information I need to start with.
thank you again
--- Benjamin Pflugmann <[EMAIL PROTECTED]>
wrote:
> Hello.
>
> On Fri 2002-12-06 at 14:57:00 -0500,
> [EMAIL PROTECTED] wrote:
> > Helmut,
> >
> > I suppose that depends really upon the
> compos
Hello:
We are running a large e-commerce site currently with ASP/MSSQL. The ever
increasing number of hits, complexity of the site and request for reporting
is slowly but surely bringing us to the point were the current database
application is getting tired.
Now we're thinking Linux, MySQL and cl
At 18:50 -0500 12/7/02, Will Standley wrote:
I'm just getting into MySQL and have discovered two tools so far...
- DBTools Freeware
www.dbtools.com.br/EN/ Manage MySQL & Convert Access
& more
- Intelligent Converters Shareware www.convert-in.com
Converts from Access,
Excel & more
Please
At 14:37 -0800 12/7/02, Admin-Stress wrote:
Hi,
I wrote an application using mysql C API.
If I exit my application without closing database, will it be closed
You don't "close" a database. What do you mean? Do you mean close
the connection to the server? If so, exiting without closing is th
I'm just getting into MySQL and have discovered two tools so far...
- DBToolsFreeware www.dbtools.com.br/EN/ Manage
MySQL & Convert Access
& more
- Intelligent Converters Shareware www.convert-in.com Converts from
Access,
Excel & more
Ple
I have used a database creation script for months under 3.23.53a.
Now, I want to upgrade to version 4.0.5 and the script doesn't work. The
first table is created but mysql complains with:
Error 1005 at line 10 Can't create table ./dbdir/tblbasestados.frm
(errno:150)
= = = SCRIPT TO TRY = = =
CRE
Hi,
I wrote an application using mysql C API.
If I exit my application without closing database, will it be closed automatically?
void error(int code) {
printf("error: %d\n", code);
exit(0);
}
int main() {
...
error(-255);
...
}
How to pass the mysql database connector to a function? is
Dear Benjamin, dear Michael,
> > > 1. I need to know if these features are supported or not by MySql ver
> > 4.05a.
> > > - Referencial integrity constraint
This is supported with InnoDB tables. If you _always_ need referential
integrity, simply set InnoDB tables as the default table type in my.c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 6 Dec 2002, Mariella Di Giacomo wrote:
> I have been running MySQL 4.0.5 64 bits on a Sun sun4u sparc
> SUNW,Sun-Fire-880, Solaris 2.8.
> I have been using the binary version that MySQL provides.
>
> Yesterday I have downloaded the Solari
Greetings...
Are you using Windows to connect to the MySQL. Then you can try SQLyog at
http://www.webyog.com/sqyog/download.html It will help you a lot in these
works and you dont have to write queries also.
Rgds
Insane
- Original Message -
From: "Padma kuruganti" <[EMAIL PROTECTED]>
To:
I would like to lock a specific record in a MySQL table so that no other
user can update it while another user is is update the record via the
user interface. Can someone please tell me the easiest way to do this?
Thank you,
Richard Reina
-
Hi,
I used it for a while, it's quite good for free software, but it is rough
around the edges. Some of the menus are a bit hard to navigate and it
crashes once in a while too.
I'm currently using EMS Hitech's MySQL Manager. It's one of the best GUI's
I've come across. There are a couple of
At 04:22 PM 12/7/2002 +0100, Benjamin Pflugmann wrote:
Hello.
On Sat 2002-12-07 at 07:47:18 +0700, [EMAIL PROTECTED] wrote:
> Hello friends, newbie here.
> 1. I need to know if these features are supported or not by MySql ver
4.05a.
> - Referencial integrity constraint
> - Stored Procedure
> - V
On Sat, Dec 07, 2002 at 02:08:28PM -0500, Amittai Aviram wrote:
> I have been learning a bit about the Perl DBI MySQL API. This API offers
> several ways of fetching the results of a query. Among these,
> fetchrow_array returns a numbered array, while fetchrow_arrayref returns a
> reference to an
I have been learning a bit about the Perl DBI MySQL API. This API offers
several ways of fetching the results of a query. Among these,
fetchrow_array returns a numbered array, while fetchrow_arrayref returns a
reference to an array. When would you want to use a reference to an array
rather than
Thanks Benjamin,
I found that kill -9 seems to be the only way to kill the hung process.
I'll see if I can find another way.
Here is the output of mysqlbug:
>Submitter-Id: Paul Borghese
>Originator:-
>Organization:-
>MySQL support: [none]
>Synopsis: MySQL process hanging
>Severity:
Hello.
On Sat 2002-12-07 at 12:09:44 -0500, [EMAIL PROTECTED] wrote:
> I am running MySQL 3.23.46 under Linux kernel 2.2.20 as the back-end of
> an active website. On occasion mysql seems to stop responding. When I
> log into the server one of the MySQL processes is consuming a
> substantial amo
I have the binlog files stored to a separate drive (actually a partition on
a drive other than the raid array for the tables). When this partition
becomes full, mysql's load average goes from 1.5 to 25 and stays there until
more space is available on the partition that holds the binlog.
This isn't
Hello.
On Sat 2002-12-07 at 11:40:28 -0600, [EMAIL PROTECTED] wrote:
> I have read 4.10.7 and the only caveat stated is that updates can occur
> in different orders on the different servers.
I did not mean to discourage you from using two-way replication. I
just tried to explain (what I believe)
I have read 4.10.7 and the only caveat stated is that updates can occur
in different orders on the different servers. Each of my updates are
autonomous and that should not be a problem. Are there any other
gotchas I should be concerned about. I saw a posting the stated not to
turn on log-slave-u
Hello.
On Sat 2002-12-07 at 10:36:00 -0600, [EMAIL PROTECTED] wrote:
[...]
> >Why do you repeat "job_id = 111 and thread_id = 0"? If you are using a
> >transaction seperation level of at least REPEATABLE READ (which is the
> >default), InnoDb assures that you always see the same rows within one
>
I have successfully configured two mysql instances to replicate to each
other (According to /doc/en/Replication_Features.html, it is possible to
do it in a A->B->C->A relationship, but I only did it with two servers
and I don't have log-slave-updates on (I think if I did, it would
immediately stop
I am running MySQL 3.23.46 under Linux kernel 2.2.20 as the back-end of
an active website. On occasion mysql seems to stop responding. When I
log into the server one of the MySQL processes is consuming a
substantial amount of CPU resources (i.e. it is on the top of the list
when viewing the top
Benjamin Pflugmann wrote:
Hello.
On Fri 2002-12-06 at 10:28:23 -0600, [EMAIL PROTECTED] wrote:
Heikki and all,
I've got a quick question which may be more general sql related but
since I'm using innodb tables specifically for the row locking.
The following process description is specifical
drop table if exists your_table;
create your_table (...);
> -Original Message-
> From: Peter Abilla [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 04, 2002 1:12 PM
> To: [EMAIL PROTECTED]
> Subject: Drop, Create. . .help
>
>
> I want to do the following:
>
> 1-If table x exists
Hello.
On Sat 2002-12-07 at 03:36:56 -0500, [EMAIL PROTECTED] wrote:
> Hi all,
>
> I'm going to run MySQL off a shared Unix server so I'm wondering what the
> memory requirements are. I have about 15 tables are simple text columns
> (~10 - 20 columns). The largest tables will be ~25MB.
You c
Hello.
On Sat 2002-12-07 at 04:04:04 +, [EMAIL PROTECTED] wrote:
> Hi folks.
>
> I have an application in which I require the only case equivalencies
> to be a-z A-Z. What I mean is, e/E should be regarded as identical
> in strings, but neither e/É (E-acute) nor é (e-acute)/É (E-acute)
> sho
Hello.
On Sat 2002-12-07 at 07:47:18 +0700, [EMAIL PROTECTED] wrote:
> Hello friends, newbie here.
> 1. I need to know if these features are supported or not by MySql ver 4.05a.
> - Referencial integrity constraint
> - Stored Procedure
> - View
> - Trigger
Please see
http://www.mysql.com/doc/e
Ç×°®µÄÅóÓÑ£º
ÄúºÃ£¡
ÕâÊÇÀ´×ÔÏÃÃÅÊÐӯͨԶº½µç×ӿƼ¼ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£
ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ
ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾Ñé,ÕâΪÎÒÃǵĿռä
Îȶ¨ÌṩÁ˱£Ö¤.ÎÒÃǵķþÎñ×ÚÖ¼ÊÇ:Îȶ¨
Hello.
On Sat 2002-12-07 at 14:26:00 +0100, [EMAIL PROTECTED] wrote:
> Hello.
>
> On Fri 2002-12-06 at 16:13:54 -0600, [EMAIL PROTECTED] wrote:
> >
> > First off, we are using Innodb tables on version 3.23.53a-max.
> >
> > If the command STOP SLAVE is issued in the middle of the following type
Hello.
On Fri 2002-12-06 at 10:28:23 -0600, [EMAIL PROTECTED] wrote:
> Heikki and all,
> I've got a quick question which may be more general sql related but
> since I'm using innodb tables specifically for the row locking.
>
> The following process description is specifically designed to prevent
Hello.
On Fri 2002-12-06 at 17:04:27 -0500, [EMAIL PROTECTED] wrote:
> I have a large blob column with encrypted data and also i have other
> non-blob columns. I get results when i do the following
>
> Note: ID = non blob column
>
> Select ID from table
> > i get records returned
>
> when i se
Hello.
On Fri 2002-12-06 at 14:32:13 -0600, [EMAIL PROTECTED] wrote:
> after trying this it shows mysql as running, but /tmp/mysql.sock as
> not being created. i stopped mysql and then started it again, and
> the same thing happened...still no mysql.sock? should i just
> reinstall? what is the b
Dear Andy,
> There is no way I can make my client app regard é and É to be
> identical, even if I want it to, even if it would seem logical to
> you that it should be so. This cannot be changed. So, I'm now at a
> loss as how to store and work with this in MySQL. I need to use
> some of those c
Hello.
On Fri 2002-12-06 at 15:35:53 -0600, [EMAIL PROTECTED] wrote:
>
> I am new to this list and have not been able to find an answer in the
> searchable archive, So I am sorry if this question has been asked
> before.
>
> The documentation (section 4.10.7) mentions 2 way replication but does
Hello.
On Fri 2002-12-06 at 21:53:40 +0200, [EMAIL PROTECTED] wrote:
> Lo all,
>
> If I have a database with various tables, and I want to upgrade the tables
> and the data in the tables, will it screw up the permissions assigned to
> users if I use DROP TABLE / CREATE TABLE (to recreate the chan
Hello.
On Fri 2002-12-06 at 09:59:25 -0800, [EMAIL PROTECTED] wrote:
> Hi,
>
> I just send this email again. Does anyone care about
> HPUX build?
You need to be more specific in the future. That will enhance the
chance for someone seing the problem.
I have never used HP-UX. That said, some comm
Hello.
On Fri 2002-12-06 at 17:54:53 +0100, [EMAIL PROTECTED] wrote:
[...]
> I have one question : if I go the RestTimes route, that is having a row per
> day and so 7 row per restaurants : can I, in one SQL request, know if THAT
> restaurant is open or close now ? I now there are NOW() function i
Hello.
On Fri 2002-12-06 at 11:46:16 -0500, [EMAIL PROTECTED] wrote:
> >From what I've been reading in the MySQL documentation, 3.23.43b
> InnoDB features foreign key constraints, which is great! But from
> the MySQL 4.1 "wishlist" items found here (scroll to the bottom):
> http://www.mysql.com/
Hello.
On Fri 2002-12-06 at 16:13:54 -0600, [EMAIL PROTECTED] wrote:
>
> First off, we are using Innodb tables on version 3.23.53a-max.
>
> If the command STOP SLAVE is issued in the middle of the following type of
> transaction:
>
> set autocommit = 0;
> update...;
> update...;
> update...;
>
Has anyone used DBTools Software? (http://www.dbtools.com.br/EN/)
It is a free utility for managing MySQL & other db's.
I also discovered Intelligent Converters at www.convert-in.com
Both look good.
The first is free and does more than convert Access to MySQL.
The second converts more stuff...
Use the CONCAT function
Adolfo
> -Original Message-
> From: tag [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 06, 2002 3:57 AM
> To: [EMAIL PROTECTED]
> Subject: select question
>
>
> HI,
> I need to do a select query that can do the following:
> select * from table where col1 li
Hello.
On Fri 2002-12-06 at 14:57:00 -0500, [EMAIL PROTECTED] wrote:
> Helmut,
>
> I suppose that depends really upon the composition of your database.
That's completely true. On the data stored and how it is used,
i.e. what are common queries.
[...]
> The only other thing that I
Hello.
On Fri 2002-12-06 at 09:59:32 -0500, [EMAIL PROTECTED] wrote:
> MySQL folks,
>
> I have a server which handles hundreds of connections at a time typically.
> Many of these are actually inserting data. It is currently configured as a
> replication master. Let's call it A. The slave is curre
Hi all,
I'm going to run MySQL off a shared Unix server so I'm wondering what the
memory requirements are. I have about 15 tables are simple text columns
(~10 - 20 columns). The largest tables will be ~25MB.
I did a quick test on my Win32 Machine and the largest query only takes up
18MB of R
53 matches
Mail list logo
