Let me preface this by saying I am not a MySQL guru myself, but more of a
general sys admin... !
One of our users is trying to execute the LOAD DATA INFILE command (using
PHP to talk to MySQL). It is failing for some reason... Everything I believe
is set properly, i.e:
- the user has the file
Hi,
I'm a teacher in germany and searching for a database, wich supports
foreign-keys and is supported from OOo. (Well I found the HSQLD-Database
(Hermann Kienlein was helping) which is working, but with MySQL I could do
all my jobs in schools with only _one_ database).
Till now, I thought
Hi all,
is there a way to find out which host I am connected
from?
My CGI script checks privileges of users based on host
names they came from. But their hosts some times are
detected as IP. E.g. when the script asks:
SHOW GRANTS FOR 'user'@'127.0.0.1'
Mysql replies that there is no such
Has anyone seen something like this before:
We have an Access database (about 9 megs in size) with linked tables in
it. The machine DSN shows that the information for the connection is
correct. But when you try to open the table in Access, a dialog pops up
to connect to the mysql server and
Jeff,
I am affraid your question has nothing to do with MySQL internals. It is all about
MySQL usage.
Stout, Jeff wrote:
I am using MySQL 4.0.15 on Win2K (not by choice, vendor chose this platform)
I user the Database to store user information to Allow RADIUS to authenticate
users against the
Hi All !
I have allready installed the MySql on my server. How do I start the Mysql ?
best regards,
Eduardo F. Melo
PRO-IT Informatic
_
MSN Messenger: converse com os seus amigos online.
http://messenger.msn.com.br
--
MySQL
127.0.0.1 is always localhost, perhaps you could make this change in
your scripts
- hcir
use MySQL
is there a way to find out which host I am connected
from?
My CGI script checks privileges of users based on host
names they came from. But their hosts some times are
detected as IP. E.g. when
The only thing I would suggest is to look in the mysqllog and look at the
command that is specifically being issued, and then try it from the mysql
command line interface, and see if it works there, it should give you a good
enough reason if it doesn't, and if it does, it more than likely is some
Hallo,
Is there any UTF8 collation which groups national simbols by it's base
symbol.. For example:
if in case-insensitive a = A, is there any solution for A = A (a-umlaut) or
A ??
it would have sense in search'ing national text's, for example selecting all
people in phone book which first
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dieter Kroemer wrote:
Hi,
I'm a teacher in germany and searching for a database, wich supports
foreign-keys and is supported from OOo. (Well I found the HSQLD-Database
(Hermann Kienlein was helping) which is working, but with MySQL I
could do
is there a way to find out which host I am connected
from?
Does the solution have to be a function called within mySQL or would you
accept a function called by PHP or Perl?
-Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
-20030921-bin.jar to the secrity-entrance.
I created a new database with a table in the inno db-format, but I can't get
the foreign-key-gui :-((
(The gui only appears, if OOo knows the database supports the foreign-keys. I
know it can appears, because with hsqldb it works.)
Btw. do you know somebody
On Fri, Sep 19, 2003 at 10:20:34PM -0700, Hsiu-Hui Tseng wrote:
These 2 are the queries
explain select * from user where user_id = 123;
- where user_id is the primary key of user table with 2178576 rows.
Is there a user with user_id 123?
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux
I have my schema set so that a field in a table has a default value of 16.
I also have a script that initializes the database, but I don't want to
delete the record since I want the other fields' data preserved. Is there a
way to find out what the default schema value is so that I can issue an
I have several fields in which I will be strong text. Various categories,
and for each category, its related subcategories. Each subcategory then
contains various items.
My question is, for performance, would it be better to assign each
category/subcategory pair a unique ID number and then
Well you could:
(assuming an installation in /usr/local/mysql)
# /usr/local/mysql/bin/mysqld --user=mysql /usr/local/mysql/daemonlog
/usr/local/mysql/daemonerrorlog
But you should probably consult the manual under the installation for an
explanation of exactly what the above does.
-Dan
On
Im running mysql 4.0.15 on mac osx and am having
trouble while doing performance/load testing. On
startup I get the following error message in the error
log:
Warning: setrlimit returned ok, but didn't change
limits. Max open files is 12288 (request: 25010)
Im not sure where this request is
In order to avoid errors it is better to call this
within mysql. I tried already SELECT USER(). It seems
to work for me.
--- Dan Anderson [EMAIL PROTECTED] wrote:
is there a way to find out which host I am
connected
from?
Does the solution have to be a function called
within mySQL or
On 9/21/03 9:43 AM, Eduardo Melo [EMAIL PROTECTED] wrote:
I have allready installed the MySql on my server. How do I start the Mysql ?
best regards,
Eduardo F. Melo
PRO-IT Informatic
on osx...
If you are using Explorer 5.2 or better, or Netscape 7.1 or thereabouts
Hi, I have a strange problem with priviledges.
They just stop working. The tables have the data in them. But they don't work.
So I do another GRANT
And then they work fine, until the next day (not sure about the timing) when
they have to be GRANT'ed all over again.
There doesn't seem to
G'Evening,
Im extremely new to MySQL. Im sitting here using a self teach book to try to guide my
way through it. Anyways, the book is discussing adding users and setting priveledges.
Now the book is vague on how to do so, but I believe I use the bin/mysql.exe file (Im
on windows obviously).
21 matches
Mail list logo