I get:
mysql -p database /Users/me/Desktop/database.sql;
ERROR 1064: 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 '-p database /Users/me/Desktop/database.sql' at line 1
Thanks,
TR
On Aug 22, 2004, at
Well, a friend told me that:
register_globals is off by default in recent versions of PHP. You need
to
refer to GET/POST variables using the $_GET or $_POST associative
arrays,
or turn register_globals on in your php.ini.
I enabled register_globals, it was Off.
However the following (see
I hope someone might be willing to help out.
I'm trying [still] to learn MySQL and php - to create some simply web
based database.
I have installed quite a few php/MySQL web database apps from books,
however, none of them will get data entered into my database.
When I create the database
Here is my connection script (conn_inc.php):
?php
# conn_inc.php
$connection=mysql_pconnect(localhost,mysuperusername,mypassword);
if (!$connection) {
echo Could not connect to MySQL server!;
exit;
}
$db=mysql_select_db(test_gotcha,$connection);
if (!$db) {
echo Could not change into the
Adding this file (g_common_func.php). This is 'included' by the web
form file's code along with the connection script), I thought I should
include all referenced files and forgot this one:
?php
# g_common_func.php
# common functions to gotcha application
# display header information
function
everything you need to know and do is here:
http://www.entropy.ch/software/macosx/mysql/
On Tuesday, July 1, 2003, at 04:30 PM, Werner van Mook wrote:
Hi all,
I'm new to this list so forgive me if I tear open old wounds..;-)
I installed MySQL 4.0.13 on my mac with OS X 10.2.6
I followed the
1 mi. = 1.609 Km.
;-)
On Sunday, June 29, 2003, at 10:37 PM, Rohan Hawthorne wrote:
We work in a largely distributed environment, with servers in the main
server room being thousands of kilometers (that's about 3/4 of a mile)
from clients.
We are hoping to set up a replication system so that
I'm writing here in hopes of finding someone who uses this and might be
able to help me.
I am dealing with a recordset who's query is thus:
SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
make, propID, addressIP, OS FROM people, make, models, machines
WHERE
On Friday, June 27, 2003, at 02:14 AM, James Moe wrote:
On Fri, 27 Jun 2003 01:44:53 -0400, [EMAIL PROTECTED] wrote:
umm... how do I specify which one? (this sounds really slow-poke
to me, sorry.)
Use either people.peopleID = some_specific_ID or models.modelID =
some_specific_ID.
I'm more
Ok, I trying to get this example... what is table1 t1, table2 t2,
table3 t3, table4 t4, I mean, what does the t1, t2, t3, t4 represent?
If you say, table 1, table 2, etc well, I assume that, but isn't
that there already?
Let me, or may I, give ask again with my visual? Here are my tables
Actually, denormalizing aside, are multiple Joins or statements like...
SELECT lastName, location, model, make
FROM people, make, models, machines
WHERE people.peopleID = machines.peopleID AND make.makeID =
models.makeID AND models.modelID = machines.modelID
...common?
I guess that's actually
If the ID field is *not in your text file, why not take it out of the
CREATE statement and add it afterwards?
Ted
On Thursday, June 26, 2003, at 10:46 PM, Scott Haneda wrote:
I have this
CREATE TABLE `dictionary` (
`id` int(11) NOT NULL auto_increment,
`word` text NOT NULL,
`def` text
Thanks everybody for all you great help!
Ok, this statement will select all of my records nicely:
SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
make, propID, addressIP, OS FROM people, make, models, machines
WHERE people.peopleID = machines.peopleID AND make.makeID =
Where can I learn --someplace really for dummies?-- about creating
filters and limits?
Thanks,
Ted
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ok, this is good:
SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
make, propID, addressIP, OS FROM people, make, models, machines
WHERE people.peopleID = machines.peopleID AND make.makeID =
models.makeID AND models.modelID = machines.modelID LIMIT 1;
umm... how do I
This:
SELECT * FROM machines INNER JOIN people ON
machines.machinesID=people.peopleID;
Is not producing the same results as this:
SELECT lastname, model FROM people, machines WHERE machines.peopleID =
people.peopleID;
Can someone please tell why, what's wrong?
(What happens is that the wrong
Ok, should be this:
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.peopleID;
Ted
This:
SELECT * FROM machines INNER JOIN people ON
machines.machinesID=people.peopleID;
Is not producing the same results as this:
SELECT lastname, model FROM people, machines WHERE
in wrote:
Hi tlr7425,
Besides what I said in my last e-mail I completely overlooked that
SELECT * FROM machines INNER JOIN people ON
machines.machinesID=people.peopleID;
should be
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.pe
I want to insert a value into a (one) field of all records in a table.
I tried:
INSERT INTO models (makeID) Values (1)
But that adds a new record, with the value filled in. I don't want a
new record, I want that value inserted into all the records of table
'models' 'makeID' field.
Thanks
I grown my db to 4 tables 8). I'm going to ask this plainly in hopes
that my syntax in ok:
I know how to SELECT * from 2 related tables and get all the records
listed in the resultset.
(Either using INNER JOIN or WHERE.) Now... and I have been looking
some books!
How do get a resultset of
On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
TR --
...and then [EMAIL PROTECTED] said...
%
% I wish to attempt to clarify one of my earlier questions:
That's always helpful :-)
%
% Most things I've read say to establish a mysql
Sorry all, but I'm trying!
What is the fix for the following behavior (besides shoot the user ;)
---
Welcome to Darwin!
[greenroom:~] ted% safe_mysqld --user=ted
[1] 551
[greenroom:~] ted% touch: /var/mysql/greenroom.err: Permission denied
chown: /var/mysql/greenroom.err: Operation not permitted
Ok, got the Apple OX XS 10.2 MySQL install happening.
The ENTIRE reason I have had s many problems getting going with the
Apple installed MySQL (Mac OS XS 10.2) is because:
The MySQL Manager (/Applications/Utilities) will run the initial
'mysql_install_db' script, it may not start mysqld
On Sunday, December 15, 2002, at 10:03 PM, David T-G wrote:
% ---
% Does anyone know what NetInfo Manager means when it shows a username
% (mysql) whose passwd is * (an asterisk)? And how I might
incorporate
% that user into... whatever I need it for? :)
No idea here; sorry. Well, some
how exactly do I change the Root user's password for mysql?
like this? :
mysqladmin -u root -p'newpasswd' ? (without a space between -p and
'newpasswd' ?)
and, if that is correct, I guess I'd then be presented with a prompt
for the old passwd, right?
Then, the new one would take effect?
Well, I think I ALMOST have figured out how to get the Apple installed
MySQL running on Mac OS X Server 10.2 (not an XServe). I have it
running but still have some issues:
(Apple installs the mysql in /usr/share as opposed to /usr/local... as
far as I can tell.)
I am having trouble with 2
I wish to attempt to clarify one of my earlier questions:
Most things I've read say to establish a mysql user -I take it this
is to run the daemon(mysqld?) under?
Is the above user one that will be created in the users table of the
mysql db? What mysql privileges does such a user need?
Also,
Is MySQL running?
Use Process Viewer to see if there is an entry for mysqld.
If not, I would ask if you issued the install_db command and then
started mysql.
Ted
On Monday, September 30, 2002, at 06:03 PM, Palash Mohanlal Kasodhan
wrote:
Hi everyone,
I am just starting to
on 8/4/02 3:13 AM, Hussein Morsy, typed:
how can i make MySQL show only what db are available to the user?
i.e., when a user logs in from a terminal application and types:
'show databases;'
mysqld --safe-show-database
or in my.cnf:
safe-show-database
With this option, the SHOW
how can i make MySQL show only what db are available to the user?
i.e., when a user logs in from a terminal application and types:
'show databases;'
they only are shown the db(s) they have access to.
?
Thanks
-
Before
how can i make MySQL show only what db are available to the user?
i.e., when a user logs in from a terminal application and types:
'show databases;'
they only are shown the db(s) they have access to.
?
Thanks
-
Before
i've read up and am able to add users with encrypted passwords.
what i want to do is restrict a user to a database.
in the mysql db there is the users table and the db table. i understand
that permissions in the users table override those of the db table.
so what i do is this:
1) create a
Sorry, I know nothing about it so I'm asking... (wasn't long ago I could get
MySQL installed and running. ;-)
I'm using Mac OS X (Server).
I installed MySQL... if ODBC is not included, does anyone know where or how
I get it for OS X and MySQL?
(I've read the MyODBC site but it doesn't seem to
on 7/14/02 3:29 PM, William Bradley, typed:
mysql USE mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql
use mysql;
:)
-
Before posting, please check:
http://www.mysql.com/manual.php
I've read the Adding New Users Section and the initial and post setup
section of the manual, but I still need some clarification:
After an install and a working MySQL I see it like this (Mac OS XS):
there are 3 users:
mysql - created manually after installing MySQL and has a password
root - a
Can anyone translate this for me, please? TIA
Welcome to Darwin!
[zbase:~] lloyd% /usr/share/mysql/mysql.server start
[zbase:~] lloyd% touch: /Users/mysql/Documents/dbs/zbase.err: Permission
denied
chown: /Users/mysql/Documents/dbs/mbase.err: Permission denied
Starting mysqld daemon with
Thank you, I hope this is the right place to be asking these questions. If
there is a more newbie place please let me know. Here's more output I
need help with, I think it's self-explanatory except that I don't how to
rectify it. The following is a continuation my original message and a
reply.
though not for your OS, I'd look for clues here:
http://www.entropy.ch/software/macosx/
Ll
on 7/13/02 11:16 PM, Haany Boyke, typed:
Hi,
i am just installing the new mysql 3.23.51 for my
linux 7.3.
The problem is after unzipping the tar.gz file and
running the mysql_install_db (which runs
Does anyone know if these instructions actually work?
(they didn't for me)
http://cerebus.sandiego.edu/~jerry/UnixTips/mysql.html
I'd like to fix them up so I and others never have to seek this out again,
tall order?
Who can help me?
after I followed these the server didn't start.
I had to use
I've been scowering (sp?) the docs but I can't get past:
mysql use mysql;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql
This happens under any condition where access is needed.
It is after I have done mysql_install_db and chown and there is a user
mysql.
It doesn't
[localhost:~] ll% ps ax | grep mysqld
349 ?? S 0:00.04 sh ./bin/safe_mysqld
385 ?? S 0:00.08 /usr/local/mysql-3.23.51/bin/mysqld
10102 std R+ 0:00.00 grep mysqld
[localhost:~] ll%
Are these ?? supposed to be there, what do they mean?
Maybe this is indicative of my problem.
Hi,
I hope I'm at the right list!
I'm trying to start mysql -I have installed the db.
Now I'm getting the following:
[localhost:~] lloyd% sudo safe_mysqld --user=root
[1] 630
[localhost:~] lloyd% Starting mysqld daemon with databases from
/usr/local/mysql/data
020623 20:25:20 mysqld ended
oops, Mac OS X.
Lloyd
on 6/23/02 10:16 PM, Danny, typed:
Hello,
What version of UNIX are you running?
Solaris, Linux, FreeBSD, BSDI?
You can find that out my typing in uname -a
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 24,
Does anyone know to accomplish having 'mysqld' startup at system boot on Mac
OS X 10.1.3?
(Mark Liyanage's startup item doesn't work for me, or I'm not using it
correctly.)
Thanks in Advance,
Ted Rogers
-
Before posting,
At 8:15 PM -0700 2/25/01, Geoff Coffey wrote:
I just installed mysql 3.23 and then ran a script to create a database I had
previously been using in an older version. I have a couple questions.
First, how can I make a drop database statement not fail if the database
doesn't exist. A book I was
but Rolf.. if i can create wouldn't that indicate permission to drop also?
thanx
At 10:01 AM +0800 2/26/01, Rolf Hopkins wrote:
Suggestion: Check file permissions.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 25, 2001 12:33
Subject: can
i'm newbie.
how come i can create but cannot drop? (errno: 21)
i am root.
mysqladmin asks if i am sure... i say 'yes' and i get the same (can't
rmdir. errno: 21)
TIA
-
Before posting, please check:
can you please stop sending attachments through the list?
At 11:24 AM +0100 2/13/01, Irmund Thum wrote:
Rolf Hopkins schrieb:
"^M"??? You sure it is that? Anyway, it is most likely to do with carriage
returns. Windows uses CR and LF to indicate a new line, while Linux and
Macs only use
where i live this is illegal.
i hope these jerks don't have my email address.
can you do anything about this TEnon?
At 11:14 PM -0500 2/1/01, [EMAIL PROTECTED] wrote:
New Concept in Gifting!
Join A Team Of 6 And 7 Figure Earners
The sole purpose of this Activity is to enable us to bless more
anyone know any ER Design tools for Macintosh?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
i too am interested, especially for the Mac.
pleasepleasepleaseplease
At 5:14 PM -0800 1/31/01, David Wilde wrote:
Has anyone ever been able to get ER/Studio to work with MySQL? Are there
any other database design tools such as ER/Studio that support MySQL
directly? Is this a project for
from the MySQL site is MySQLGUI.
will this run on OS X pb?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
and dumb too!
if(?) there is no app to launch, i.e., no GUI (Mac OS Xpb) -how do i
manipulate MySQL?
if you say "RTFM" -where is that? or a site perhaps?
thank you.
(seems kind of broad for a list archive search.)
p.s. i know there are front-end GUIs available, which do you folks
recommend?
can one 'get in' and control MySQL through OS X pb's Terminal app?
(various Unix shells.)
i think i need a GUI to start though, don't you?
At 11:48 AM -0700 1/28/01, Andrei Cojocaru wrote:
there is the mysql command-line client, it's under bin under the
mysql
if your going to view it with a browser why not include the browser
on the CD? and set the home to the first page?
At 10:02 AM +0100 1/25/01, Bernd Kulawik wrote:
Good morning,
we want to create a bibliographical database with ca. 500.000 entries and a
very simple structure (3 tables) to
is this the proper comparison:
MySQL and Cold Fusion Server (not CF Studio)?
i just started a database class (relational/ODBC) -they will of
course, eventually, use CF and Access... only a little -it's a
general class.
i, of course:), wish to resist those!
i run OS X pb.
one kindly friend was
56 matches
Mail list logo