add % line to your grants.
that means this user can connect from everywhere.
read mysql documents Section 6.13 for detail instructions.
shell mysql --user=root mysql
mysql INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'),
Sir,
I have downloaded the binary stable version of
MySQL from the site www.mysql.com.The package I
downloaded is ..
mysql-3.23.37-pc-linux-gnu-i686.tar.gz
After unzipping and untaring,I entered then
directory
mysql-3.23.37-pc-linux-gnu-i686 and then i executed
the
./configure
I know this is a bit StarOffice specific, still, I already know of
a similarity of functionality with M$ Access when talking to MySQL
server. (table is required to have a primary key for inserts to work).
Maybe it is a similar answer this time too.
Is it possible to create a form for
Hi all
I read of a free hosting site a while ago if you are developing mysql sites.
does anybody know about that? I can't find it anymore. Please I really need
to host my test page as the server I had it one broke. Can anybody help me
out
Thanks
peter
Good Morning People,
we're just facing a challenging problem ... we have a MySQL lessons
learned database. In two fields of the main table (LONGTEXT) we have the
description and the solution. You could think of two short abstracts,
regarding the lesson (some 100 words or more).
We need to
read of a free hosting site a while ago if you are developing mysql sites.
does anybody know about that? I can't find it anymore. Please I really need
to host my test page as the server I had it one broke. Can anybody help me
out
Use your favorite searchengine.
Bye,
B.
Anybody tried this? and hopefully got some good ideas of how to do it
properly?
I'm trying to create a perl script that just produces a MySQL compliant
SQL file based on the tables from Oracle, but I can't get everything work,
like indexes etc..
Someone?
// Johan Andersson
On Wed, 25 Apr 2001, Hunter Hillegas wrote:
As I'm having a lot of problems with the source distro, I'm considering
moving to your RPMs.
The manual suggests that there are a lot of problems with Linux and threads,
etc... and to use the prebuilt binaries if you can...
I've been using a
On Wed, 25 Apr 2001, arijit das wrote:
Sir,
I have downloaded the binary stable version of
MySQL from the site www.mysql.com.The package I
downloaded is ..
mysql-3.23.37-pc-linux-gnu-i686.tar.gz
After unzipping and untaring,I entered then
directory
Hello,
I have just resolved a problem that I encountered for the first time 1 year
ago 8-) 8-)
My problem was to store strings with some french special characters inside,
like é è à ç. When these characters were entered from a form written in
PHP, everything was OK but when they were
Bonjour,
J'ai le probleme des caracteres accetués (é è à,..)
qui sont remplacés par '?', j'utilise TOMCAT et apache
comme web server, et j'utilise mysql comme serveur de
données la génération du code html se fait par des
servlets java.
Ce que je suis sure est que le probleme n'est pas au
niveau
hi friends,
I got a downloaded version of MYSQL installed.
I am not able to create tables within in a database . I think some problem with the
edit options.Any solutionbut i am able to create a new database.
Gary Huntress, who sometimes posts on this List, runs such a free system.
It is found in his signature line, as follows:
SNIP ==
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
SNIP ==
- Original Message -
From:
Hello,
I have the problem of the characters accetués (é è to..)
who are replaced by '?', I use TOMCAT and Apache
as web server, and I use mysql as server of
given the generation of the code html makes itself by
servlets java.
What I am sure is that the problem is not to the
level database
I got a downloaded version of MYSQL installed.
I am not able to create tables within in a database . I think some
problem with the edit options.Any solutionbut i am able to create
a new database.
manual www.mysql.com
several websites: www.devshed.com and others.
Book: MySQL written
James Bonham writes:
Hello,
I have made several attempts at compiling and installing MySQL 3.23.36 and MySQL++
1.7.8 on Solaris 2.7 Ultra Sparc.
I have included the latest versions of GNU binutils, libtool, make, gcc as indicated
in the documentation in the proper path.
I have tried
Hi All
Problmes with mysql keys
When id do show columns from ACCOUNTING; in the Key field is see MUL.
Looking at the tec docs I can not find which type of key this is referring
to. Can some one tell me.
Thanks Simon
-
Before
Johan,
I'm working on something similar at the moment.
Attached at two files I downloaded from somewhere. If you import/attach
the
Oracle tables to an access database you could give them a try - I haven't
used them.
If you want a more complete solution, the Oracle views: USER_TABLES,
I've had the same problem once.
Reading the manual I found out that MySQL is not SQL conform
and does not support sub-selects.
You'll have to rewrite the statement that you don't need a sub-select
or if not possible create a temporary table.
Regards,
Robert
- Original Message -
From:
Hi all,
I have some questions for you. How much bigger mysql database is?
And there some query or some api call to retrieve random record from a table?
Thank you very much for your support
Regards
-Filippo Fadda
-
Before
Dag Nygren writes:
Hi,
I have been using xmysqladmin successfully for quite
some time to change the table structure of my databases
(as I haven't been able to fugure out how to do this with
mysqlgui...)
After doing lots of upgrades here, Linux - 2.4.3, glibc - 2.2
and mysql - 3.23.31
Description:
I am having a problem starting the mysql daemon from the command line.
I am using the following command from /usr/local/mysql :-
bin/safe_mysqld -u root
The resultant error file /usr/local/mysql/data/bon.err, has the following entries:-
mysqld started on Thursday April 26
Ashwin Kutty wrote:
Anyone notice any high CPU Usage with the following versions of the Linux
Kernel and MySQL
mysql-3.23.32-1.7
Linux 2.2.16-22smp
Other info..
Distro:- Redhat 7
Machine:- Pentium III 450
256 MB Ram..
I have gone through and edited my.cnf to see if that
Respected Sir,
We are facing problem in running this below given Query in mysql 3.23
SELECT COL1 FROM A WHERE COL1 NOT IN (SELECT COL2 FROM B WHERE COL3=001)
Table A (col1,col2 is of varchar )
Table B (col1,col2 is of varchar, col3 = numeric )
ALSO Table1.col1 == Table2.col1
SO Please let
Hi!
This is the FreeBSD 100 % CPU hang reported on www.innobase.fi.
It is fixed in MySQL 3.23.37.
Regards,
Heikki
..
Hey,
I dunno whether it's a bug or just I don't know how to use transactions
properly.
I've got 3.23.36 on FreeBSD 4.2-STABLE, and when I do
Hi!
I changed it to upcoming 3.23.38 so that it prints an error message
and calls exit(1).
Since you can run out of disk space inside InnoDB only when starting
the database after adding new data or log files to my.cnf, there is
not much need for interaction. If InnoDB would archive its log
Hello, MySQL Experts,
I wonder if you could give me some advice on a database design problem.
I have a table which will have many more reads than writes (between 10 and
100 times). I wish to make
updates to that table and to a slave table transaction safe. The basic
structure is of a master
I wonder how people use RDBMS w/o ever
reading manuals. Do they get paid for their
work?
- Original Message -
From: Sheshadri YS [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 26, 2001 6:57 PM
Subject: Unable to Solve NOT IN Problem
Respected Sir,
We are facing
On Thu, Apr 26, 2001 at 04:31:40PM +0100, [EMAIL PROTECTED] wrote:
Hello, MySQL Experts,
I wonder if you could give me some advice on a database design problem.
I have a table which will have many more reads than writes (between 10 and
100 times). I wish to make
updates to that table and
I was trying to sign up in order to leave a comment, and your application
crashed giving this message:
---Copied From Your Web Site---
Error: query insert into
web.user(email,pass,firstname,lastname,address,city,state,zipcode,id,phone,c
ell,fax,company,show_email,created) values
('[EMAIL
Hi!
InnoDB tables are often even faster than MyISAM tables for read access.
In updates and inserts it depends on whether you flush the log to
disk at a commit. A disk write takes some 10 ms. InnoDB does not lock
the rows it reads (a consistent read). Therefore the writes do not
block reads.
[EMAIL PROTECTED] wrote:
Hello, MySQL Experts,
Hello,
[.}
Alternatively, is there any way I can safely generate a unique id without
creating the master row?
The I could put the slave rows in before I create the master row, and I
wouldn't have a problem.
You can use one auxiliary
Does it help to put an Index on a column when you
use a LIKE query.
ex. SELECT * FROM users WHERE name LIKE '%tom%'
Thanks in Advance!
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
Description:
My Mysql server will not start properly.
I am attempting to start it from /usr/local/mysql, by typing the following
command :-
bin/safe_mysqld -u root
The screen responds with :-
[1] 5848
# Starting mysqld daemon with databases from /usr/local/mysql/data
mysqld
Dear Sir :
MySQL 3.22.32 on my linux 486 PC seems work so good. When I compile
a simple C API program which catched from MySQL tutorial, it
chokes at the end of compile process . The program is as follows:
#include stdio.h
#include mysql.h
#define def_host_name NULL
#define def_user_name NULL
Here is the part of the processlist from when the server was full...
| Id | User | Host | db | Command | Time | State|
Info
|
+--+---+---+--+-+--+--+-
At 9:31 AM -0700 4/26/01, Shane Gentry wrote:
Does it help to put an Index on a column when you
use a LIKE query.
ex. SELECT * FROM users WHERE name LIKE '%tom%'
Thanks in Advance!
In this case, It won't help, since you have a wildcard at the
beginning of your pattern. If you used
My goal is to be able to connect to the MySQL server on my web server from a local
computer. I need to do this for something I'm developing for a client. When I
connect to the database on the server itself I use localhost. What can I do to
connect from elsewhere?
I have granted the user
I've always used the following...
mysql -h server -u user -p database
and it's worked pretty well for me.
Ron
[EMAIL PROTECTED] wrote:
My goal is to be able to connect to the MySQL server on my web server from a local
computer. I need to do this for something I'm developing for a
OK, I have a perl script using mysql that pulls up a bunch of numbers
for a table. Problem is it's taking a long time because of the number of
select calls I'm making.
Basically, I have a sequence of calls of the form:
SELECT COUNT(*) FROM table WHERE conditions
(execute, get value of count,
I think this is an interesting question. Note the following:
count(col1) will tell you the number of non-null occurrences of col1
col1=value will return 1 is col1=value, 0 if col1value
1/0 will return null
thus,
count(1/(col1=value)) will tell you the number of occurences of value in
col1.
just curious but can't you do a SQL dump of oracle...and if so (since I'm not
up on it) whats' the correct syntax, especially from the command line...
Cheers,
Mikel
Johan Andersson wrote:
Anybody tried this? and hopefully got some good ideas of how to do it
properly?
I'm trying to create a
Hello all!
Here is what I am trying to do.
I am trying to find only records
that all have the same value for a
specific field in a related table.
A simplified example:
Table1 has 2 fields - id, name
Table2 has 2 fields - id, offon
Given these sets:
Table1
id name
---
1 Red
2
Look these select statments ¿?.
mysql describe sist_adm;
+-+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-++
| id |
At 4:44 PM -0400 4/26/01, Mikel wrote:
I'm trying to create a perl script that just produces a MySQL compliant
SQL file based on the tables from Oracle, but I can't get everything work,
like indexes etc..
Do you mean you cannot figure out how to find the index definitions from Oracle?
If
After kill mysql daemons and start again
mysql select * from sist_adm;
++--+-+---+
| id | nombre | so | descripcion |
++--+-+---+
| 1 | master | AIX 4.2
Hi,
Have you tried:
SELECT Table1.* FROM Table1 , Table2
WHERE Table1.id = Table2.id AND Table2.offon = 'on'
Hello all!
Here is what I am trying to do.
I am trying to find only records
that all have the same value for a
specific field in a related table.
A simplified example:
Diego Zabaleta wrote:
mysql select * from sist_adm;
++--+-+---+
| id | nombre | so | descripcion |
++--+-+---+
| 1 | master | AIX 4.2 | Equipo de
Where does mysql get the date from? mysql seems to be 12 hours behind the
rest of my machine.
mysql select sysdate();
+-+
| sysdate() |
+-+
| 2001-04-26 22:01:43 |
+-+
1 row in set (0.00 sec)
mysql Bye
tight:~# date
Fri Apr
On Fri, 27 Apr 2001, Opec Kemp wrote:
Hi,
Have you tried:
SELECT Table1.* FROM Table1 , Table2
WHERE Table1.id = Table2.id AND Table2.offon = 'on'
That was my original idea as well, but that would return Red, where Davin
wants no Red since there is a Table2 row with an off corresponding
howzabout
SELECT Table1.id, Table1.name, count(1/(Table2.offon = 'off')) AS NOFF
FROM Table1 , Table2
WHERE Table1.id = Table2.id
GROUP BY Table1.id, Table1.name
HAVING NOFF=0;
works for me:
mysql create table Table1 (id int, name varchar(10));
Query OK, 0 rows affected (0.01 sec)
mysql
Hi,
I'm useing mysql php and SSL on a colbalt raq, the problem I'm having is
that when ever I use the update query it doesn't always update, say just
UPDATE table SET f1 = 'update' WHERE id = '2'
some times when I first run the page it works but then other times it doesn't
update, I also
Nice query, Braxton. I was trying to do it with a left join, but that
required splitting Table2 into an OFF table and an ON table.
I must remember count(1/(condition)); it seems to be very useful.
Back to my real work...
---
David Block
[EMAIL PROTECTED]
So I think it is appropriate to post this here, as David and Monty are on
the advisory board for the conference. The web page for the previous show
is up on our site (osdn.com) and the site for the next one will be up
soon.
Anyhow, thanks!
Chris DiBona
--
2nd OSDN DB Summit Call For
Hi,
I have been running MySQL 3.22.32 for some time, and all has been ok until a week ago.
Now mysqld seems to hang whenever I try to connect. I have checked the logs and
nothing is reported there, and I thought at first it might be a hostname problem, but
everything resolves ok.
I start
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Is there a place to purchase the MySQL manual?
I don't think my printer can handle printing that thing out.
Thanks
- --
Rodney D. Myers [EMAIL PROTECTED]
Member of Digital Freedom Alliance
Amateur: KG6ANXGMRS: WPOM592
ICQ# : 18002350
Sorry if this is a little off topic.
I am trying to gather data concerning the use of database driven applications in a
business environment. Specifically, Intranet applications that are in use to increase
productivity and/or eliminate paper. Things like: meeting room scheduling, help desk,
Hello List,
I have recently installed mysql 3.23.33 on my windows 2000 machine. I
don't see anything in the documentation that I need to do to my machine for
setup (after the installation). I can run mysql fine, but it seems to be
only able to read. I want to create a new database.
it means it allow multiple records have same value in a table. i.e. It allow
index to contain duplicates.
it really is not a key. it is a kind of index instead.
if you have a table using a primary key say table_a, try to use SHOW INDEX
FROM table_a, then SHOW INDEX FROM ACCOUNTING. you can see
Hi,
I have only just joined this list today any help would be greatly
appreciated.
I have implemented the new MERGE table feature as part of my new install
on version 3.23.
I am finding a few small problems with usage of this functionality as
follows.
There are 4 identical tables namely
I have the following piece of code:
?
$host = localhost;
$user = webrings;
$password = XXX;
$link = MYSQL_CONNECT($host,$user,$password);
if ($link == 0) {
echo Can't connect to MySQL.;
exit;
} else {
echo Connection established.;
exit;
hi--
firstly, I am relatively new to mysql.
I am having a problem getting text I enter into a perl script (for reasons
of parsing and sending to my mysql database) to consistently get entered
into the database.
the perl script takes a mail message and makes the body of the message
$body. It
HI,
Try this
?
$host = localhost:/var/mysql/mysql.sock; // focus here
$user = webrings;
$password = XXX;
$link = MYSQL_CONNECT($host,$user,$password);
if ($link == 0) {
echo Can't connect to MySQL.;
exit;
} else {
echo Connection
Patric de Waha Lists wrote:
Try this
$host = localhost:/var/mysql/mysql.sock; // focus here
Nope, no dice. Same error msg (except /var/mysql/mysql.sock instead of
/tmp/mysql.sock). I didn't think it would matter either since I have a second
machine that does work, both
Somebody can tell me if the Text type is MySQL-specific or standard SQL?.
Thanks a lot.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
I had the same problem on with Red Hat 7 using mysql-3.23.33.
I installed from RPM and source. Never could get the darn thing working.
I just scrapped .33 and downloaded .36. Works like a charm now.
DG
Description:
I am having a problem starting the mysql daemon from the command line.
I
Hello
Can anybody answer me ?
my question was : is there a reason why mysql_data_home is set to '.' and not
'c:\mysql\data' ( for example ) ?
because windows is sometimes buggy and on some computers, the working directory is
changing on is own
( it migth be a virus... I can't tell...
Okay... Since I modified the process_priv() stuff I was able to get in and
see what was going on when the server ran out of connections.
It had 257 threads, all executing select statements that were in a Locked
state. There was one Update at the top of the list.
I'm going to go back and read
68 matches
Mail list logo