,
Markus
--
Markus Lervik
Linux-administrator
Vaasa City Library - Regional Library
+358-6-325 3589 / +358-40-832 6709
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
''clients'@'%'
IDENTIFIED
BY '123'' at line 1
GRANT ALL PRIVILEGES ON newstesting.* TO 'clients'@'%' IDENTIFIED BY '123';
You're missing the 'TO'.
Cheers,
Markus
--
Markus Lervik
Linux-administrator
Vaasa City Library - Regional Library, Finland
[EMAIL PROTECTED]
+358-6-325 3589/+358-40-832 6709
,
Markus
--
Markus Lervik
Linux-administrator
Vaasa City Library - Regional Library, Finland
[EMAIL PROTECTED]
+358-6-325 3589/+358-40-832 6709
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
table './koneet/#sql-355_4.frm' (errno: 150)
*sigh*
Cheers,
Markus
--
Markus Lervik
Linux-administrator
Vaasa City Library - Regional Library, Finland
[EMAIL PROTECTED]
+358-6-325 3589/+358-40-832 6709
-
Before posting, please
On Monday 10 Jun 2002 11:44 am, Markus Lervik wrote:
mysql show create table ip_name_tbl\G
*** 1. row ***
Table: ip_name_tbl
Create Table: CREATE TABLE `ip_name_tbl` (
[snip]
`name_id` int(11) NOT NULL default '0',
[snip]
mysql show
to the configure script.
Also, does anyone know the command to list all the db's? thanks.
SHOW DATABASES;
Cheers,
Markus
--
Markus Lervik
Linux-administrator
Vaasa City Library - Regional Library, Finland
[EMAIL PROTECTED]
+358-6-325 3589/+358-40-832 6709
.
Rob's idea is of course a solution, but that sort of brings me back to
my original question : is there a -SIMPLE- way? ; )
INSERT IGNORE wouldn't, if I understood the manual correctly,
help me here, since the other rows in the table aren't UNIQUE, no?
Cheers,
Markus
--
Markus Lervik
Linux
(filter fodder: sql, query)
Hello group!
Quick question:
Is there a simple way to do something like INSERT IF NOT EXISTS,
other than first doing a SELECT and checking if it returns any rows?
If not, that would be pretty high up on my whish-list : )
Cheers,
Markus
--
Markus Lervik
Linux
danger of losing data?
Cheers,
Markus
--
Markus Lervik
Linux-administrator
Vaasa City Library - Regional Library
+358-6-325 3589 / +358-40-832 6709
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
anything I can think about, but nada.
I'd assume that if it's at all possible it'd be some join-trickery,
but I just can't figure it out.
(yes, I know it'd be easier db-wise to have a 'paid ENUM(y,n)'
-field, but this is just a curiosity. I want to know. ;)
Cheers,
Markus
--
Markus Lervik
that coldfusion would open the
connection when using a cfquery-tag.
Any help is greatly appreciated.
Cheers,
Markus, tearing big lumps of hair out.
--
Markus Lervik
Linux-administrator with a kungfoo grip
Vaasa City Library - Regional Library
[EMAIL PROTECTED]
+358-6-325 3589 / +358-40-832 6709
:20:41
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm
' (errno: 13).
Did you read the README file?
[mle@hal9000 rip]$ perror 13
Error code 13: Permission denied
chown -R mysql.mysql mysql/ ought to sort it out.
--
Markus Lervik
Linux-administrator with a kungfoo grip
--
Markus Lervik
Linux-administrator with a kungfoo grip
Vaasa City Library - Regional Library
[EMAIL PROTECTED]
+358-6-325 3589 / +358-40-832 6709
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
.)
c) Unsubscribe from the list if it bothers you that much. We've (unfortunately) seen
at least one
individual unsubscribing, not too long ago, because of the spam.
Cheers,
Markus
--
Markus Lervik
Linux-administrator with a kungfoo grip
Vaasa City Library - Regional Library
[EMAIL PROTECTED
stated before, in our request for offers on the database (whatever
the correct term might be), we specifically said that we wanted MySQL
or PostgreSQL, which makes even more stupid to offer us MS SQL,
because they (ought to) know that we won't take them in that case.
Cheers,
Markus
--
Markus
about
identical on the two machines.
Ideas?
Cheers,
Markus
--
Markus Lervik
Linux-administrator with a kungfoo grip
Vaasa City Library - Regional Library
[EMAIL PROTECTED]
+358-6-325 3589 / +358-40-832 6709
-
Before posting, please
On Tuesday 22 January 2002 14:32, Markus Lervik wrote:
Hi!
For some strange reason MySQL doesn't listen for incoming
connections on port 3306. I have four servers, two of which are
4.0.1 and two are 3.23.47. I can connect between three of them freely,
but one, shodan (yes. *g*) doesn't
.
Cheers,
Markus
--
Markus Lervik
Linux-administrator with a kungfoo grip
Vaasa City Library - Regional Library
[EMAIL PROTECTED]
+358-6-325 3589 / +358-40-832 6709
-
Before posting, please check:
http://www.mysql.com/manual.php
--
Markus Lervik
Linux-administrator with a kungfoo grip
Vaasa City Library - Regional Library
[EMAIL PROTECTED]
+358-6-325 3589 / +358-40-832 6709
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Forgot to CC to the list. Here it goes, in case anyone else has these
problems:
-- Forwarded Message --
Subject: Re: compiling and/or running 64-bit MySQL on Solaris 8/sparc?
Date: Fri, 18 Jan 2002 15:06:57 +0200
From: Markus Lervik [EMAIL PROTECTED]
To: Hatton Steven [EMAIL
euro. Now, what I want to know
is, how easy is it to port a (fairly complicated) database from MS SQL to
MySQL? It can't be work worth 18 000 euro, now can it?
Cheers,
Markus
--
Markus Lervik
Linux-administrator with a kungfoo grip
Vaasa City Library - Regional Library
[EMAIL PROTECTED]
+358-6
On Friday 18 January 2002 15:58, you wrote:
On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote:
We've requested a database from different companies, and
specifically said we wanted MySQL or PostgreSQL because of the open
source angle and we're a library.
One company
the records by hand.
I have gotten the names of the magazines into a table with an
auto_incremented primary id field, but how could I get all the
same names away from both tables and only leave unique names?
--
Markus Lervik
Linux administrator with a kungfoo grip
Vasa City Library - Regional Library
, and it turned out to be an escaping inferno.
Store the 15 screen using '15\\\ screen' in PHP, and it should work.
Cheers,
Markus
--
Markus Lervik
Linux administrator with a kungfoo grip
Vasa City Library - Regional Library
-
Before
out
the FORM tag. I really wouldn't want to use FORM ACTION=blah.php,
as I have this FORM tag in a nifty function that is called from a bunch
of scripts.
Cheers,
Markus
--
Markus Lervik
Linux administrator with a kungfoo grip
Vasa City Library - Public Library
,
Markus
--
Markus Lervik
Linux administrator with a kungfoo grip
Vasa City Library - Public Library
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
--
Markus Lervik
Linux administrator with a kungfoo grip
Vasa City Library - Regional Library
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
), that php closes the
connection every time I use a submit-button and it reloads the page.
Technically speaking, that would be ending a script, right?
-Markus
--
Markus Lervik
Linux administrator with a kungfoo grip
Vasa City Library - Public Library
I'll have to check the timeout parameter.
Thanks a million to everyone who replied, but me thinks it's time
for me to move this discussion to the php-db mailing list, as it is
becoming grossly off-topic.
-Markus
--
Markus Lervik
Linux administrator with a kungfoo grip
Vasa City Library - Public
29 matches
Mail list logo