U can also use MySQL FRONT
R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)
-Original Message-
From: Thomas Edison Jr. [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 2:21 PM
To: [EMAIL PROTECTED]
Hi,
I have a .dat file.. with some data like this :
02001IN00100213200207120020412200204122002041710002002041720020417
02002IN00100213200207220020415200204152002041810002002041820020418
02003IN00100213200207320020416200204162002041910002002041920020419
Boris,
You left off the host name when you issued your grant statement. It should
have been like this:
mysql> grant all privileges on ps_db.* to ps_user@localhost;
ormysql> grant all privileges on ps_db.* to [EMAIL PROTECTED];
ormysql> grant all privileges on ps_db.* t
Sorry, there was a typing mistake in the previous mail.
After I installed MySQL in linux on a PC, version mysql-3.23.49a-pc-linux-
gnu-i686
I created a database named 'ps_db', as followed:
mysql> create database ps_db;
Query OK, 1 row affected (0.00 sec)
mysql> grant all privileges on ps_db.* t
After I installed MySQL in linux on a PC, version mysql-3.23.49a-pc-linux-
gnu-i686
I created a database named 'ps_db', as followed:
mysql> create database ps_db;
Query OK, 1 row affected (0.00 sec)
mysql> grant all privileges on ps_db.* to ps_user;
Query OK, 0 rows affected (0.00 sec)
mysql>
>Description:
I just now installed MySQL latest version and I cannot acced the database, even though
the MySQLd daemon is running.
>How-To-Repeat:
>Fix:
>Submitter-Id: [EMAIL PROTECTED]
>Originator:root
>Organization:
>MySQL support: [none | licence | email supp
I just now installed the latest version of MySQL and cannot access my database even
though I'm logged in as root and mysqld daemon is running.
Kindly help.
Regards,
Paras.
-
Before posting, please check:
http://www.mysql.com/
At 10:55 +1000 4/17/02, Daniel Kasak wrote:
>Hi all.
>Can I alter a MySQL table (specifically a MyISAM) table while (MS
>Access) clients are connected?
>I want to add fields, not alter existing ones.
>Is this likely to cause corruption?
>Thanks!
MySQL won't alter the table until it can get a wri
Hi all.
Can I alter a MySQL table (specifically a MyISAM) table while (MS
Access) clients are connected?
I want to add fields, not alter existing ones.
Is this likely to cause corruption?
Thanks!
Dan
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney,
Hi!
Anybody knows how can mysql ORDER BY international strings?
I would need to do sortings for different languages.
So locale definition should be changed within MySQL.
(changing locale for the system is not solution, because I need
to change more times for different languages)
How it is possibl
Mysql version: 3.23.41 and 4.01
OS: NT4SP6a, W2KSP2
There is some inconsistency in how many significant digits mysql
displays/returns for double values. For example, a value of
1.1790123350679011E22 is returned as 1.1790123350679e+022 (last 3 digits
rounded, only 14 significant digits). However
At 10:20 AM 4/16/2002, you wrote:
>Hi all,
>
>I'm looking for a tool like Enterprise Manager (I am talking about a
>Windows client)
>I downloaded MyCC and it looked a lot like it and hoped that it would work.
>
>Don't get me wrong it does work but with a couple of glitches.
>I don't know If those
Hi
That using mysql_read_default_group can produce segfaults is known since
at least a month and there were two independend bug reports, one from me:
http://listarchive.nextrieve.com/mysql//200203/msg01938.html
Are there any patches available? Monty said something about 3.23.50 but
although the
Hi !
> -Original Message-
> From: Richard Bolen [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 16, 2002 2:25 PM
> To: MySQL Mailing List (E-mail)
> Subject: MySQL subtracting an hour from DATETIME types I insert?
>
>
> I have a java application accessing MySQL via the mm.mysql
> ty
I have a java application accessing MySQL via the mm.mysql type 4 jdbc driver. It
appears that when I insert a record with a DATETIME type in it, it's subtracting an
hour from the time.
Does anyone know why this might be happening? Is it a timezone or daylight savings
time issue? My server
Hi all,
I tried to install mysql version 3.23.46
but when I do the make part I get an error message.
On this server I have another mysql installed (version
3.23.46) and I thought that I will install one more because
this worked fine before.
The same error popped out:(
Step one:
CFLAGS="-O3 -
Sometimes, simpler is better.
on 4/16/02 4:16 PM, Gurhan Ozen at [EMAIL PROTECTED] wrote:
select
ad_pubid, client_region,
count(distinct ad_clientid) as Advertisers
from
ads, clients
where
ads.ad_clientid = clients.client_id
group by
ad_pubid, client_region;
I think I was too busy tr
On 16 Apr 2002, at 13:25, Chris Stark wrote:
> SELECT * FROM results WHERE result_value < 2.8E-50
>
> Anyway, I cannot seem to find a column type that is large enough to store
> this kind of number.
Have you tried DOUBLE PRECISION? It doesn't seem to be specified
on the MySQL site, but Paul Du
is the load data invalid only in the windows version of mySQL?
Keith Kiedrowski
Systems Administrator - The DiMarco Group
Voice: 585.214.4787
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Monday 15 April 2002 02:39 pm, Leonardo Dias wrote:
> I received the message that made our MySQL die sometimes now. Our mysqld
> is the binary package available @ www.mysql.com. Version is 3.23.49a
>
>
> The error message is below.
>
> key_buffer_size=16773120
> record_buffer=1019904
> sort_
My problem is fixed.
I only grant'ed user@localhost. What I needed, and have done, is grant'ed
[EMAIL PROTECTED] Once I did that everything worked.
Zyxian
On Tue, 16 Apr 2002 09:38:19 -0700, Zyxian wrote:
Hello.
When trying to connect to a database through php using a user that has been
gran
Hi Gurhan,
Actually, the "source" command is what I was looking for. Thanks. I looked
through the documentation but for some reason could not find it.
- Neal
Gurhan Ozen <[EMAIL PROTECTED]> on 04/16/2002 03:43:42 PM
To: Neal Caidin <[EMAIL PROTECTED]>,
[EMAIL PROTECTED]
cc:
Subj
Hello.
I have just spent the afternoon pouring over the mailing list archives and
the manual trying to find a way to do this, but have come up pretty empty,
so I decided it was time to ask the list.
I have a database that our sales team uses to track their sales efforts.
For the sake of simplici
Hi Neal,
I am not clearly understanding your question , do you mean that you have
some variables in your queries??
Normally you would just save your query in a file and either run it in
the shell command line in batch mode with '<' operator or would just call it
in mysql shell with 'source' syn
> Don't you think you should use
>
> select * from test WHERE a=0 ;
>
> not
>
> select * from test where 0;
>
> Isn't the correct usage of WHERE
Well, usually my queries could look like this:
insert into #report (Line)
select isnull(a.Object, '') + char(9)
+ isnull(c.ClusterId, '
Hi All,
I am a little more familiar with Oracle environments where I can "save" and
"get" SQL statements that I formulate. How do I do this from within MySQL?
I've tried editing my query, with vi, and then saving it using vi's w
filename command, but I can't figure out how to restore the query.
Hi,
currently i got one problem really need your help.
I removed mysql3.23.41 version and install mysql
3.23.49. and it works fine with myisam table.
Now i am trying to create innobd tables.
so i edit my.cnf file like that( window 2000):
[mysqld]
basedir=F:/mysql
#bind-address=129.128.207.59
data
thanks all!!
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 11:27 AM
To: BJ Phillips; Mysql Help
Subject: RE: Password handoff
mysql -u user -pPASSWORD ...
See: http://www.mysql.com/doc/m/y/mysql.html
Notice that there is no space between
mysql -u user -pPASSWORD ...
See: http://www.mysql.com/doc/m/y/mysql.html
Notice that there is no space between -p and the password..
Gurhan
-Original Message-
From: BJ Phillips [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 2:05 PM
To: Mysql Help
Subject: Password handoff
From: bruce
To: [EMAIL PROTECTED]
Subject: "mysql start" produces "can't connect thru
/var/lib/mysql/mysql.sock"
>Description:Trying to run mysql-3.23.41 that came with RH7.2 following
mysql.org documentation. files are not located as documented either for rpm
or source install. 'mysql s
Doh. My bad. I was indeed thinking of integer context rather than boolean
context.
I was thinking of a Perl construct of the form:
if("a" + 0) { ... }
I.E. forcing it to an integer context...
-JF
> -Original Message-
> From: Keith C. Ivey [mailto:[EMAIL PROTECTED]]
> Sent:
> Neither I, it seams strange. This value has to be stored in some kind
> of pointer to an object or char * in the program it self. I would first
> assume that the content of the pointer is tested, but that cant be true
> since the content in this case is the number 65.
You're assuming a very low
Hi,
Don't you think you should use
select * from test WHERE a=0 ;
not
select * from test where 0;
Isn't the correct usage of WHERE
>-Original Message-
>From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, April 16, 2002 2:00 PM
>To: Mysql List; Christopher Th
On 16 Apr 2002, at 10:58, Jon Frisby wrote:
> String literals in a truth test such as you set up are coerced to integers.
> (A la C's 'atoi()' function.)
[snip]
> If you're used to weakly-typed languages, such as Perl this is fairly
> typical behavior although it does seem counterintuitive in the
Does anybody know how I would hand the password to this command line
automatically?
mysql -u root fastlane < /home/fastlane/queries/daily_netcfr_query
-=BJ=-
-
Before posting, please check:
http://www.mysql.com/manual.php
Hy Johnny,
I try to install MySQL front on Window 2000. When I run it to connect to
mysql server on Linux, I got an error saying this host (my client) cannot
connect to the mysql server.
It seems to be a configuration on the mysql server, any idea.
Thanks,
Hisseine
- Original Message
> mysql> select x.a from test x where 1;
>
> 1 evaluates to be true, so this should select all rows. And it does.
>
> 5 rows in set (0.00 sec)
>
> mysql> select * from test where 0;
>
> This evaluates to false, so this should not select any rows. And it does.
>
> Empty set (0.00 sec)
>
> m
String literals in a truth test such as you set up are coerced to integers.
(A la C's 'atoi()' function.)
The following returns all rows from a table:
SELECT * FROM test WHERE '1'; // String becomes 1
SELECT * FROM test WHERE '1a'; // String becomes 1
SELECT * FROM tes
Hello,
I have a question, and hopefully someone out there can help me out. I have
a lot of really large numbers (or should I say small, large in size ) that I
need to store in my MySQL database. Numbers like:
2.8E-50 or 0.049zeros028
Anyway, I need to store these numbe
mysql> select x.a from test x where 1;
1 evaluates to be true, so this should select all rows. And it does.
5 rows in set (0.00 sec)
mysql> select * from test where 0;
This evaluates to false, so this should not select any rows. And it does.
Empty set (0.00 sec)
mysql> select x.a from test
Basically I am just curious, and I did perform some few small test.
But, I was suspecting to get all rows when I did something like
"WHERE ", but had to write something like "WHERE NOT
" which feels a little bit upside down for me considering
that integers apart from zero evaluates to true.
Also
Ya I am running it on my local machine and I'm doing some development, I
have some people here excited about mysql and they want to play with it so I
granted them access through apache via ip address and created databases for
them, however I really don't wan't them to be able to access my database
Barry Blatz <[EMAIL PROTECTED]> writes:
> I have a system here based on Red Hat's 7.2 distribution and I am wanting to
> get MySQL up and running. After browsing your web page it seems that I will
> have go to a different version of gcc.
Not recommended, the most stable gcc-based compiler aro
Hello.
When trying to connect to a database through php using a user that has been
granted all rights to the database I get the "Can't connect to database"
error. If I use the Admin's name and password I have no trouble connecting
through the php page. From a shell prompt I can connect to mysql
Hi Steve:
That depends. Are you running the db server on your local machine? Or are
you having it hosted somewhere and using PHPMyAdmin? In the second case,
you will have to contact your hosting company to find out how they handle
it. Some hosting companies severely restrict your access to
I don't have --no-disable-keys in my version of myqldump (Ver 8.21 Distrib
3.23.48). (-K doesn't seem to do anything, I assume it's the default).
I actually wouldn't mind disabling keys for the load, but I don't
understand how the "/*!4 ..." stuff is suppose to get used.
Is this a half-im
I'm not sure what you are asking. Everything is working correctly as far as
I can see.
On Tuesday 16 April 2002 10:19 am, Svensson, B.A.T. (HKG) wrote:
> Is this a documented behavior of MySQL(?):
>
> mysql> create table test (a int);
> Query OK, 0 rows affected (0.03 sec)
>
> mysql> insert int
On Tue, 16 Apr 2002, David Ayliffe wrote:
> Are MySQL really going to give you details of their past security
> 'issues'?
>
> Think about it. Try going underground and looking on some exploit
> sites.
>
> DA
>
>
> >
> Hi,
> I'm working on security breaches in MySQL. Can someone guide me i
Is this a documented behavior of MySQL(?):
mysql> create table test (a int);
Query OK, 0 rows affected (0.03 sec)
mysql> insert into test values(0);
Query OK, 1 row affected (0.00 sec)
mysql> insert into test values(0);
Query OK, 1 row affected (0.00 sec)
mysql> insert into test values(1);
Que
Are MySQL really going to give you details of their past security
'issues'?
Think about it. Try going underground and looking on some exploit
sites.
DA
>
Hi,
I'm working on security breaches in MySQL. Can someone guide me in this.
To be precise can you tell me about some literature, some
> apparently an innocent query followed by an update. The binary package
> is statically linked ad it started happening after we started using
> InnoDB. The version is, actually, 3.23.49a-Max.
>
> Although I can't reproduce a better test case than this, I'm sure that
> you can check the binaries
Hi,
I'm working on security breaches in MySQL. Can someone guide me
in this. To be precise can you tell me about some literature,
some book which is easy to understand and also profound ! If
anyone is working on that, I'll be more than happy to interact.
Thanking you.
Paras.
Hi everbody,
Super newbie question here,
How do I set up password protection on a single database. I am using MySQL
with phpMyAdmin.
Thanks alot,
Steve.
-
Before posting, please check:
http://www.mysql.com/manual.php (th
The only way I can see to get this message is if the
client you are on when running mysql is 192.168.10.2
You should be using the IP address of the server you are connecting to,
not the IP address of the client machine.
George Pitcher wrote:
>Toni,
>
>check your logs to make sure that the clien
You should try MySQL Front
http://anse.de/mysqlfront/
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Ioakim Spyros [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 10:20 AM
To: [EMAIL PROTECTED]
Subject: Enterpri
[EMAIL PROTECTED] writes:
> >Description:
> enable-reads-from-master and repl-parse-query is mixed
> >How-To-Repeat:
> .
> >Fix:
> line 839:
> case 22: /* enable-reads-from-master */
> options->rpl_parse = 1;
> break;
>
Hi all,
I'm looking for a tool like Enterprise Manager (I am talking about a Windows client)
I downloaded MyCC and it looked a lot like it and hoped that it would work.
Don't get me wrong it does work but with a couple of glitches.
I don't know If those can be solved in MyCC or I didn't find t
If you know SQL, you might want to have a look at urSQL
(http://www.urbanresearch.com/ursql). It's not a "management tool" per
se, but more of a query tool...
On Tue, 16 Apr 2002, BD wrote:
> At 01:48 AM 4/16/2002, you wrote:
> >Greetings,
> >
> >I would like to ask you following question:
> >
Hi,
That's not a Mysql error, it's an error from the language you are using
(i suppose it's PHP). You did not define $dbconn.
You're mixing functional programming with object oriented programming (i
think).
Instead of
> $result=$dbconn->Execute("update info set .
Try
$result=mysql_
>Description:
enable-reads-from-master and repl-parse-query is mixed
>How-To-Repeat:
.
>Fix:
line 839:
case 22: /* enable-reads-from-master */
options->rpl_parse = 1;
break;
case 23: /* repl-pa
At 01:48 AM 4/16/2002, you wrote:
>Greetings,
>
>I would like to ask you following question:
>Is there graphical user interface for managering MySQL database? I think
>command line-based interface is quite clumsy...
>
>Regards,
> Vesa Kela, Helsinki Finland
Kela,
Try MySQLFront f
Toni,
check your logs to make sure that the client is
logging in with the ip address rather than a
pseudo-address such as pc10-2.domain.com.
I had this problem when one of my users was logging
in. If that's the case, make sure that the logged-in
name is the one in the MySQL db.
HTH
George
---
-Original Message-
From: Chetan Lavti
Sent: Monday, April 15, 2002 10:01 AM
To: [EMAIL PROTECTED]
Subject: regarding mysql sever startup...
hi,
I am starting my Mysql Serevr like this..
> cd /bin/sbin
> mysqld-max --user=root
Is there any another method which doesn't require startin
Hi Everyone.
Here's a VERY unusualy problem.
We are running a mod_perl application with MySQL. One of the functions
in the program performs a "SHOW TABLE" command. This is performed with
apparently great regularity within the program.
It has begun locking a process up, at 100% CPU (All held by
magnus,
Monday, April 15, 2002, 9:04:10 PM, you wrote:
mll>Description:
mll> I installed the binary distribution (first time I am installing mysql
ever) for Solaris 8 in a non-standard location (/data/mysql/3.23.47/SunOS_5.8) which
is local on the server. I then
mll> moved the data dire
bin,
Tuesday, April 16, 2002, 12:40:56 AM, you wrote:
bc> does mysql latest version support multi tables update?
bc> Thanks a lot
Nope. It will come later ...
Look at:
http://www.mysql.com/doc/T/O/TODO_future.html
--
For technical support contracts, goto https://order.mysql.com/
This
David,
Tuesday, April 16, 2002, 3:01:46 PM, you wrote:
DA> Cards on the table, I have an assignment in soon and part of the
DA> deliverable is to design some relational algebra tree's based on some
DA> queries I have been given.
DA> This is one of the queries:
DA> SELECT id
DA> FROM Table1
DA>
Eqab,
Tuesday, April 16, 2002, 4:24:56 PM, you wrote:
EA> i have error : Too many connections . when i try to backup mydatabase , even
EA> if i want browse board how to fix this and is there limit for mysql
EA> connections?
Yes, there is a limit that is determinated by max_connections variable
Monday, April 15, 2002, 10:40:06 PM, you wrote:
m> I have a table with text data in English in one column, same data in
m> Russian (cp1251) in another, and so on. I'd be happy to retrive that
m> data sorted alphabetically according to the *respected alphabets*. I
m> couldn't figure out how to per
Carl,
Monday, April 15, 2002, 11:34:09 PM, you wrote:
CM> We are attempting to put records into a table using the "load data" or
CM> mysqlimport commands. One quirk is with columns that include a timestamp
CM> type. When we import the records we get zeros in the timestamp column. How
CM> can w
eq99083,
Monday, April 15, 2002, 9:59:39 PM, you wrote:
e> Please,
e> can anyone tell me where is the source code for MySQLAdmin.exe for Win32?
You can download the source distribution of MySQL for Windows and take
a look at folder 'Client' ...
e> Thank you
--
For technical support contrac
Lee,
Monday, April 15, 2002, 8:23:42 PM, you wrote:
Leoen> Attempted to compile this version on a SPARC 20 running Solaris 2.6.
Leoen> Installed GNU gcc 3.0.2 and make 2.76 specifically for this installation.
Leoen> Normally use the make from SUN and the C compiler from Sun SparcWorks.
Try mysqlgui, this is a tool that can give you the ability to do some admin.
Hisseine
- Original Message -
From: "Kela Vesa" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 16, 2002 2:48 AM
Subject: Graphical UI for MySQL
> Greetings,
>
> I would like to ask you follow
Can I slave from two different remote servers on the same slave?
If not, is running two mysql servers (slaves) on the same computer easy to
setup or possible at all?
Luc Foisy
-
Before posting, please check:
http://www
How do I enable the mysql_history functions under a windows environment?
thanks
Peter
This e-mail (and any attachments) is confidential and may contain personal
views which are not the views of the BBC unless specifically stated.
If you have received it in error, please delete it from your syst
On 15 Apr 2002, at 15:34, Carl McNamee wrote:
> We are attempting to put records into a table using the "load data" or
> mysqlimport commands. One quirk is with columns that include a timestamp
> type. When we import the records we get zeros in the timestamp column. How
> can we get the curren
Hello,
i have error : Too many connections . when i try to backup mydatabase , even
if i want browse board how to fix this and is there limit for mysql
connections?
Thanks
_
Join the worlds largest e-mail service with MSN Hot
How you uninstall depends on how you installed. Did you install the binary? an
rpm? or compile the source and then install? If you installed by rpm, then
all you need to do is:
rpm -e mysql
If you used some other method to install, then you can just delete all od the
directories. But you will
Hello all,
Can anyone tell me how to uninstall MySQL from Linux Mandrake 7.2 ?
Regards,
paras
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arch
Hi!
On Apr 16, Erlend Hopso Stromsvik wrote:
> I'm not sure if this has been reported earlier, but my mysql-server goes
> down if I run a query with two 'match against' where one of them
> contains/matches the word 'think'...
Can you create a repeatable test case for this ?
Regards,
Sergei
--
Ok,
Cards on the table, I have an assignment in soon and part of the
deliverable is to design some relational algebra tree's based on some
queries I have been given.
This is one of the queries:
SELECT id
FROM Table1
WHERE id NOT IN
(SELECT id
FROM Table2);
I have an idea that this query
> You've already stated your lack of belief in the reliability of deadlines,
> so what did you expect? If someone had responded with "4.1 will be done on
> 5/1/2002" you'd respond that the only way that would happen would be if it
> were horribly buggy or lacked "critical" features -- if you hold
i've report this bug to php, they said it's not bug of php
but i've found the problem
* ALL is ok for SERVER, problem issue only by CLIENT(libmysql.a)
php-win-binary don't compile libmysql supporting GBK charset!
neight other multibyte charset.
also the one i compiled is linked with lib
Description:
I got a MySQL source distribution of 3.23.49 from www.mysql.com. Then I
installed it in the
following steps:
(1)groupadd mysql
(2)useradd -g mysql mysql
(3)gunzip < mysql-3.23.49.tar.gz | tar -xvf -
(4)cd mysql-3.23.49
(5)./configure --prefix=/usr/local/mysql
here,
I want to know what kind of normalization to use to solve and retrieve data
for this SQL based application:
Following descritpion is the way I can do it.
I want to store data about contacts :
-> table Contacts(ID,Name,EMail)
and data about list of users :
-> table Lists(IDList, L
Hi all,
I need to create 2 user defined functions.
lookup end reverse_lookup
These functiouns are included in the udf_example2.cc source file.
I have gcc version 2.96 2731 (Red Hat Linux 7.0)
and
mysql-3.23.49-pc-linux-gnu-i686 (Binary distribution)
1)step: Compiling the udf_example2.cc
Rafal,
Monday, April 15, 2002, 6:38:55 PM, you wrote:
>> Rafal,
>> Monday, April 15, 2002, 4:54:23 PM, you wrote:
>>
>> RJ> Version Mysql-Max-3.23.49a for Linux, binary distribution from
>> www.mysql.com RJ> After deleting some users from user table and invoking
>> flush privileges, I got RJ> "L
Toni,
Tuesday, April 17, 2001, 12:10:55 PM, you wrote:
T> i have installed mysql on redhat 7.2 and it's work well. then i try to open
T> mysql client through another computer running win98 using this command:
T> mysql -h 192.168.10.2 -u root
T> and i get this as the result :
T> ERROR 1130: Hos
Carl,
Monday, April 15, 2002, 11:29:10 PM, you wrote:
CM> One of our developers pointed out something to me today and I can't explain.
CM> When we created a table with timestamp as one of the column types and "not
CM> null" the "describe table" command shows that nulls are allowed for the
CM> tim
Kela,
Tuesday, April 16, 2002, 9:48:34 AM, you wrote:
KV> I would like to ask you following question:
KV> Is there graphical user interface for managering MySQL database? I think
KV> command line-based interface is quite clumsy...
Take a look at:
http://www.mysql.com/downloads/gui-clients.h
Toni:
The problem is in the grants, not networking:
http://mysql.com/doc/S/H/SHOW_GRANTS.html
Please take a moment to educate yourself on how it works. It's quite
straightforward.
Regards,
Van
--
=
Linux rocks!!! http://www.ded
dear all,
i have installed mysql on redhat 7.2 and it's work well. then i try to open
mysql client through another computer running win98 using this command:
mysql -h 192.168.10.2 -u root
and i get this as the result :
ERROR 1130: Host '192.168.10.2' is not allowed to connect to this MySQL
ser
Hi All!
Have any of you faced a similar problem and if so how did you fix it?
Please, recommend me something.
The code that I have written is :
$sth = $dbh->prepare("SELECT * FROM MY_TABLE");
$sth->execute || die $sth->errst
> Fra: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
> Sendt: 16. april 2002 09:52
> MySQL AB wants to satisfy as many users as possible. That means
> there may be
> more than one language available for writing stored procedures.
>
> For example, many mainstream databases currently support both Java an
Carsten,
MySQL AB wants to satisfy as many users as possible. That means there may be
more than one language available for writing stored procedures.
For example, many mainstream databases currently support both Java and a
proprietary language like PL/SQL or Transact-SQL.
Regards,
Heikki
Innob
> Fra: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
> Sendt: 16. april 2002 02:15
> I can disclose that there is actually some progress being made in stored
> procedures + triggers.
Ahh could you perhaps disclose a little more? :-) There's been a great
discussion on the choice of language, and I'm su
An update to my earlier post: the problem is NOT fixed in v4.0.1. Both in
v3.23 and v4.0.1 it only shows up in specific circumstances. But given the
reactions to my post, nobody seems to care about that anyway ;-)
I've opened a ticket (#734) about this problem with MySQL support.
Best, Paul
At
Hello mysql,
mysql> create temporary table _234 select -20020412051754 as b; select min(b) from
_234;
Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0
+-+
| min(b) |
+-+
| -20020412051744 |
+-
Hi,
I compile mysql-3.23.49. and I would like to run it first together with
the old mysql.
/usr/local/xxxmysqlxxx/bin/safe_mysqld --socket=/tmp/xxxmysqlxxx.sock
--port=330
7 --user=myuser --pid-file=/usr/local/xxxmysqlxxx//var/mysqld.pid
--datadir=/u
sr/local/xxxmysqlxxx/var
So I get the err
99 matches
Mail list logo
