Yves!
This is a complicated matter alright, but it is a complicated
problem to solve here also. Your statement about characters being the
same isn't really correct. To take an example: Let's assume you were
doing a phonebook, in print, of all people in the world. How would you
sort that?
Hello.
I get a rather strange error which I so far not been able to find the cause of:
---
/usr/bin/install: cannot stat `./t/*.disabled': No such file or directory
make[4]: [install-data-local] Error 1 (ignored)
---
I thought maybe it could be beacuse I run Debian Testing?
So far I have not
hi all, i have a user that can only access localhost, how do i grant this
user permission so that can also be accessed from 192.168.1.50?
thanks
t. hiep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
GRANT [ALL PRIVILEGES|Appropriate Privileges] *.* TO root@'192.168.1.50'
IDENTIFIED BY 'password' WITH GRANT OPTION;
Or if you want a root user from a subnet
GRANT [ALL PRIVILEGES|Appropriate Privileges]ON *.* TO root@'192.168.1.%'
IDENTIFIED BY 'password' WITH GRANT OPTION;
On Mon, 3 Mar 2008, Hiep Nguyen wrote:
hi all, i have a user that can only access localhost, how do i grant this
user permission so that can also be accessed from 192.168.1.50?
i got it. thanks
t. hiep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
You're always safe using your own localhost (127.0.0.1) but
You probably want to re-think using a dynamically assigned address such as
192.168.xxx.xxx which can change anytime
FWIW
Martin-
- Original Message -
From: Hiep Nguyen [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday,
The primary key sounds like the right one. You don't need an
additional one for userid alone, as the primary key will serve to
accelerate those queries as well.
- michael dykman
On Sun, Mar 2, 2008 at 9:30 PM, Waynn Lue [EMAIL PROTECTED] wrote:
Whoops, finished my thought too early. I was
hi all, i just installed mysql and started mysqld.
it suggested i change pw for root, so i did:
mysqladmin -u root password my_pw;
but i can't do:
mysqladmin -u root -h dev.jss.com password my_pw;
how do i change pw for [EMAIL PROTECTED]
thanks,
t. hiep
--
MySQL General Mailing List
For list
On Mon, Mar 3, 2008 at 2:01 PM, Hiep Nguyen [EMAIL PROTECTED] wrote:
hi all, i just installed mysql and started mysqld.
it suggested i change pw for root, so i did:
mysqladmin -u root password my_pw;
but i can't do:
mysqladmin -u root -h dev.jss.com password my_pw;
how do i change pw
http://dev.mysql.com/doc/refman/5.0/en/schemata-table.html
According to MYSQL doc:
A schema is a database
Wikopedia says a Schema is defined as:
Pronounced as skee-ma, the structure of a database system, described in a
formal language supported by the database management system (DBMS). In a
On Mon, 3 Mar 2008, Daniel Brown wrote:
On Mon, Mar 3, 2008 at 2:01 PM, Hiep Nguyen [EMAIL PROTECTED] wrote:
hi all, i just installed mysql and started mysqld.
it suggested i change pw for root, so i did:
mysqladmin -u root password my_pw;
but i can't do:
mysqladmin -u root -h
I'm in the design stages of creating a database schema and my problem is that
one of the tables I'm creating has the possibility of growing to several
billion rows over time. I could probably cut this by a few factors, but
we're still looking at least a billion rows.
Each row will only be a few
On Mon, Mar 3, 2008 at 2:46 PM, Hiep Nguyen [EMAIL PROTECTED] wrote:
mysql select user,host,password from mysql.user;
+--+--+--+
| user | host | password |
+--+--+--+
| root |
On 03.03.2008 10:27 CE(S)T, Anders Karlsson wrote:
[a lot about why sorting unicode is complicated]
If you want to
accknowledge exact matching, and say any character, accented / unlauted
etc, is different from any other character, specifiy a binary comparison:
SELECT * FROM phonebook WHERE
yves
when creating a varchar field in table creation, use the binary.
that way, selection is exact. always.
david
-Original Message-
From: Yves Goergen [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2008 1:44 PM
To: Anders Karlsson
Cc: MySQL
Subject: Re: Unicode sorting and binary
Yves!
OK. I agree I don't like this much myself, but we have to live with
the multi-lingual aspect of UNICODE. Or rather, we have to agree to be
either multi-lingual, and have the cons and pros of that (using
UNICODE), or ignore UNICODE and have binary collations etc. And
collation also
I've been noticing strange load spikes on our mysql machine, throwing
back the dreaded max connections error, even though the value is set
to 500. I'm wondering if this is related to an hourly script I run
that does a few somewhat-db intensive queries. The script runs a
query that groups by
On 03.03.2008 23:17 CE(S)T, Anders Karlsson wrote:
And you are right of course, you may use the COLLATE keyword also,
to enforce a certain collation, although if you want BINARY, I think
using BINARY might be slightly more effective.
I was also considering compatibility with other DBMS.
In response to an email offlist, I forgot to specify that these are
InnoDB tables.
On Mon, Mar 3, 2008 at 2:53 PM, Waynn Lue [EMAIL PROTECTED] wrote:
I've been noticing strange load spikes on our mysql machine, throwing
back the dreaded max connections error, even though the value is set
to
Hello,
when we create user accounts on our mysql server, then we strictly
disallow CREATE TEMPORARY TABLE.
This said, I was a bit shocked that mysql doesn't really care and allows
this command without a problem:
create table x engine = memory;
What is the use to deny users to create a
20 matches
Mail list logo