I am using MySQL 4.0.22 and have a question about an efficient way to calculate
a running balance as part of the select. The natural way to do this would seem
(to me) to be something like:
set @balance:=0;
select payid,Custid,Paid,@balance:[EMAIL PROTECTED] from payments;
This does indeed see
My question question from MySQL 4.0.22: is it okay that a null interger tests as
equal to any value. I am not sure the table structure matters but in case it is
I included it.
I did not expect that null was not not-equal to 1. Cursory testing seems to
indicate that a null integer field is not not-
Thanks but I still do not get why this does not merit a, "you might want to
think about this".
So in the following query:
select * from new_payments where closed<>1;
it is desired that null=1. DeMorgan's law takes a vacation here.
Correct behavior, in that it is a feature, I expected that; des
Belay my comments on true and false. I got mixed up. That works as documented.
On Mon, 19 Sep 2005, Roger Baklund wrote:
> [EMAIL PROTECTED] wrote:
> > I did not expect that null was not not-equal to 1.
>
> Any comparison with NULL returns NULL:
>
> mysql> select null<>1,null>1,null<1,null=1;
> +
Thanks Martijn - that is a clear explanation of the philosophy. I did not get it
from the examples and the manual.
Doug
On Mon, 19 Sep 2005, Martijn Tonies wrote:
> Hello Doug,
>
>
> > My question question from MySQL 4.0.22: is it okay that a null interger
> > tests as
&
First - thank you. I want to again thank this list, which in general is the most
tolerant to people new to database use and theory in general, and me in
particular. I mostly got your point from an earlier answer. Hopeful your example
quashes my ignorance, relative to NULL at least.
I think I under
I have a php application that connects with MySQL using:
$SvrConn = @mysql_connect($MySQLServer, $MySQLUser, $MySQLPassword)
where: $MySQLServer='127.0.0.1'
$MySQLUser='dbuser'
MySQLPassword='dbpasswd'
and I can login using the above values. However connect fails:
mysql> sele
should be
like accessing mysql from the command line.
On Tue, 17 Jan 2006, Logan, David (SST - Adelaide) wrote:
> Hi Doug,
>
> It is probably failing because you changed the ip address. The security
> system in MySQL is based around where a user is coming from. There is
> good docume
0) | YES | | NULL | |
| status| varchar(20) | YES | | NULL | |
| Start | date| YES | | NULL | |
+---+-+--+-++---+
I am using 4.1.20. As always thank you for your
Thank you.
On Wed, 21 Jan 2009, c...@l-i-e.com wrote:
The natural join will JOIN on *all* the fields whose names match, not just the
ones you want it to.
In particular, the JOIN is matching up .expires and .expires with "="
You then use WHERE to get only the ones with ">"
This is a tautolo
a csv file to 'insert value' statements.
My implementation question is about specifying the user. Apparently the
following are different:
1) user@localhost
2) 'user@localhost'
3) 'user'@'localhost'
I have not tested all this, but I did gran
Got it - thank you, I did not think about the meaning of file except as it
relates to MySQL. Re syntax - thanks.
On Sun, 31 Jul 2011, Claudio Nanni wrote:
Hi Doug,
1.FILE is GLOBAL because it refers to the ability of the user to read/write
files on the server host filesystem (where the
aster is up again, how will I restore those data new updated
into slave to master?
Thank you.
Regards,
Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hello,
can you tell me why my this query doesn't use the index?
mysql> explain select * from iploc where 1902800418 between start_ip
and end_ip;
++-+---+--+---+--+-+--+---+-+
| id | select_type | table | type | possible_keys | k
Hello,
When connecting to mysql, sometime I got this error:
# mysql -ucdn -h113.108.22x.xx -p
Enter password:
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading
initial communication packet', system error: 0
But most time it's correct.
What's the reason? Thanks.
I am running mysql
sorry the problem has been resolved.
it's the reason of open_files_limit too small.
I increased it and the problem resolved.
2012/12/22 Doug :
> Hello,
>
> When connecting to mysql, sometime I got this error:
>
> # mysql -ucdn -h113.108.22x.xx -p
> Enter password:
>
Hello,
why these db names created fail but the last one gets success?
mysql> create database 3208e1c6aa32;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '3208e1c6aa32' at line 1
mysql> cre
I have the following table:
explain domain_payments;
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-+---+
| Invid | int(11) | | | 0 |
Is the online documentation for 4.0.x available? I was working with
dates a while back. As it happens 4.1 added the very function I wanted.
But that was not marked as added in 4.1, nor should be be as that would
be an unbelieable amount of cruft.
I would be nice however if maybe one level back was
I have read the MySQL Cookbook and the last 6 months (or so) of threads
on this. I have a slightly different problem. I use a billing system
implemented in filemaker. Happily they are going a rewrite in MySQL/PHP,
but for the present I maintain a MySQL database so I can track things
otherwise not a
Yes - thanks. I did not define the data with keys because it does not
come out of the source that way. Keys and replace does it nicely.
Probably my question defined me as a newbie, if not well...
Thank you very much for you help.
On Wed, 20 Apr 2005, Duncan Hill wrote:
> On Wednesday 20 April 2
Thank you for the clear statement of policy. I had in fact forgotten
about the manual that comes with the installation. It however is
packaged as one rather large html or text file (my system is FreeBSD).
The web site is a far superior reference because of the file format.
Doug
On Thu, 21 Apr
Just in case you did not follow this suggestion, if you are using 4.0.x this is
very simple. I was looking for this:
set @total:=0;
select f1,f2,...,@total:[EMAIL PROTECTED] as Total from table where ...;
is pretty simple.
On Wed, 25 May 2005, Dan Bolser wrote:
> On Wed, 25 May 2005, Russel
Hi:
I am new to MySQL and can not find how to do this. I am running 4.0.16. Table1
has the correct values for a common field. Table 2 (the real one) needs to be
updated from t1 via a common field.
Can this be done with joins. And if not what is the best way.
Thanks for any suggestions.
_
Do
This has to be something silly, but I can not see it. Any help greatly
appreciated:
use newshop;
insert into products set storeid=2, deptid=5, groupid=66, prodid='C2BUWS1028',
prodtitle='Antique Circle 6/20; 1/2inches-lg Pearl Buttons & Novelty
Buttons',
proddesc1='3 buttons per card; 1/2
:(
Thank you - my only defense - it was 04:00, I think I looked at it too
long and got hung up on the line 2.
Doug
On Mon, 12 Jan 2004, Johan Hook wrote:
> Hi Doug,
> I think you need to quote "imgsml=C2BUWS1028.jpg," like
> imgsml='C2BUWS1028.jpg',
>
> t
The db in question is a shopping cart and I was looking for products I added
that might have been duplicated in another category. My first attempt that
worked.
select prodid,count(groupid) as cnt from products
where (groupid=65 or groupid=66)
group by imgsml order by cnt;
The thing wrong with
ouch
To Jimmy and Chris and the list in general. This list is particualiarly kind to
question of this nature. I for one appricate it. In this case it is amazing how
many wrong things I came up with.
On Tue, 13 Jan 2004, Chris Elsworth wrote:
> On Tue, Jan 13, 2004 at 02:03:26AM -0500, [EMAIL
My question is how to improve an update. I had a set of records from an external
source to add to a table. In the new data one of the key values was not known.
It turns out that another key can be matched to key values in the old data
(extracted to the table temp).
The relation between the keys ca
I have a system running FreeBSD 4.9 four jails. MySQL is running in two of the
jails and I am trying to add it to a 3rd jail. Starting the server gets the
message:
040302 19:34:15 mysql started
040302 19:34:15 Can't start server : Bind on unix socket: Permission denied
040302 19:34:15 Do
Thank you for the replies. Jail is a FreeBSD construction that provides a
chroot'ed environment that allows you to create another instance of the entire
OS. So in my case the physical server running the jails appears to the world
like 5 hosts. Each jail has its own IP and is running an independent
problem in the system I used as
a template because /tmp is a UFS there.
Doug
On Wed, 3 Mar 2004, Michael Stassen wrote:
> This error usually occurs for one of two reasons:
>
> 1. There is already a /tmp/mysql.sock. You've ruled this out.
>
> 2. The user mysqld runs as, typic
I have a question about the multiple table delete syntax. First the
documentation on the website is very clear. My question is why not how. The
'delete from using' is not ambiguous (to me). My question is about the form:
delete t1 from t1,t2 where ...
I would take this to mean remove matching
I have no problem understanding the syntax, or how to do what I want (at least
after my first mistake). It is more about if this is a consistant grammar. For
example, unix commands have the form " ", except for "ln -s"
(IMO).
>From a lexical view, I do not think the two forms are parallel. My que
I was trying to allocate a new user and I typed something like:
grant all privileges on pail to [EMAIL PROTECTED] identified by 'hill';
I realized I made a mistake needing to specify (at least) 'pail.*', intending to
grant the user access to a database I created. So to clean up I tried:
revo
REVOKE ALL PRIVILEGES FROM [EMAIL PROTECTED] seems to be a 4.1 form of the command
(I have 4.0.15) but adding '@localhost' did the trick. Thank you.
On Wed, 17 Mar 2004, Michael Stassen wrote:
>
> [EMAIL PROTECTED] wrote:
>
> > I was trying to allocate a new user and I typed something like:
> >
>
Not using perl or php I came up with:
mysqlshow -u user --status db_name | awk -F"|" '{print $2,$5}' | grep -i pattern
Is there a query to do the same thing?
_
Douglas Denault
[EMAIL PROTECTED]
Voice: 301-469-8766
Fax: 301-469-0601
--
MySQL General Mailing List
For list archives: http:/
;member.txt" is in the samp_db folder, and it is.
Any suggestions would be greatly appreciated...
Thanks,
Doug Coning
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
> MySQL 3.23.29: up 31 days, processed 237,155,060 queries (87/sec. avg)
Ok Jeremy I have to ask: How do you get your MySQL stats in your signature
like that?:->
Doug Henry
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Ben Smith"
Can any one help me with this mysql error.
"MySQL dead but subsys locked" I goofed in setting up the root user and tried a
couple of not too bright things. Now I cannot even get MySQL started.
reply to [EMAIL PROTECTED]
Than
Hi All, can someone point me in the right direction for saving
formatted RichEdit Text to a blob field and then loading the RichEdit field
with the data from the blob. I am using Borland Builder 5 odbc to MySQL
database.
Regards
Doug
[EMAIL PROTECTED
I am running mysql 4.1.13 on Suse 10 and I get an error on a simple
select query, I have checked the threads on lost connection and my
connection times as well as making sure my calls are all made from non
forking processes etc... I cannot seem to resolve this error? can
someone point me in
gone
through this document for the last week rewritten code based on the
suggestions and still get the error.
Regards,
Doug
oug Dalton wrote:
I am running mysql 4.1.13 on Suse 10 and I get an error on a simple
select query, I have checked the threads on lost connection and my
connection
Gleb,
I watched the server during this error, the server continued to run...
it didnt crash... and no warning or logged error?
Regards,
Doug
Doug Dalton wrote:
Gleb Paharenko wrote:
Hello.
Check that MySQL doesn't die during the query. See:
http://dev.mysql.com/doc/refman/5.0/en
y isnt malformed
Regards,
Doug
Doug Dalton wrote:
Gleb,
I watched the server during this error, the server continued to
run... it didnt crash... and no warning or logged error?
Regards,
Doug
Doug Dalton wrote:
Gleb Paharenko wrote:
Hello.
Check that MySQL doesn't di
I'm a total newbie working through the tutorial in DuBois's _MySQL_.
I've got MySQL running on my PowerBook. In Terminal, I can use the
mysql client to get responses to things like SELECT NOW(). But the
command CREATE DATABASE sampdb; results in the following error.
ERROR 1044 (42000): Acce
u
get the extra benefit of the traffic being encrypted, plus you don't
have to worry about changing the permissions every $x hours when your IP
changes.
-Doug
--
Douglas Phillips
Programmer / Database Engineer
Cybergroup, Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysq
ences?
Thanks much in advance - I'm scratching my head on this one...
-Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> It's possibly a DNS problem (reverse DNS exactly).
You know, I'm feeling a bit stupid here... That was indeed the problem,
as the new server hadn't been moved on DNS yet.
I put the IP address into the windows hosts file on the DB server, and
the problem cleared up immediate
ll. So you will know if it is a mysql
problem or not.
cheers,
Doug
On 13 Aug 2008, at 05:39, Krishna Chandra Prajapati wrote:
Hi all,
Connecting to mysql server (Production) is taking 5 to 6 seconds.
Production
has 16Gb ram. Previously it was using only 6GB ram. The details are a
if you switch the default engine type any new tables would be created
with that new engine type. it does not convert existing tables to
your new format.
if you have existing innodb tables you need to have the innodb
settings active, in my.cnf
On 15 Aug 2008, at 06:01, [EMAIL PROTECTED]
the system resources. Is it definitely mysql,
or php/apache, a slow disk, etc..
In terms of your stats below, I have (on a fairly average spec
server) 500 queries per second and 2000 open tables. So, unless it's
a PC or very badly tuned, it should be fine.
cheers,
Doug
On 23
own MySQL and restart, it's normal again.
Weird, no?
On 23-Sep-08, at 3:47 PM, Doug Bridgens wrote:
it's all a bit too general, we could be asking continual questions
until someone asks the right one.
However, I would put some debugging into the 30% scripts to check
they complet
It works for me, I used your code:
Field =mycol Type=254 Length=20
so at least your code is fine, and the problem must be somewhere
else. I am using RH EL3.
cheers,
Doug
On 6 Oct 2008, at 19:52, Mike Aubury wrote:
I'm probably being a bit stupid - but I'm trying to determine
When I do a SELECT using STRAIGHT JOIN against multiple tables where the
main table has about 200k rows, it is very fast retrieving the latest rows,
ie "LIMIT 0, 10", but extremely slow retrieving older rows, for example,
"LIMIT 18 , 10". Doing an EXPLAIN shows that no filesort or temporary
Hi,
I have tried to simply the problem and it exists without any JOINs.
have you given the query ?
SELECT id FROM stuff ORDER BY stuffed_date DESC LIMIT 18, 10 -> .43 sec
SELECT id FROM stuff ORDER BY stuffed_date DESC LIMIT 0, 10 -> .0007 sec
have you described your tables ?
stuffed
ys that it's at /usr/local/msql. I could find
no such path. I searched my local drive for all occurrences of mysql,
but it found only those that occur within the Lasso package. Can
someone help me out?
Thanks,
Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
Media that WORKS."
___
Doug Wolfgram
CEO
GRAFX Group, Inc.
949.433.3641
http://www.gfx.com
http://www.aimprojects.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there any easy way to create this type of QUERY?
I am trying to get a list of usernames from table A who do NOT have a
linked record in Table B.
D
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
JOIN billing_payment ON (
billing.invoice=billing_payment.invoice ) WHERE billing.invoice=10001 GROUP
BY billing_payment.invoice;
+-+--+-+
| invoice | paid | balance |
+-+--+-+
| 10001 | NULL |NULL |
+-+--+-+
1 row in set (0.00 sec)
NULL values in this result are no
invoice total,
but that seems like a step backwards. is there a way to do what i was
doing with v3.23, given the new NULL behavior?
thanks in advance.
doug
At 02:53 PM 7/17/2003 +, [EMAIL PROTECTED] wrote:
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent
>Description:
I'm running mysql in a 3 server configuration, with 2 servers being slaves
to the first. I'm running vpopmail, which means a connection every incoming
mail and every check. I woke up this morning to a mysql that wasn't
answering connections, and that had left this in the log:
030716
this,
just perhaps suggest where I can look.
BTW, I searched for this and got a reference to the perl-DBD-Mysql module,
which I do not have installed.
D
-
PresenterNet
The Interactive Presenters' Network
Doug Wolfgram - CEO
949.248
ysql/mysql.sock
[mysql.server]
basedir=/usr/bin
Any assistance is greatly appreciated.
Doug
A query which is constantly being run takes about 3 seconds when not cached,
and I was wondering if there were any way to speed this up. There are
several tables being joined and sorted by latest date with a LIMIT of 10.
All fields being joined by are indexed. So I'm not sure what else I can do.
Thank you for your detailed response.
You might get better performance just from using the explicit INNER JOINS
but I make no assumptions.
I tried INNER JOINS and did not see any difference in speed.
You may also get better performance if you had
composite indexes (not just several individual field
Using INNER JOINs with the STRAIGHT_JOIN option so that the main table
displayed first in the EXPLAIN eliminated the temporary table being created
and the query speed went from 2.3 seconds to 0.2 seconds. Note that this
only works for queries where the offset in the LIMIT is small. As the offset
not in business.."
_____
Doug Wolfgram
GRAFX Group, Inc.
Cell: 949.433.3641
http://www.gfx.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SID in a file called
tnsnames.ora. Those do not exist on the system I am using. Is it
possible to still use oracledump in this case?
--
Regards,
Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
as if oracledump requires Oracle's network layer
> (SQL*Net) and
> unless you have that you can't do anything.
>
> The oracle thin JDBC driver implements
> SQL*Net for java only, but the other Oracle jdbc drivers require SQL*Net
>
Thanks for the reply. Looks like I&#
On Mon, Sep 01, 2003 at 11:09:02AM -0700, Martin Gainty wrote:
> Doug
> I copied this from an SAP integration with Orace site
> http://saphelp.cob.csuchico.edu/OraHelp/Darwin36/inst36fhp/html/5-odbc.htm
>
> 5.5.3 tsnames.ora File
> the file
> ORACLE_HOME/network/admin/tnsna
java-based application
(JOracleDump) and am modifying that to do what I need.
--
Regards,
Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nnel your connections over an ssh tunnel, or setup an ipsec tunnel.
--Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
easier to
setup (especially if you're already using unix-like machines on both the client and
server) and definately more secure. IPSEC would also be significantly more difficult,
but you wouldn't have to worry so much about the secure session going down.
--Doug
On Thu, Nov 06, 2003 at
ENOUGH ALREADY!!!
Either take this inane exchange to private ranting or to a more
appropriate forum.
DET
MySQL, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi:
You might find these articles from O'Reilly Network will help clear the
water.
http://www.onlamp.com/pub/ct/19
Doug
On Thu, 5 Dec 2002 07:46:03 -0800 (PST), Michelle de Beer wrote:
>I believe this question is solved by a join, but I
>haven't really got a hang of
The explanation at
http://www.mysql.com/doc/en/Column_types.html
provides more detailed information.
Regards,
Doug
On Sat, 7 Dec 2002 20:50:38 -0600, Deepak Suthar wrote:
>I'm using Phpadmin to add these fields with these values, and it keeps
>crashing...what am I missing?
>
>-Deep
| 11 |
| E | 12 |
| E | 13 |
+++
8 rows in set (0.00 sec)
Then just use your scripting language to join the letter and number back
together. I tried mysql concat() but it makes the whole thing into a
wrong-sorted string again.
FWIW -- Doug
At 10:17 PM 12
port built-in plus all the other goodies.
Regards,
Doug
On Wed, 25 Dec 2002 09:59:02 -0800, Mohammed Fouwaaz wrote:
>I am fairly new to mysql and php3.
>
>mysql server is running ok and I created a table and inserted a few records.
>
>php3 is also working ok and I am able to r
On Fri, 27 Dec 2002 07:15:01 -0600, Paul DuBois wrote:
>At 0:43 -0800 12/27/02, tan tan wrote:
>>Hi Paul
>>I went to the site and I can't look for the page.
>>If you dont' mind to get the the exact url.
>>Thanks.
>
>Odd. Anyone else out there have trouble with that URL?
>
>http://www.kitebird.com
Chris:
I bet a dollar to a donut that you have a hardware problem. The
essential proof is in the first quoted paragraph below. Believe
your data, save your hair.
Regards,
Doug
Filter That! SQL MySQL Query
On Sat, 28 Dec 2002 07:18:07 -0500, Chris Faust wrote:
>One other test I did was
1. This is a PHP syntax question.
2. The PHP manual gives a specific example in the MySQL Functions.
$link = mysql_connect("localhost", "webuser", "webpass")
Doug
On Sun, 29 Dec 2002 20:11:14 +0200, Pikasz Gyorgy wrote:
>Hi all!!!
>Red Hat 7.
Hi:
Go look in the section where they keep the O'Reilly books and pick up
"MySQL Cookbook" by Paul DuBois ISBN 0-596-00145-2.
It is fair to say that Paul has an above average grasp of the topic.
He is often quoted on this list.
Regards,
Doug
On Wed, 08 Jan 2003 08:34:18
To paraphrase Yogi Berra: You can see an awful lot just by looking.
http://www.mysql.com/doc/en/Can_not_connect_to_server.html
Doug
-- For Happy Filters, use SQL, query
On Sat, 11 Jan 2003 12:50:29 -, alan.keith.simons wrote:
>Hi
>
>I have installed a downloaded version of mysql
It's my understanding that embedded selects are NOT allowed in MySql. Is this correct?
Example:
SELECT t1.*
FROM table1 t1
WHERE ( t1.Id IN ( SELECT t2.Id FROM table2 t2 ) )
Doug Beyer
SAS Research and Development
503-617-7103 (Portland)
[EMAIL PROTECTED]
SAS... The Power to
|
>
>Any ideas?
Yes.
See Chapter 4.3.5 of the mysql manual.
"Note that we must issue GRANT statements for both monty@localhost and
monty@"%".
hth,
Doug
>
>Thanks,
> Neil.
>
>--
>Neil Aggarwal
b='mydb';
The above is a very superficial description of the mysql Access
Privilege system. You need to read a lot more in the manual in section
4.2, "General Security Issues and the MySQL Access Privilege System."
Doug
On Thu, 16 Jan 2003 01:15:03 -0600, Addison Elli
ow would I modify this query to return all the items from Category,
Category2, Category3, Category4 and Category5 and then group them all by
similarities?
Thank you,
Doug Coning
-
Before posting, please check:
http://www
You might find something at
http://www.linuxapps.com/
Doug
On Tue, 21 Jan 2003 00:06:32 -0800, Ed Reed wrote:
>
>Does anyone have a list of manufactures of financial packages that will run with
>MySQL?
>We need to move from Intuit Quickbooks to something that can potentially
Certainly.
http://www.mysql.com/doc/en/User_Account_Management.html
On 22 Jan 2003 06:50:27 +0800, Jon Miller wrote:
>> Is there a way to check or view in mysql what permissions users have to certain
>> databases?
>--
>Jon Miller <[EMAIL PROTECTED]>
>MMT Networks Pty Ltd
---
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Doug Coning" <[EMAIL PROTECTED]>
Sent: Thursday, January 23, 2003 9:15 AM
Subject: Re: Is this possible?
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filt
hout having to use a temporary table...
Thanks,
Doug Coning
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-
You state that you searched the web and the documentation, but did you
search the MySQL manual?
4.2 General Security Issues and the MySQL Access Privilege System
http://www.mysql.com/doc/en/Privilege_system.html
4.3 MySQL User Account Management
http://www.mysql.com/doc/en/User_Account_Management
You mean like your inquiry which took 8:01:27 between the time you sent
it and when it hit my mail server?
Doug
On Thu, 23 Jan 2003 20:44:56 -0800, Jeremy Zawodny wrote:
>Is anyone else seeing it take 4-8 hours for mail to get thru this list
>recently?
>
>Jeremy
>--
>
on the surface for web-based tutorials.
Enjoy,
Doug
On Sun, 26 Jan 2003 11:00:18 -, Scott Lewis wrote:
>As you can tell - very new to Mysql.
>
>I was wondering, has anyone some links to howto or even better examples of
>databases and webpages that I can install, and see the web
Assuming you logging in from the same server on which mysqld is
running, you need a dmiller@localhost user. The "%" wildcard is valid
only for tcp connections. This is thoroughly explained in the MySQL
manual, chapter 4.3.5.
hth,
Doug
On Mon, 27 Jan 2003 15:03:35 -0500, Devin Miller
FLUSH PRIVILEGES
On 29 Jan 2003 07:05:29 +0800, Jon Miller wrote:
>When granting someone permissions are these permissions dynamic or do I
>have to reload mysql?
>Also we have a developer who stated he cannot access the database
>remotely. I've granted him privileges as follows since he works on
You need to include the (correct) Root password in mysql_connect(h,u,p)
On 29 Jan 2003 07:42:37 +0800, Jon Miller wrote:
>Warning: Access denied for user: 'root@localhost' (Using password: NO)
>in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255
>
>Warning: MySQL Connection Failed: Access denie
lity doesn't eliminate the
need to know javascript.
>Any help greatly appreciated
Your inquiry will receive more detailed help on one of the lists at
www.php.net.
Regards,
Doug
-
Before posting, please check:
http://
ing my day.
Doug
On Wed, 5 Feb 2003 15:58:21 +1300, Defryn, Guy wrote:
>
>
>I was just reading through the Mysql manual section 3.32
>And came across a sentence that started like this
>
>Animal sex can be represented in a variety of ways
>
>My mother tongue is not
1 - 100 of 191 matches
Mail list logo
