Hi.
See:
http://dev.mysql.com/doc/mysql/en/GRANT.html
http://dev.mysql.com/doc/mysql/en/Access_denied.html
http://dev.mysql.com/doc/mysql/en/Privilege_system.html
And may be something like this will help you:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip address' IDENTIFIED BY
Hi.
See:
http://dev.mysql.com/doc/mysql/en/BDB_portability.html
What OS do you use?
What is the output of the following statement:
SHOW VARIABLES LIKE 'have_bdb';
If you don't need bdb try to start MySQL with skip-bdb in /etc/my.cnf in section
[mysqld]
And you may use official
Hi.
You may upgrade to the latest release and try again.
What compiler do you use?
I'm using 4.0.20a on Windows 98.
My program compiler successfully but gives a linker error:
C:\SC\BIN\..\lib\mysqlclient.lib(default) Offset 955A0H Record Type 00C3
Error 16: Index Range
---
An example, which use a subquery (available from MySQL 4.1):
select eqid, paramid, lastmodified, value from eq_deltalist param1
where lastmodified = (SELECT max(lastmodified) FROM eq_deltalist
WHERE paramid = param1.paramid AND eqid = param1.eqid AND
lastmodified = now())
You would probably
In MySQL versions before 5.0, you can write a user-defined function in C
and compile it as a shared object. Beginning with MySQL 5.0, you can
write stored routines. See these sections of the MySQL Manual:
http://dev.mysql.com/doc/mysql/en/Adding_functions.html
OK so how do you reconfigure? Here's what happens when I try this:
./configure CC=gcc CFLAGS=-O3 -fno-omit-frame-pointer CXX=gcc \
CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors \
-fno-exceptions -fno-rtti \
./configure --prefix=/usr/local/mysql \
--with-extra-charsets=complex
I disagree with your LEFT JOIN/RIGHT JOIN results.
SELECT
activenodes.name,lrsrc.lid,activelayers.rsrcc,lrsrc.rsrc,nrsrc.rsrc
FROM activelayers
LEFT JOIN lrsrc ON lrsrc.id=activelayers.id AND
lrsrc.lid=activelayers.lid
RIGHT JOIN nrsrc ON lrsrc.rsrc=nrsrc.rsrc
RIGHT JOIN activenodes ON
That's right, it's a precompiled binary. If you want a different
configuration, you have to download the source and build your own
http://dev.mysql.com/downloads/. I haven't tried --enable-shared on Mac
OS X, so I can't promise it will work, but I'm not aware of any reason it
wouldn't.
In
Hi All,
I have o little (I think) doubt:
If I use a query UPDATE LOW PRIORITY and right after
I execute a SELECT in the same table/column.
Will I receive the correct result or only after MySQL commit
the data?
Any help would be appreciated,
Thanks,
Ronan
--
MySQL General Mailing List
For
At 12:26 -0300 11/1/04, Ronan Lucio wrote:
Hi All,
I have o little (I think) doubt:
If I use a query UPDATE LOW PRIORITY and right after
I execute a SELECT in the same table/column.
Will I receive the correct result or only after MySQL commit
the data?
What is the correct result?
Any help would be
What is the correct result?
The correct result is the data in the updated column after commit.
For example, if I have:
Table1
=
- id
- name
INSERT INTO Table1 (id, name) VALUES (1, 'AAA')
UPDATE LOW PRIORITY Table1
SET name = 'BBB'
SELECT name
FROM Table1
Will it return BBB?
Thanks,
[snip]
Will I receive the correct result or only after MySQL commit
the data?
[/snip]
From TFM, If you specify the LOW_PRIORITY keyword, execution of the
UPDATE is delayed until no other clients are reading from the table.
You can get more by RTFM at
http://dev.mysql.com/doc/mysql/en/UPDATE.html
Hi.
Please download and install official binaries, as this looks like a compilation bug
which is likely to occur when compilation is done by hands on Linux. :)
folks I have successfully compiled and install mysql-4.1.7 from source
in my Debian (3.0, lots of free space in hd, 64MB RAM)
If you specify the LOW_PRIORITY keyword, execution of the UPDATE is delayed until no
other clients are reading from the table.
So, when it returns, all updates will be commited and select statement will return the
correct result.
Ronan Lucio [EMAIL PROTECTED] wrote:
Hi All,
I have o
Jay,
From TFM, If you specify the LOW_PRIORITY keyword, execution of the
UPDATE is delayed until no other clients are reading from the table.
Yes, I had alread read it, but it only specify when the data
will be commited, not what will be returned.
Let´s change the question:
Before the that
Gleb,
So, when it returns, all updates will be commited and select statement
will return the correct result.
It´s exactly what I´d wanted to know.
Thank you very much,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
OK using the source and adding '--enable-shared' to the configure line
works on OS X. I then had to create 3 links in order for our app to find
the client library:
ln -s /usr/local/mysql/lib/mysql/libmysqlclient.12.0.0.dylib
/usr/lib/libmysqlclient.12.0.0.dylib
ln -s
At 12:46 -0300 11/1/04, Ronan Lucio wrote:
What is the correct result?
The correct result is the data in the updated column after commit.
For example, if I have:
Table1
=
- id
- name
INSERT INTO Table1 (id, name) VALUES (1, 'AAA')
UPDATE LOW PRIORITY Table1
SET name = 'BBB'
SELECT name
FROM
At 11:22 -0500 11/1/04, Paul DuBois wrote:
At 12:46 -0300 11/1/04, Ronan Lucio wrote:
What is the correct result?
The correct result is the data in the updated column after commit.
For example, if I have:
Table1
=
- id
- name
INSERT INTO Table1 (id, name) VALUES (1, 'AAA')
UPDATE LOW
Hi,
Can anybody help me with a linux newbie question. I want to use
mysqldump to backup all of the tables in a database that start with z_.
Can I do this in linux with a single line? Thanks.
please provide me listof my.cnf parameter values for 4 GB RAM . from support
files i can list out only upto 2 GB RAM
my database is mysql 4.0.20 binary installation on linux and along with
database apache, tomcat and one more application is running on the server.
Thanks in advance
Anil
--
I have 2 tables, category and ticket (relevant description follows):
mysql describe ticket;
+-+-+--+-+-++
| Field | Type| Null | Key | Default
| Extra |
Hi.
Tune key_buffer_size for it. And you may want to order commercial support to receive
finetune of your server: go to https://order.mysql.com/?ref=ensita
Anil Doppalapudi [EMAIL PROTECTED] wrote:
please provide me listof my.cnf parameter values for 4 GB RAM . from support
files i can
I've checked through the archives a documentation but cannot find an
answer to my problem. I'm attempting to load data from a text file
that has a column that is not present in my database table.
Table
B C D
File
A B C D
I've been trying to find a way to ignore the first column of the text
file
newbie question about mysql admin clients. What are some good ones? And
importantly can they access and allow me to edit the db record fields
themselves? eg. I see a mis-spelled word in a field - I could go in
there and edit the field.
Thanks,
lee G
--
MySQL General Mailing List
For list
I am using the C API with MySQL 4.0.17 on QNX 6.2.1b.
I want to update the rows that are returned as I get them. Is this
possible. Here's a simplified version of what I am trying to do:
query = select seqNo, priority from packet where timestamp now() -
interval 15 second order by priority
GH wrote:
Greetings:
This is just a friendly reminder that if you are registered in the
United States to VOTE on November 2, 2004 (TOMORROW)
Need to know where you vote?
Please see the attached file (it is an image) that contains some information
Do we care? Realy? Unlikely. Maybe you should
At 15:18 -0800 11/1/04, Stephen Rasku wrote:
I am using the C API with MySQL 4.0.17 on QNX 6.2.1b.
I want to update the rows that are returned as I get them. Is this
possible. Here's a simplified version of what I am trying to do:
query = select seqNo, priority from packet where timestamp now()
Dear AlL,
my former question is how to run mysql service. but now i have run mysql service
[EMAIL PROTECTED] root]# service mysql start
Starting MySQL Server [ OK ]
but i still cannot connect to mysql
[EMAIL PROTECTED] root]# mysql
ERROR 2002: Can't
It can has many reason:
1.Your Socket file doesn't exist!
2.If it does exist,Please kill your mysql instead of
running its daemon,run its file in bg mode. (with
sign)
--- Cecep Rosuludin [EMAIL PROTECTED] wrote:
Dear AlL,
my former question is how to run mysql service.
but now i have
MySQL online administration docs equivalent of the book. They are
exactly the same.
If you need more advanced details in about administration, you can read
some other books.
-Original Message-
From: Mark Day [mailto:[EMAIL PROTECTED]
Sent: Friday, October 29, 2004 9:25 AM
To: [EMAIL
Spenser,
thanks for respons, I have done what you've ever done. this the result
[EMAIL PROTECTED] root]# ps -e | grep mysql
[EMAIL PROTECTED] root]#
- Original Message -
From: Spenser [EMAIL PROTECTED]
To: Cecep Rosuludin [EMAIL PROTECTED]
Subject: Re: Can't connect to local MySQL
My query works:
(version 4)
SELECT u.id, r.user_id,
u.first_name, u.middle_name, u.last_name,
u.company, u.department, u.address, u.address2,
u.city, u.state, u.country, u.zip,
u.phone, u.fax, u.email,
DATE_FORMAT(u.updated, '%m/%d/%Y'), DATE_FORMAT(u.added,
On Tue, 2 Nov 2004 01:12:37 +0200, Polyakov Dmitryi
[EMAIL PROTECTED] said:
Hello leegold,
for what OS? or you need just web-based app?
for win - MySQLFront
web-based - phpMyAdmin (PHP required)
Tuesday, November 2, 2004, 12:57:46 AM, you wrote:
But can I edit a column field? Can I go
There are lots of ways to do it. My personal favorite is to write it in
Perl with the DBI library and tell cron to run that Perl script ... your
Perl script could then write the data in any format you see fit, even
send it somewhere else using Net::FTP or whatever.
Just my $0.02...
-id
Scott
But can I edit a column field? Can I go into a specific column in a
specific record and edit it just like I was in a text editor? That's the
action I want. None on the products specifically state they can do it(?)
phpMyAdmin will allow you to alter a column name within a table, yes.
can't speak
Spenser,
[EMAIL PROTECTED] root]# ls -l /var/lib/mysql
total 20564
-rw-rw 1 mysql mysql25088 Nov 1 14:10 ib_arch_log_00
-rw-rw 1 mysql mysql 10485760 Nov 2 07:39 ibdata1
-rw-rw 1 mysql mysql 5242880 Nov 2 07:39 ib_logfile0
-rw-rw 1 mysql mysql 5242880 Nov 1
You could write a bash script like this:
#!/bin/bash
mysql -u username -ppassword --exec=SELECT...; textfile.txt
There's no space after -p and before the password. This will export the
results to a simple text file. It might not be in format you want
though. But, it gives you an idea of
Scott Haneda wrote:
My query works:
(version 4)
SELECT u.id, r.user_id,
u.first_name, u.middle_name, u.last_name,
u.company, u.department, u.address, u.address2,
u.city, u.state, u.country, u.zip,
u.phone, u.fax, u.email,
DATE_FORMAT(u.updated, '%m/%d/%Y'),
[EMAIL PROTECTED] root]# ls -l /var/lib/mysql
total 20564
-rw-rw 1 mysql mysql25088 Nov 1 14:10 ib_arch_log_00
-rw-rw 1 mysql mysql 10485760 Nov 2 07:39 ibdata1
-rw-rw 1 mysql mysql 5242880 Nov 2 07:39 ib_logfile0
-rw-rw 1 mysql mysql 5242880 Nov 1 14:10
Daniel Kasak wrote:
Write your script with the following line at the top:
tee /path/to/output/file.sql
Actually thinking about this more, you can probably skip this bit and
just direct your output from the command called by cron, as per
Spenser's example.
ie:
mysql -u username -ppassword
Hello, MySQL gurus,
I am just wondering if there is a way to set MySQL so that you
can have the name of the mysql table completed for you if you hit tab,
like typing file names in bash, you only need to type enough characters
to uniquely identify the file or directory name, then you press
It should already by enabled for you unless you have the line
no-auto-rehash in your my.cnf configuration file. Or you could be
starting mysql with --no-auto-rehash or -a.
On Mon, 2004-11-01 at 20:27, Ginger Cheng wrote:
Hello, MySQL gurus,
I am just wondering if there is a way to set
At 18:27 -0800 11/1/04, Ginger Cheng wrote:
Hello, MySQL gurus,
I am just wondering if there is a way to set MySQL so that you
can have the name of the mysql table completed for you if you hit
tab, like typing file names in bash, you only need to type enough
characters to uniquely
All of the unicode collations listed in the reference manual except the binary
collations are not sensitive to diacritical marks. That is, if I do the following:
create table t ( filename varchar(260) ) type=InnoDB CHARACTER SET utf8 collate
utf8_unicode_ci;
-- insert an e-acute
insert into t
ian,
[EMAIL PROTECTED] root]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
[EMAIL PROTECTED] root]#
this my script of my.cnf
[client]
port= 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port= 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
[EMAIL PROTECTED] root]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
[mysqld]
port= 3306
socket = /var/lib/mysql/mysql.sock
Which is fine ... you neglected to say whether or not that fixed your
problem?
-id
--
MySQL General Mailing List
For list archives:
yes that I did (installed binaries) and it's working now. *sigh*
wish I could use the source.
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Monday, November 01, 2004 06:56 PM
To: [EMAIL PROTECTED]
Subject: Re: max allowed packet error
Hi.
Hi Lists ,
My Query is How Can I store Images in the MySQL Database , and how to Index them ,
can anybosy help me on this please
I am starting out a Online Photo Gallery and want to share them , and I want to
make the search available, Does anybody has already done on this ?
Hi Nikhil,
Have a look at www.hotscripts.com for either a script that dose this or a
tutorial to show you how to do it.
But in general you DO NOT store the image in a MySql table you just store
its location name i.e. 'images/image1.png' and then with a select
statement use the result in a 'img
50 matches
Mail list logo
