Connection Error

I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this machine"), whenever I try to connect to MySQL server from any client by using its IP or "friendly" DNS name other than 127.0.0.1 or localhost. This has happened on three machines so far, is there something I forgot to enable/d

Re: Query with group by

>From the SQL Reference for DB2: --- >>-CHAR--(--datetime-expression+---+--)>< '-,--+-ISO---+--' +-USA---+ +-EUR---+ +-

Re: Upgrading MySQL. Caveats or Cautions anyone?

You can ignore both of those if you use the binaries. -Eric On Fri, 17 Sep 2004 18:43:02 -0800, Tim Johnson <[EMAIL PROTECTED]> wrote: > Hello: > Am currently using Ver 11.18 Distrib 3.23.58 > on Linux 2.4.20-20.9. (RH 9.0). > > I'd like to upgrade to the current version. I would > like to

Upgrading MySQL. Caveats or Cautions anyone?

Hello: Am currently using Ver 11.18 Distrib 3.23.58 on Linux 2.4.20-20.9. (RH 9.0). I'd like to upgrade to the current version. I would like to know if there are any cautions to observe, or any prepartory steps to take. If I look at the following URL: http://dev.mysql.com/downloads/mysql/4.0.

Re: Query with group by

I took a closer look and found the problem -- char(date). Is char() necessary in DB2 to cast the date as a string? In MySQL, char() expects a list of integers to interpret as a list of character codes . Removing char() makes the query

Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?

On Fri, Sep 17, 2004 at 04:01:53PM +0300, Egor Egorov wrote: > Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > > >> I can verify that a quad opteron 2.2 runs about a million times > >> better than a quad xeon 3.06. The opteron can handle more than 3 > >> gigs of memory which is a 32 bit limitation.

Re: Problems with Left Join query

First, you want to get an answer for every module, so you must use modules LEFT JOIN permissions to get a row for every module. You see? The table with missing rows (no row for Bob/module3 in permissions) goes on the right. When the table on the right does not have a matching row, the LEFT JO

Re: Problems with Left Join query

- Original Message - From: "David T." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 17, 2004 2:33 PM Subject: Problems with Left Join query > I am building a database with permissions for different modules. The > permissions table contains a separate row for each m

Re: Problems with Left Join query

On Fri, 17 Sep 2004 11:33:04 -0700 (PDT), David T. <[EMAIL PROTECTED]> wrote: > I am building a database with permissions for different modules. The > permissions table contains a separate row for each module/user combination, You didn't say, but if you're using PHP you might find this of use: h

Problems with Left Join query

I am building a database with permissions for different modules. The permissions table contains a separate row for each module/user combination, and lists the add/mod/del permissions for that module. So, for example, user 'bob' might have add and del rights for 'module1', add only rights for 'modul

Re: grants to multiple DBs at once

That's my fault. It does work with 4.0.18. (The manual is usually pretty good at specifying when something is 4.1 only, by the way.) You need to quote the db string with backticks, not single quotes (as I did in my example). So, you would use GRANT SELECT ON `dev\_%`.* TO [EMAIL PROTECTED

OUTER JOIN bug in 5.0.1?

Is there a known bug with outer joins in MySQL 5.0.1? I tried the following query on 5.0.1: SELECT s.tech_id, s.full_name, sa.points_awarded, sa.date_submitted FROM student s INNER JOIN enrollment e ON e.tech_id = s.tech_id INNER JOIN submitted_assignment sa ON sa.tech_id = s.tech_id RIGHT JOIN

Re: mysqldump and the dreaded lost root password dilemma

There probably is a "root" user, but it's not called root. You can name the "root" user whatever you want. You probably just don't have a user named "root", which is why you can change the password for user "root". You want to start MySQL with the skip grant tables options, just like in the doc

Re: How to limit log space usage?

Nico Sabbi wrote: Hi, I have a configuration with 1 master and 2 slaves; all servers are correctly running mysql-max-4.0.20. All is fine, but I'm observing a strange usage of logs. On one of the slaves I have: mysql> show slave status \G *** 1. row

sql statement: "optimize TABLE tablename" taking forever

the statement is taking 3 hours and counting. "optimize TABLE tablename" normally this takes 30 minutes or so. boss wants to kill this thread. does that mean the table will end up corrupt? any input helpful. david hrdw: solaris 4cpu, running version 8 mysql version 4.0

Re: grants to multiple DBs at once

Hi Michael, Thanks for the reply. It doesn't work, at least not with 4.0.18. I also tried without the _ to simplify the case, but the grant statement isn't wild about the wildcard. :) The docs you list are for 4.1. I guess I will have to wait until 4.1. :)

mysql installation

Hello, I am trying to setup mysql and need some guidance - thanks Linda Caulfield Software Quality Engineer Global Hawk Program Rancho Bernardo X4680 Phone:858.618.4680 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Re: Query with group by

Jose Miguel Pérez wrote: Hi Michael! Yes, you're right, thanks for extending and clarifying my message. However, I'm not confident about your comments on the inefficiency for the following query: I'll explain my reasoning below. SELECT c1.date, c1.location, c1.version FROM cities

Re: JDBC - how to insert Strings with mixed characterEncodings

Barley <[EMAIL PROTECTED]> wrote on 17/09/2004 15:17:11: > Say, for example, I want to run an insert like the following: > > java.sql.Statement select = conn.createStatement(); > select.executeUpdate("update test set observerNote='\u201C ... \u00BC'"); > > FWIW, u201C is an opening curly quote

mysqldump and the dreaded lost root password dilemma

Hi list, First question - I have a machine that was being managed by Plesk, and an update to mod_python left Plesk in a nonrunning state (actually causes apache to segfault). So I am attempting to manually manage MySQL (the way it should be done!) - but there is apparently no root user in MySQL's

Re: Global privileges - everyone has them!!!

Greg, thanks for the suggestion. I had not done that. I ran "FLUSH PRIVILEGES" in mysql query browser and it hung (the dolphin started swimming forever and the program crashed). After I shut the program down (with ctrl-alt-del), the database was not functioning. I had to restart the computer, and

JDBC - how to insert Strings with mixed characterEncodings

Say, for example, I want to run an insert like the following: java.sql.Statement select = conn.createStatement(); select.executeUpdate("update test set observerNote='\u201C ... \u00BC'"); FWIW, u201C is an opening curly quote and u00BC is a fraction representing one quarter. If I create my JDBC

Re: Problem bringing up mysql on RHEL

On Fri, 2004-09-17 at 13:47, Egor Egorov wrote: > Peter Flynn <[EMAIL PROTECTED]> wrote: > > > manual, mysql_install_db gets run automatically when you > > do this, but I don't know what to look for as evidence that > > this has happened. > > Wrong way. > > Remove it and install MySQL official

Re: formating output

> Hi folks - > I have looked thru the documentation and the books I have on MySQL - > but have not found anything on how to format column output from select > statements. I'm trying to do several things - > a) if a date is the default of -00-00 then just show a blank > b) for a phone number o

database relations

Hello folks Can I use or implement database relations in sql as some do in databases in accecss..? tommie -- ___ msc. tomas alberto ramirez.andujar webmaster - cejisoft - +5332 262451 /261410 universidad pedagogica jose marti. camaguey circunvalacion norte

Re: Lost connection to MySQL server during query & bind-address

Marten Lehmann <[EMAIL PROTECTED]> wrote: > Redhat Enterprise Linux 3, self-build mysql 4.0.20 (server and client). OKay, here's the problem - a self-built MySQL. Unfortunately, due to some glibc bugs it's not really possible to build a stable MySQL under linux using stock glibc... And the pro

Re: delay_key_write usage

Paul DuBois <[EMAIL PROTECTED]> wrote: >>> According to the documentation, when delay_key_write is active the index >>> keys aren=92t written to disk until the table(s) are closed. When is a = >>> table >>> closed? Is it only when a connection is closed? >> >>When connection is closed, when FL

Re: Query with group by

Here is the output I got when I ran my query - and yours, Michael - against DB2 V7.2. Please note that I replaced the 'temp' table in Michael's query with the real table in both the outer query and the subquery; no other changes were made. --

Re: Which file to backup

Egor Egorov wrote: Mauricio Pellegrini <[EMAIL PROTECTED]> wrote: I'm trying to backup the 'binary log' and don't know which file is it. these are the files I see in my datadir -rw-rw 1 mysql users175K Sep 14 14:21 hrrgp01-bin.07 -rw-rw 1 mysql users345K Sep 14

Re: Which MySQL product should I choose for a comparison?

[EMAIL PROTECTED] wrote: > I am doing a technical comparison between two products of which one is > MySQL. But I don't exactly know which product that MySQL offers that I > should pick. > > I am thinking of MaxDB, because it's supposed to be the most feature rice, > but it does not seem to be MyS

Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?

Jeremy Zawodny <[EMAIL PROTECTED]> wrote: >> I can verify that a quad opteron 2.2 runs about a million times >> better than a quad xeon 3.06. The opteron can handle more than 3 >> gigs of memory which is a 32 bit limitation. Right now in my quad >> opteron we have 32 gigs of memory and MySQL is

Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?

"Dathan Vance Pattishall" <[EMAIL PROTECTED]> wrote: > I get permission from my bosses to release the benchmarks I will send it = > to the list. Please! This definitely will be a valuable information for the community. -- For technical support contracts, goto https://order.mysql.com/?ref=e

Re: ft_min_word_len=2... YAY or NAY?

[EMAIL PROTECTED] wrote: > I'm wondering whether or not I should implement fulltext searching for 2 letter > words within a product database (HP, TV, G5, LG, etc)... My searchable text is > currently about 600Mb and a 3-letter fulltext index is consuming about 420Mb. > > Is the trade-off for u

Re: Checking for live connections

Ruben Safir Secretary NYLXS <[EMAIL PROTECTED]> wrote: > Is there a way of checking for live connections prior to using > mysql_connect in the C API (asside from mysql_ping) Try to open a TCP connection to port 3306 of target server. If successful - then "connections are live". Close that test

Re: Problem bringing up mysql on RHEL

Peter Flynn <[EMAIL PROTECTED]> wrote: > manual, mysql_install_db gets run automatically when you > do this, but I don't know what to look for as evidence that > this has happened. Wrong way. Remove it and install MySQL official binary RPMs downloaded from www.mysql.com. -- For technica

Re: Error

[EMAIL PROTECTED] wrote: Scott Hamm <[EMAIL PROTECTED]> wrote on 17/09/2004 13:15:30: mysql> create table list_admin ( -> admin_id int(11) default '0' not null auto_increment -> ); ERROR 1067 (42000): Invalid default value for 'admin_id' How can I set default value to 0? I don't think you

Re: Force slave to connect from specified IP

Irek Slonina <[EMAIL PROTECTED]> wrote: > I have two interfaces on my slave: > ppp0 80.80.80.8 ( -> Internet ) > eth0 10.10.10.1 ( -> LAN ) > > and remote master host 192.168.168.168 available by 80.80.80.8. > > How can I force mysql to start slave processes using 10.10.10.1 > and not 80.80.80.8

Re: Mysql goes down when executing query

Mauricio Pellegrini <[EMAIL PROTECTED]> wrote: > Hi, Sorry to disturb but Mysql 4.1.4 gamma goes down when executing this > query. Please create a testcase and send it to me by email at [EMAIL PROTECTED] I will investigate and get back to you. Somehow looks like you've found a bug. -- Fo

Re: different max_connections based on users/host

Alberto Mucignat <[EMAIL PROTECTED]> wrote: > I mean, suppose we have max_connections=500, is it possible to say that > from all external clients there could be at max 490 connections, while a > single host or user can have at max 10 connections? Obviously, if host > who has "reserved" 10 conne

Re: root-password important?

Marten Lehmann <[EMAIL PROTECTED]> wrote: > security problem? Is there any way to trick the mysql-server, so that a > remote-client can claim to be a localhost-client and thus can connect as > mysql-user root? No. -- For technical support contracts, goto https://order.mysql.com/?ref=ensi

Re: Error

You can't - auto_increment cannot have a default value, AFAIAA. Terry - Original Message - > mysql> create table list_admin ( > -> admin_id int(11) default '0' not null auto_increment > -> ); > ERROR 1067 (42000): Invalid default value for 'admin_id' > > How can I set default va

Re: Error

Scott Hamm <[EMAIL PROTECTED]> wrote on 17/09/2004 13:15:30: > mysql> create table list_admin ( > -> admin_id int(11) default '0' not null auto_increment > -> ); > ERROR 1067 (42000): Invalid default value for 'admin_id' > > How can I set default value to 0? I don't think you can have a

Re: Installing DBIx::DWIW on CPAN

"Sanjeev Sagar" <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] DBIx-DWIW-0.41]# make test > PERL_DL_NONLAZY=3D1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl > 1..1 > # Running under perl version 5.008 for linux > # Current time local: Wed Sep 15 13:42:27 2004 > # Current time GMT: Wed Sep 15

Re: Query execution time?

joe mcguckin <[EMAIL PROTECTED]> wrote: > Does the mysql server return to the client (DBI in this case) the query > execution time? If so, how do I retrieve it? my $_startTime = time; $dbh->do("INSERT INTO dinner VALUES ('chicken','grille')"); print "Execution time: ".(time - $_startTime)."\n";

Re: Changing datatype of a large table's column

Wouter van Vliet <[EMAIL PROTECTED]> wrote: > Would I be able to support the datatype change on this? And more > generally; can somebody advice me on (maybe some other) strategy for > changing the datatype? Actually it's easy, you just need to have free space to be able to convert from blob to lo

Re: About Mysql Security

Mike Bao <[EMAIL PROTECTED]> wrote: > Last week, the all tables in one database had been deleted, which is > second times since I upgrade my operation system from NT 4.0 to Server > 2003. Before that, they had been deleted many times. > > I just copied all table files to one database(one director

Error

mysql> create table list_admin ( -> admin_id int(11) default '0' not null auto_increment -> ); ERROR 1067 (42000): Invalid default value for 'admin_id' How can I set default value to 0? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:

Re: Which file to backup

Mauricio Pellegrini <[EMAIL PROTECTED]> wrote: > I'm trying to backup the 'binary log' and don't know which file is it. > > these are the files I see in my datadir > > -rw-rw 1 mysql users175K Sep 14 14:21 hrrgp01-bin.07 > -rw-rw 1 mysql users345K Sep 14 15:03 h

Re: 4.1 client protocol?

Todd Gruben <[EMAIL PROTECTED]> wrote: > I have an interesting problem. I have developed a custom mysql > replication client that we use for monitoring our mysql database. Kinda > like a poor man's trigger, but the power of an asynchronus trigger is > very beneficial. Any way, I developed thi

Re: How to limit log space usage?

See http://dev.mysql.com/doc/mysql/en/PURGE_MASTER_LOGS.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/

Re: drop database after lost of synchro in innodb

Johanne, DROP DATABASE is rather safe, if it succeeds. http://dev.mysql.com/doc/mysql/en/InnoDB.html is the best reference. Best regards, Heikki Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up

Re: How to limit log space usage?

Nico Sabbi wrote: [...] There are 3 GB of logs that no one needs anymore. Since the master knows that all the slaves are correctly aligned up to a certain MASTER_LOG_POS, can't it automatically remove the logs up to that position? The problem here is that MySQL masters aren't necessarily aware of

How to limit log space usage?

Hi, I have a configuration with 1 master and 2 slaves; all servers are correctly running mysql-max-4.0.20. All is fine, but I'm observing a strange usage of logs. On one of the slaves I have: mysql> show slave status \G *** 1. row *** Maste

mysql and myisam

Does anybody know if it's possible to use together the mysql interface and native myisam commands? I tried with unfortunate result, obtaining a: Program received signal SIGSEGV, Segmentation fault. 0x080b7aee in _mi_writeinfo (info=0x8118bf0, operation=0) at mi_locking.c:371 371 my_errno=older

eBay: Sold on Grid (database array)

I like to share with you all, an interesting article about eBay's deployment of database arrays. http://www.eweek.com/article2/0,1759,1640234,00.asp Specifically on page 2, Marty Abbott (eBay's VP of Technology) states that eBay has four equal data centers. So in this array scheme, a write in