Hello,
Can anyone tell me if the MySQL database has a defualt user ID and
password? I am trying to access a remote DB with my application, but am
experiencing difficulties. This may be because I need correct user access
details. Are there such details, and if so, what are they please?
If your not the admin of the DB, you'll have to ask the DB's admin for your
login and password. If you are the admin, you'll need to RTFM about DB
security and the GRANT and REVOKE statements. And no, it's not a good idea
to allow connections using the root user to perform anything else other
Hey,
First of all, I want to say thank you to everyone that replied to my post a week
ago. I find it exceedingly humorous that large companies refuse to embrace open source
in favor of Microsoft or Sun because they fear not having the support when they need
it. I don't think that
What would be the correct query to convert a date stored in MySQL in a
DATETIME field to month_name month_date, year format at the same time I'm
pulling a bunch of other data from the same row as the field with the
date I need converted? I've tried something like the below without
success:
On 04-Jun-01 Alec Smith wrote:
What would be the correct query to convert a date stored in MySQL in
a
DATETIME field to month_name month_date, year format at the same time
I'm
pulling a bunch of other data from the same row as the field with the
date I need converted? I've tried something
How can I install the perl MySQL module (along with DBI) on a system
that will only be used as a client without installing the MySQL source
tree ?
Thank you.
=
ing. Andrei Boros
Centrul pt. Tehnologia Informatiei
Societatea Romana de Radiodifuziune
Hi,
We are developing a portal which has pictures
of machines in the form of HTML pages.
I want to know whether I can store HTML in Database
can I do search in the HTML pages stored.
Please let me know at the earliest.
Thanks in advance
Infiniti. Infotech India
Powered by MediaRing
I've been frying my brain over this problem for the past 24 hours and I'll
be very grateful for any hints.
I'm trying to recognize when the value for a field is changing value from
one record to the next. For an example, look at this:
mysql select sezione from faq limit 20;
+---+
|
Hello,
i'm writing an application in java and i have the following problem :
when i insert a record into a mysql table through the executeUpdate() method
of either Statement or PreparedStatement, does the method return immediately
or does it wait until MySql has the data written into the
I have only had a quick look over this and already have a question for the
simple example you've provided. How are you determining the last value
entered before entering the new value? The only way I see you of
effectively accomplishing this is through the use of a datetime column. Or
am I
Hi
Within mysql, all queries return the time taken to execute, ie
20 rows in set (0.77 sec)
35 rows in set (1.33 sec)
etc.
Is it possible within perl, or C for that matter, to get the time taken for the MySql
server to get the data ?
Thanx
Simon
--
Simon Windsor
CricInfo
I have a table1 in mySQL with the following recordset :
+++-+
| siteno | deptid | agentid |
+++-+
| 0 | 27 | 35 |
| 0 | 25 | 30 |
| 0 | 19 | 30 |
| 0 | 19 | 26 |
| 0 | 20 | 26 |
hello,
does mysql allow for recursive SELECTS?
is there a way to select a 'path in a tree' in one query ?
(the tree is stored in the following form:
parent_id int
id int
)
i know the ID of an element in n-th level of the tree, and i need
to get all its parent elements
database, sql
Hi there
I am battling to find out how to insert images into a blob field with visual
basic, and then read the information from the db and display in a picture
box. Has anyone got a sample of how to do this? I have inserted the image
into the blob field, but am not sure if the way
On 04-Jun-01 Harsh wrote:
I have a table1 in mySQL with the following recordset :
+++-+
| siteno | deptid | agentid |
+++-+
| 0 | 27 | 35 |
| 0 | 25 | 30 |
| 0 | 19 | 30 |
| 0 | 19 | 26
Hi!
The MySQL manual states that you can use ORDER BY in combination with the
UPDATE statement.
So I tried to use it, but it didn't work. Here is the sql query that's causing
the trouble:
mysql UPDATE alarms SET is_parsed=1 WHERE is_parsed=0 ORDER BY is_parsed LIMIT
1;
ERROR 1064: You have
I have only had a quick look over this and already have a question for the
simple example you've provided. How are you determining the last value
entered before entering the new value? The only way I see you of
effectively accomplishing this is through the use of a datetime column. Or
am
Does anyone have any SIMPLE proggies written in C++ using the MYSQL++
API library? Preferably MS Visual Studio 6 format. If so can you please
provide me a link for them or contact me over email directly.
I'm having problems compiling a project that just connects to the server
issues a query and
David Ayliffe writes:
Does anyone have any SIMPLE proggies written in C++ using the MYSQL++
API library? Preferably MS Visual Studio 6 format. If so can you please
provide me a link for them or contact me over email directly.
I'm having problems compiling a project that just connects to
Hi,
I notice a strange behaviour with OPTIMIZE TABLE and ANALYZE TABLE (on MyISAM table) :
Before analysing my table, mysql show me :
mysql show index from forumcontpresencepc6;
I have only had a quick look over this and already have a question for the
simple example you've provided. How are you determining the last value
entered before entering the new value? The only way I see you of
effectively accomplishing this is through the use of a datetime column. Or
am
Hi Richard,
In order for people to help you you will need to be more specific.
As specific as possible. Many of us here run FreeBSD and could help
you with more information. Possibly the problem is you are running
FreeBSD-current instead of FreeBSD-stable? Or FreeBSD 4.3? The
output from
Hi,
I am seeking emergency help to start up mysql database server. I tried to
use myodbc to connect mysql database from windows. I added a user on mysql
database user table and db table. Last Saturday when I rebooted Red Hat
Linux, mysql database server didn't come back any more. I don't know
Is mysqld runing?
Simon
-Original Message-
From: Ouyang, Sunny [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 14:56
To: '[EMAIL PROTECTED]'
Subject: emergency help
Hi,
I am seeking emergency help to start up mysql database server. I tried to
use myodbc to connect mysql database from
Ok. This is what I think you are wanting. Have a datetime field or even a
datestamp. Before you insert, do a select to find the value of the most
recent row that was added then you can calculate what you should insert from
there.
BTW you should include history incase some else has ideas.
Paul
I am a newbie regarding MySQL but have been using Postgresql, DB2 and
for years Sybase..
My installations are Linux (Caldera 2.3 2.4), OS/2 and WinNt.
My needs are a lan / Wan database..encompassing above OS's.
Problems: DB2 in Lan format too expensive
Postgresql w/ JDBC will not
Submitter-Id: submitter ID
Originator:
Organization:
organization of PR author (multiple lines)
MySQL support: [none | licence | email support | extended email support ]
Synopsis: synopsis of the problem (one line)
Severity: [ non-critical | serious | critical ] (one line)
no. Not at all. I logged into Linux server, type mysql. the server gave
the message says : error 2002: can't connect to local MYSQL server through
socket '/tmp/mysql.sock. Anyone has idea what's wrong with it?
-Original Message-
From: Simon Green [mailto:[EMAIL PROTECTED]]
Sent:
Last Saturday when I rebooted Red Hat
Linux, mysql database server didn't come back any more.
Try typing this on the command line:
safe_mysqld
Then tell us what happens. :-)
L.A.
-
Before posting, please check:
Ok so have you tride runing /usr/local/mysql/safe_mysqld
Simon
-Original Message-
From: Ouyang, Sunny [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 15:10
To: 'Simon Green'; '[EMAIL PROTECTED]'
Subject: RE: emergency help
no. Not at all. I logged into Linux server, type mysql. the
I got the message:
[root@mothra /tmp]# safe_mysqld
[1] 3922
[root@mothra /tmp]# Starting mysqld daemon with databases from
/usr/local/var
mysqld daemon ended
Are your databases in there? If you do a
ll /usr/local/var
Do you see a directory for each database of yours, with the
Hello,
I am trying to make a fulltext search over columns from two tables.
The queer thing is: sometimes it works, but more often I get the error message:
Got error 28 from table handler (in mysql_error output).
I am not sure what error 28 is, I checked the manual but couldnt find anything.
The
Yes. All of our mysql databases are there.
-Original Message-
From: Luca Accomazzi [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 10:28 AM
To: Ouyang, Sunny; '[EMAIL PROTECTED]'
Subject: Re: emergency help
I got the message:
[root@mothra /tmp]# safe_mysqld
[1] 3922
I got the message:
[root@mothra /tmp]# safe_mysqld
[1] 3922
[root@mothra /tmp]# Starting mysqld daemon with databases from
/usr/local/var
mysqld daemon ended
This is what I got when I rebooted the Linux server.
-Original Message-
From: Luca Accomazzi [mailto:[EMAIL PROTECTED]]
Alright alright...
I didnt want to believe it, but our disk is really full (got some funny
things going on at server terminal UGH!).
I hope my query will work okay once we get the server organized.
Thx anyways ;)
Nessi
-
Hi Britt
Tks for your reply
is it free of charge? if yes
please guide me. tks much
regards
Peter
From: Britt Johnston [EMAIL PROTECTED]
To: Peter Kok [EMAIL PROTECTED]
Subject: RE: install apache, php + mysql on linux redhat 6.2
Date: Mon, 4 Jun 2001 09:55:30 -0400
You might want to try an
Oh. forget it. it is not free!
tks again
regards
Peter Kok
Below is script for installing apache + php + mysql, it worked before
MySQL/PHP3/Apache Installation:
By default RedHat will have installed Apache web server on your computer. We
will need to remove it before we can
continue. If you
Hi Brian,
I checked boot.log and found the following message. I don't know whether
this causes the problem. Do you know what is DSO module? Do I really need
to recompile it? If so, how I can recompile it?
Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO
modul
I found my '/tmp/mysql.sock' is also empty. Is this supposed to be empty?
my '/tmp/myscript' is empty, too. Are they correct?
-Original Message-
From: karel pitra [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 10:33 AM
To: Ouyang, Sunny
Subject: Re: emergency help
check
"Ouyang, Sunny" wrote:
Yes. All of our mysql databases are there.
Do you have error log file? It should be in /usr/local/var
-Original Message-
From: Luca Accomazzi [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 10:28 AM
To: Ouyang, Sunny; '[EMAIL PROTECTED]'
Subject:
Yes. Here it is:
mysqld started on Sat May 5 14:02:18 EDT 2001
/usr/local/libexec/mysqld: ready for connections
mysqld started on Wed May 9 19:19:34 EDT 2001
/usr/local/libexec/mysqld: ready for connections
010524 10:41:04 Found invalid password for user: '[EMAIL PROTECTED]';
Igno
ring
php nothing error: when make and make install
./configure --with-mysql=/usr/local/mysql \
--with-apache=/usr/src/apache \
--enable-track-vars
I have a question. What should go after --with-mysql for RPM installtions?
I cannot find the answer to this question anywhere.
Thanks,
Neil
"Ouyang, Sunny" wrote:
Yes. Here it is:
mysqld started on Sat May 5 14:02:18 EDT 2001
/usr/local/libexec/mysqld: ready for connections
mysqld started on Wed May 9 19:19:34 EDT 2001
/usr/local/libexec/mysqld: ready for connections
010524 10:41:04 Found invalid password for
when I run this query
SELECT TT101991666187.crcid, TT101991666187.sum,
TT201991666187.sum, names.item
FROM TT101991666187 USE INDEX(PRIMARY)
INNER JOIN names USE INDEX(PRIMARY)
ON (TT101991666187.crcid = names.crcid and names.type = 29)
LEFT JOIN
Hi!
It was the same rollback bug which caused also crash in the case
you ran out of tablespace. I had overlooked that the same bug causes
problems also if you rollback a transaction which has updated the
same row more than once.
You can download the fixed /mysql/innobase/row/row0undo.c from
my
What is the owner/group permissions on /usr/local/var also is there
an error message in the file /usr/local/var/myserver.mydomain.err ?
The mysql user must have all permissions on the directory in order to
read and write.
Ken
-
Ken Menzel
thats because your server isn't running. mysql is the client
(AFAIK). But if your running redhat, you can
/etc/rc.d/init.d/mysql start
and it should work
-nico
-Original Message-
From: Ouyang, Sunny [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 15:10
To: 'Simon Green'; '[EMAIL
47 matches
Mail list logo