It is all disinformation to confuse Micro$oft. 8-)
On Mon, 31 Mar 2003 09:45:09 -0700, Martin Gainty wrote:
Michael et al-
I am trying to locate ONE working MySQL example for windows. Is this a myth
or is there WORKING source example out there somewhere?
Thanks,
Martin
- Original Message
Very close.
Only one table may be updated per UPDATE statement.
Doug
On Sun, 23 Mar 2003 00:52:59 -, [EMAIL PROTECTED] wrote:
Hi
I may be way off base here but - why do you reference IMPORT_USERS in your
UPDATE statement? You aren't updating any columns in that table.
Regards,
Sal
PHP Database Mailing List (http://www.php.net/)
Mostly MySQL with a smattering of other db's from time to time.
hth,
Doug
On Fri, 28 Feb 2003 13:30:40 -, Andrew wrote:
Using MySQL and PHP
PS. Do any of you knw of a forum specifically out there for PHP and MySQL?
Andrew
Hello:
Because you have a variable length column type (text) in the row, mysql
changes char() types to varchar. This behavior is discussed in the
manual in Silent Column Change Specifications under CREATE TABLE.
If the stored length of these columns is an issue, you can move the
variable
Am I the only one that equates these robot replies with spam? Most of
them are as meaningful as talking to micro$oft.
Yeah, I filter them on input and they go to trash, but silence can be
taken as consent which might be construed as endorsement. Who knows
what would come next?
My $0.02,
Doug
On Sun, 9 Feb 2003 16:24:03 -0700, Pamela Hart wrote:
My question is this: I need to input data from a .sql file into an
existing and empty database I have created.
I type this into terminal at the main command line: mysql -uUser
database_name filename.sql.
I keep getting an error message
I love it!!! 8-))
You are correct that it does sound a bit rude, even when English is
your first language and you stop to think about it. However, what the
statement means is identical to The sex of the animal can be
represented... and it is acceptable grammar.
Thanks for making my day.
Doug
See DROP DATABASE
Doug
On Wed, 5 Feb 2003 22:50:25 +0800, Calvin Lam wrote:
Hi,
I am a newbie with this and I need help with Mysql
How can I delete a database in Mysql
thanks!
-
Before posting, please check:
Steve:
On Fri, 31 Jan 2003 08:27:11 +, Steve Davies wrote:
Is it possible to mix javascript and PHP in the same script??
Certainly. Exactly as HTML and PHP are intermingled in a document.
I have a number of web based apps written in PHP/MySql and while they
are functionally pretty
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 denied
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 wrote:
I am
For decent explanations of concepts and practicalities, try
http://www.webmasterbase.com/subcats/53
and more specifically
http://www.webmasterbase.com/article/228
There are also good and more advanced tutorials at
http://www.onlamp.com/
http://www.devshed.com/
These are superficial scratches
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
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
--
Jeremy D. Zawodny | Perl,
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 scale to as
many as
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
SELECT * from mysql.tables_priv where Table_name = 'myTable';
You will probably have to log on as 'root' unless you have created
another user with the same privileges.
The mysql GRANTs system is used to control USER privileges. This means
that for a given table you can view which users can
On Wed, 15 Jan 2003 11:00:21 -0600, Neil Aggarwal wrote:
Hello:
As the root user, I created a new database and user account:
CREATE DATABASE newsletter;
GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass';
FLUSH PRIVILEGES;
I then tried to access the databse via the
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 on my pc but
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 -0500, Charles Mabbott
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.3, MySQL, PHP
I tried to connect to MySQL
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 put
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?
This is a PHP issue.
I don't recall the version when MySQL support became standard, but
PHP3 is too old to be of much use. Especially with the new
features for security introduced in PHP 4.2.0.
Your best bet is to upgrade to a current release of PHP. That way
you'll have MySQL support
MySQL doesn't accept variables for field length values.
Your query should look something like this:
CREATE TABLE `db`
(`host` VARCHAR(localhost) NOT NULL,
`db` VARCHAR(64) NOT NULL,
`user` VARCHAR(64) NOT NULL,
`select_priv` CHAR(1) NOT NULL,
`insert_priv` CHAR(1) NOT NULL,
`update_priv`
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 it.
My table:
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)
I think these articles might help you solve your problem. They don't address
javascript, but do show how to get
information to and from mysql using php and forms.
http://www.webmasterbase.com/article/627
http://phpbuilder.com/columns/laflamme20001016.php3
Regards,
Doug
On Thu, 21 Mar 2002
Odd, I think it does a very good job of helping troubleshoot:
http://www.mysql.com/doc/A/c/Access_denied.html
On Wed, 20 Mar 2002 09:30:48 -0500, alan4100 wrote:
And does not explain at all when mysql -u root -p does not work.
. Maybe there is a
different way to build my query so that it displays the full set of records.
Any suggestions?
George
- Original Message -
From: Doug Thompson [EMAIL PROTECTED]
To: George Pitcher [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 5:59 PM
The directory space in which mysqld places the data is capable of containing multiple
databases (related groups of
tables) and tables (related groupings of data) up to the physical limits of your
computer system.
The mysql database contains the tables that hold information concerning user
I've been watching this thread and wonder if not following instructions may be
contributing to the present confusion.
On Fri, 15 Mar 2002 14:38:02 +0200, Egor Egorov wrote:
Show me the output of the following:
SHOW GRANTS FOR 'username'@'hostname';
RQ output:
RQ mysql show grants for
1. If you can view blahblah;; in the password field of the user table, then the
password wasn't encoded in the
first place. That leads one to conclude the change was accomplished using UPDATE and
the field was set to
blahblah;; and not to PASSWORD('blahblah;;'). What mysql stores in the
The good news is it works from here. :o)
I guess for you that's also bad news. :o(
On Fri, 15 Mar 2002 14:57:20 -0600, Steve Suehring wrote:
Hi,
For some reason I get a 404 error when I click on 'search' in the Quick
links section at http://www.mysql.com/documentation/mysql/bychapter/.
It
The REPLACE command may be what you're asking about.
SELECT REPLACE('This is a foo','foo','foobar');
will return This is a foobar.
SELECT REPLACE(city,'Denver','Albuquerque') from foo;
In table foo, every occurrence of Denver in column city is replaced by
Albuquerque.
Regards,
Doug
On
Two things to check:
1. Ensure the mysql server is running. mysql.sock is automatically created when the
server is started.
2. If you still get the error, it may be in another subdirectory, usually
var/lib/mysql. Once you locate mysql.sock,
modify the my.cnf file to point to the correct
I would guess it's because only three records match the ANDed tests in the WHERE
clause (last 3 lines).
Isn't that what you intended?
Doug
On Wed, 13 Mar 2002 16:08:43 -, George Pitcher wrote:
Hi all,
Posted this yesterday and got no response. Trying again today.
I'm having a small
If mysql.sock doesn't exist, that is because the server is not running.
I fought the same battle as Mark and ultimately downloaded and installed the RPM for
3.23.49a from MySQL in place of
the copy that came with RH. The MySQL RPM installed and came up just like it says in
the book. Saves a
Egor:
Yesterday, I wrote and described that my fix for a single cpu, non-RAID environment
was installing a new version.
What I didn't say at the time is that the mysql.sock file was present exactly where it
was supposed to be and at
exactly the location the error message said it couldn't
Today I migrated my system to RH7.1. I had been running mysql on Mandrake 7.2 but I
wanted to use the newer versions
which require kernel 2.4.x.
I experienced exactly the same problems as you with the RPM of mysql which came with
the RH distro. I looked at
everything and then some that had
Excuse me for jumping in.
UPDATE table SET a=$a
1. I assume the double quotes in your original message are meant to highlight the
problem statement.
2. As written, you are attempting to set an integer type column to the string literal
consisting of the characters $
and a. MySQL rejects
This is very easy using mysqldump.
Instructions are found in the manual at:
http://www.mysql.com/doc/m/y/mysqldump.html
On Fri, 1 Mar 2002 18:25:19 +0100, Sigurd Stordal wrote:
I've brand new to Mysql, and for now I have one machine, a private one, with
a mysql database. No I want to move
On Thu, 28 Feb 2002 12:42:04 -, DL Neil wrote:
After a number of rounds of this conversation/developing a work-around, have we
decided that there is a
fault/bug?
I don't recall any 'official' involvement to date.
Has 'riga.riga' submitted a Bug Report to MySQL?
1. If anyone else can
On Thu, 28 Feb 2002 15:32:24 +0100, Roger Baklund wrote:
As far as I can tell, there are at least two bugs.
One bug is already known, it is the rounding error that applies to some
platforms, depending on the underlaying C library being used:
win2k, 3.23.30-gamma:
mysql select round(1.5);
On Thu, 28 Feb 2002 15:49:10 +0100, Roger Baklund wrote:
1. If anyone else can produce the declining decimal resolution
that Roger encountered, then there may be something to
be found in the mysql code or the gcc libraries. Until then, it
is a vagary of Roger's installation. I resist the
On Thu, 28 Feb 2002 16:53:59 -, DL Neil wrote:
BTW: this apparent accreditation (below) is incorrect/an accident of editing? I
didn't say this. It was Doug (he
says pointing an accusative finger). Doug whilst I'm (appearing to) round on you,
contrary to your comment about
lack of evidence,
You are restricted to SELECT, INSERT, and UPDATE privileges on columns. ALL won't
work.
Regards,
Doug
On Thu, 28 Feb 2002 11:31:15 -0600, Kenneth Hylton wrote:
Howdy -
I have looked online and also in MySQL by Paul DuBois, plus the O'Reilly
book and can't find an example of how to do
Hi Don:
On Thu, 28 Feb 2002 22:38:04 -, DL Neil wrote:
I know it's getting late, so perhaps I'm not following you sufficiently
closely. What does inherited mean?
Inherited referred to using the float(10,4) formatting of the numbers field in
this case.
Also how do you define worked.
On Wed, 27 Feb 2002 13:53:15 +0100, Roger Baklund wrote:
* Doug Thompson
I found using variables to work as expected with 3.23.43 and Win98.
I was unable to duplicate your changing outputs.
I was using a 3.23.30-gamma win2k.
mysql select @a:=digits,number,round(number,@a) from testme
On Wed, 27 Feb 2002 22:10:44 +0100, Roger Baklund wrote:
One obvious workaround is to avoid floating point numbers... or in mysql
terms, use the decimal/numeric data type instead of float/double... but that
does not solve the problem in this case, I guess floating point is used
internally in the
Roger:
I found using variables to work as expected with 3.23.43 and Win98.
I was unable to duplicate your changing outputs.
mysql select @a:=digits,number,round(number,@a) from testme;
++--+--+
| @a:=digits | number | round(number,@a) |
Yes. You want to use mysqldump.
http://www.mysql.com/doc/m/y/mysqldump.html
On Sun, 24 Feb 2002 22:24:39 -0500, Pax wrote:
Is there an easy way to create SQL script from existing database and use
it to create a new database?
Tks
Pax
One way is to include it in your mysql start command:
mysql -u user -ppassword scriptfilename
You may have to include the path with the scriptfilename.
regards,
det
On Sat, 23 Feb 2002 13:21:27 +0530, Chetan Lavti wrote:
hi,
I have written a script for database creation and table creation.
This matter was addressed this morning by Sasha Pachev in 3.23.49 Linux binary issues
To paraphrase Yogi Berra, you can learn an awful lot just by reading; in this case
postings to the list in general
from the development team.
det
On Sat, 23 Feb 2002 08:22:15 -0500, S. William Schulz
You can SHOW GRANTS FOR foo which gives you information about user 'foo'.
To show info about everyone, use SELECT * FROM user;
hth
Doug
On Sat, 16 Feb 2002 13:59:02 +0100, Søren Neigaard wrote:
I'm a total newbie to MySQL, so I'm reading the documentation right
now. In General Security I read
All morning I have been flooded by repeats of posts going back as far as February 2.
There have been several hundred
total messages.
Can't anyone fix this problem?
DET
(sql,query,table)
-
Before posting, please check:
The following just worked in a test case for me:
...user@test-test.com...
On Thu, 7 Feb 2002 06:29:59 -0500, Paul Faber wrote:
Not sure if thius is supposed to go here but my version of MySQL
mysql status;
--
mysql Ver 11.15 Distrib 3.23.45, for pc-linux-gnu (i686)
the GRANT
This topic is covered quite well in the manual.
http://www.mysql.com/doc/U/P/UPDATE.html
On Sun, 3 Feb 2002 08:58:33 -0800 (PST), Nick McBride wrote:
How would I go about editing a certain record in a
MySQL database; Items? I want to be able to change a
value that was already inserted into
Rants: 2 Spam: 1
Looks like you're ahead on this one.
On Fri, 25 Jan 2002 15:29:04 +0100, Marjolein Katsma wrote:
And this nitwit ... snip snip snip
Life is tough. Life is tougher when you're stupid. - John Wayne
(database, sql, bat whiskers)
You did not properly invoke the PASSWORD() function:
UPDATE user SET password=PASSWORD('somepass') WHERE user='root';
On Mon, 21 Jan 2002 11:04:57 +0100, Aleksandar Bradaric wrote:
Hi,
I tried to set the root password in the mysql db;
update user set Password='password' where User='root';
Perhaps you read the wrong part(s) of the manual:
http://www.mysql.com/doc/R/e/Reserved_words.html
On Sun, 20 Jan 2002 12:18:45 -0800 (PST), Dominique Plante wrote:
I hope you can answer the following question. I am
wondering how to create a table with a column named
key. I have RTFMed and
Matt:
I don't remember you saying what machine you're running mysql on.
Try adding another copy of the same user only @localhost. My win32 installation
requires that for a dos box. The hosting
service I use doesn't seem to care as it almost seems to ignore the Host column.
GRANT ALL
You need to create a user with login privileges from any location.
GRANT ALL PRIVILEGES ON *.* TO foo@% IDENTIFIED BY 'apassword' WITH
GRANT OPTION;
AND, as is appended to each post,
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Mon, 7 Jan 2002 00:03:20 +0100, Tue Hellstern wrote:
I cant connect to a MySql Database form a Windows PC, I get Host ... is
not allowed to connect to this MySQL server and in the MySql manual I
found the following solution but I dont know how to do it. I am an
novice in MySql.
If anyone
Put double quotes around % so that foo@%
On Sun, 6 Jan 2002 18:31:00 -0500, Christian J Hedemark wrote:
mysql grant all privileges on *.* to foo@% identified by 'foobar' with
grant option;
ERROR 1064: You have an error in your SQL syntax near '% identified by
'foobar' with grant option' at line
It works the way you want with this data when your query is written:
SELECT nev FROM hosoktest WHERE nev = ('pokember' OR 'Pokember');
Regards,
Doug
On Thu, 27 Dec 2001 01:33:57 +0100, Barnabas BONA wrote:
If I execute the following select:
SELECT nev FROM hosoktest WHERE
If you want to use PHP, here's a nifty utility that posts your query and displays the
results.
Give me back my MySQL Command Line!
http://www.webmasterbase.com/article.php/627
Doug
On Mon, 17 Dec 2001 14:27:11 -0800 (PST), John Kurkiewicz Jr. wrote:
I cannot figure out how to parse SELECT
This should help:
A.4.2 How to Reset a Forgotten Password
http://www.mysql.com/doc/R/e/Resetting_permissions.html
Good luck.
Doug
On Sun, 16 Dec 2001 22:43:39 -0500, David VanHorn wrote:
I'm root on a small server.
My co-sysop has managed to lock us out of mysql.
I can't get in with -u
Yes.
1. Read the manual sections concerning setting up new accounts with special emphasis
on passwords.
2. When you thoroughly understand those matters, take the issue to the system
administrator and/or management.
hth,
Doug
Only two things are infinite, the universe and human stupidity,
70 matches
Mail list logo