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;'
mysqld --safe-show-database
or in my.cnf:
safe-show-database
With this option, the SHOW DATABASES command returns only those
databases for
I thought I got this through the list, but it doesn't show up in the
search, and I didn't get any responses...
-- Forwarded message --
Date: Wed, 31 Jul 2002 23:14:13 -0400 (EDT)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: SIGPROF problem in FreeBSD 4.6
This almost
Is it possible to reload changes of my.cnf without restarting the
Server ?
The reason is, that i want to toggle the log-file output of mysqld.
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the
if you have downloaded the src of mysql and installed it you can
find the mysql benchmark in your /usr/local/sql-bench
Else you also have downloads seperately on the mysql site for only
the benchmark (in rpm and others).
Grtz.
Luuk
On 4 Aug 2002, at 1:58, savaidis wrote:
Is there any
Can someone give a solution for the following error-message when
runing make?
llibmysql.c: In function `mysql_real_connect':
libmysql.c:1324: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer
type
libmysql.c:1324: too few arguments to function `gethostbyname_r'
Hi,
I want to try to automate a phonebook list import process into MySQL
database. The phonebook was originally created with MS Access and
exported into a text file. I upload that text file onto my server and I
proceed with the following import process.
Using Telnet I type:
# ./mysql -u
Hi!
I've experienced a strange problem while making mysql-3.23.51:
The following command is issued:
g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti
-rdynamic -o .libs/mysqlbinlog mysqlbinlog.o
../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt
-lnsl -lm
On Sat, Aug 03, 2002 at 11:59:56PM -0400, [EMAIL PROTECTED] wrote:
Symptoms:
mysqld locks itself in a tight loop, consuming all available CPU cycles.
a simple kill sometimes kills the daemon, other times a -9 is required.
While in this state, any access to the daemon stops - mysql queries
On Sun, Aug 04, 2002 at 11:45:27AM +0200, Hussein Morsy wrote:
Is it possible to reload changes of my.cnf without restarting the
Server ?
The reason is, that i want to toggle the log-file output of mysqld.
Some changes are going into MySQL 4.0.3 to allow many server settings to
be changed
Jeremy Zawodny wrote:
On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote:
The gentleman on PHPBuilder (http://www.phpbuilder.com/columns/tim2705.php3)
(again, I acknowledge this is an old article) says flat out that MySQL tends to die
under high load. Also, when I say high
At 0:53 +0300 8/4/02, Martin Tsachev wrote:
mysqldump invoked with --xml/-X omits the backslash from closing tags for
columns of type: enum, varchar and date.
Fixed in 3.23.51. There's also a bugfix for mysqldump -X for another problem
in 3.23.50.
Martin Tsachev
Web developer
Our application (Win32) gives MySQL a real pounding, but we have never had
it die on a server with proper resources.
On Win32 systems, you can not underestimate the importance of virtual memory
(swap file) and drive defragmentation. On Win32 systems with SCSI RAID, we
set the virtual memory to
How can I set up MySQL error logging? Is there any PHP MySQL error log
parsers?
Thank You
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hello,
I also plan to use two servers such that each is a master for the other.
A - B
B - A
Unless you tell me otherwise, the log-server-updates option
will not be used.
Seems to work in a small test I've conducted.
In fact this setup will be used for reasons of high availability.
(rather
Dear All,
We are running MySQL on a Cobalt Raq 4.
After a while the socket 'mysql.sock' will not work anymore and access to
our database is not possible.
The error MySQL reported is:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
The mysql deamon is still
Please !
I thought I had this working, but it seems unfortunately not !!!
I'm trying to list events for each month and my select query is as follows
SELECT DISTINCT t_city_name,t_city_id_city FROM
t_city,t_zipcodecity,t_location,t_event WHERE (t_city_id_city =
t_zipcodecity_id_city)
I first posted this on the php-db list, but am not getting the proper
results yet, so I am copying here, hopefully someone can help me figure
this one out...
I have a form with a select list and a hidden field to save the selected
item. On submit another page is loaded with a few fields to be
I'm using the following DDL statement:
create table if not exists dbname.tablename
(
...,
the_datedate not null default current_date
);
I receive the following error message:
ERROR 1064: You have an error in your SQL syntax near 'current_date,
I'm been
Greetings!
I have the same problem Blue Presley did only I'm using Perl.
Using a textarea field with -wrap=virtual I input
Twas brillig, and the slithy toves
Did gyre and gimbol in the wabe.
All mimsy were the borogroves,
And the mome raths outgrabe
and it shows up this way when I look
Does MyCC is able to connect to MySQL servers in the local network...or it can connect
only to localhost?
NN
___
NOCC, http://nocc.sourceforge.net
-
Before posting, please check:
Hello,
How is REGEXP used? I have looked at the manual. If I have the following
values in my db table:
Id. regdate
00ca. 1900
011910
02ca. 1700-tallet
031550-tallet
041600-1700
...
and the query parameters: 190, 155, 170, I want the result
Use pre /pre around the text. If you look at the html source, I think
you will find that the text is, in fact, formatted. Also, you could write
a regular expression to replace a line break with a br.
On Sun, 4 Aug 2002, eric wrote:
Date: Sun, 4 Aug 2002 18:56:26 +0200
From: eric [EMAIL
Hi Heikki,
Thank you for responding.
(http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit
when the log files are full and the buffer pool is checkpointed.
InnoDB does 'fuzzy checkpoints'. That means modified database pages in the
buffer pool are flushed to disk in
Revised Class Schedule
Free Software Institute REVISED Class Schedule for August:
Classes $300 individually perl 1 and 2 bundle $550 GNU/Linux 1 Unix 1
bunlde
$550 - Students talking GNU/Linux 1 are require to purchase a computer
used
for the rest of the corse work
Complete program package -
SQL MYSQL
On 2002.08.04 14:46 Ruben I Safir wrote:
Revised Class Schedule
Free Software Institute REVISED Class Schedule for August:
Classes $300 individually perl 1 and 2 bundle $550 GNU/Linux 1 Unix 1
bunlde
$550 - Students talking GNU/Linux 1 are require to purchase a computer
used
for the
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 04, 2002 3:17 AM
To: Hussein Morsy; MySQL List
Subject: Re: users and db visibility
on 8/4/02 3:13 AM, Hussein Morsy, typed:
how can i make MySQL show only what db are available to the
27 matches
Mail list logo