Re: Database Quotas

ther am I an expert on databases. What I know comes from the administration I have to do at work, I would venture that many other people on the list have a better understanding of this issue than I do... just my .02 Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Database Quotas

gets full, writes are refused. I'm not sure how nicely that is handled ( in terms of error output ) but the advantage is that Pg is ACID compliant, so you won't lose data. Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: spamassassin database

atabase that is doing 90% writes, what database engine should I > use? Postgres :p In seriousness though, go with whatever the rest of your database uses. There are probably some minor differences between database engines, but for maintenance, you will not regret keeping things consistent.

Re: compile 5.5.4-m3 on centos 5.0

have done the right thing so far though and added a note, though you haven't specified what version of the source you are using. Colin On April 19, 2010 03:31:53 am Yang Wang wrote: > Dear All, > > I hit belown problem when i compile(make install) 5.5.4-

Re: INSERT INTO multiple tables

worked! Since it is your script, the way you ultimately do it is your option... I would suggest that you do not disconnect between inserts, this is terribly inefficient. Colin On April 12, 2010 05:57:42 pm Gary wrote: > Michael > > Thank you for your response. It gave me the idea how to

Re: INSERT INTO multiple tables

Seriously... I found the answer in the first result. http://lmgtfy.com/?q=mysqli+multiple+insert+statements Assuming mysqli, if you are using a different driver, then google that Colin On April 11, 2010 10:36:41 pm viraj wrote: > is it mysqli query or 'multi_query'? > > ht

Re: mysqld_safe

Yeah, its just a shell script that acts as a wrapper around the mysql processes on debian systems( maybe others, I'm not sure) You can read it at 'less /usr/bin/mysqld_safe' Colin On March 29, 2010 11:51:36 am Glyn Astill wrote: > --- On Mon, 29/3/10, Brown, Charles wr

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

what everyone else said... also, is there a longer version of the error? or is it literally error 2 or error 22? Colin On February 1, 2010 06:38:08 pm kebede teferi wrote: > Hi, I'm very new to this and I need help. > > What I want to do is to execute a source command stateme

Re: Image Store @ My SQL

I agree with Walter, a filesystem is far better suited for this. That said, mysql does have the ability to do what you are saying, you would just store it as a binary blob which is well documented and quite easy to use. See: http://dev.mysql.com/doc/refman/5.0/en/blob.html Colin On January

Re: Record old passwords ?

On January 18, 2010 01:34:15 pm Tompkins Neil wrote: > Hi > > I'm in the process of designing a login system to a secure web page using > MySQL. One of the features is we need to record and ensure that the user > password is different from any of the last four passwords he/she has used. > I was

Re: Query help

675 got a result 'o' which would be 2 (455 & > 302). I have tried different group by columns but to no avail. Can > someone help? > > Thanks, > > Richard > select count(trans_no), comp_id from SEARCHES group by comp_id I think that should do it...haven'

Re: Query :: Finding Date Difference

admin.... > > > Please tell the query , > > Thanks Getting answers to your questions is easier if you can show you have done a little backround work to try to find the answer. Case in point: http://lmgtfy.com/?q=datediff+in+mysql Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: 1 Machine with 4 GB RAM for Big Size MySQL Data Size

s project makes sense and > can be continued. Perhaps with a note of the problem in vailure single > point because there is only 1 server. > > Furthermore if there is progress again, I'll try sharing. > > Thank you very much > Perhaps its worth looking at a master-slave relationship between 2 servers if you are concerned about a single point of failure. Colin -- There is a 20% chance of tomorrow. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: 1 Machine with 4 GB RAM for Big Size MySQL Data Size

What sort of data? Is it currently stored in a database? If so, how many tables? 24GB of text data in a single table is quite a bit, but manageable if maintained properly. 24 GB of binary data on the other hand, is not very much at all. Colin On Friday 04 September 2009 12:48:18 pm

Re: sub query or something else

e data, we can probably be more helpful. Colin On Thursday 03 September 2009 11:47:17 pm sangprabv wrote: > What I'm looking for is to SUM the price from partner A and B with each > result. So the result I expect is like "Partner A total's price 123, > Partner B total'

Re: Using Open Source Database

ng list, but I strongly encourage having a good look at Postgresql. In my opinion, it is better suited for a commercial database environment than mysql. If you are curious, join the Postgresql general mailing list and watch the traffic for a couple days, see what others are using it for. Coli

Re: How to use LIKE for detecting numbers with commas?

LIKE '%,8,%' ? Probably not as elegant as you were looking for, but it works :) Colin On Monday 06 July 2009 21:31:51 Highviews wrote: > Hi, > I have numbers separated with commas saved into a TEXT Field, for example: > > ROW1: 10,5,2,8, > ROW2: 2,7,9,65 >

Re: Patch for mysql

what patch this might be), I'd avoid this method of getting things done -- Colin Charles, http://bytebot.net/blog/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Migration from 32-bit to 64-bit MySQL

e any longer kind regards -- Colin Charles, Community Relations Manager, APAC Database Group, Sun Microsystems Inc., http://www.mysql.com/ Tel: +6012 204 3201 (Malaysia) | colincharles (Skype) Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing

Re: Migration from 32-bit to 64-bit MySQL

32-bit and 64-bit? Is this a good idea? Can it be done? What would make this go wrong? Addressing more RAM currently is your only gain... On a 32-bit system, you tend to only have 2.5-2.7GB of RAM available to MySQL (your OS needs the remainder) Kind Regards -- Colin Charles

Re: Index usage for simple query

Baron Schwartz wrote: Hi, Colin Martin wrote: Hi there, Can someone please explain why when the query below uses one constant in the WHERE clause, MySQL decides to use the index on the 'source' column, and why in the second query where there are two constants, it decides not to?

Index usage for simple query

ect_type | table | type | possible_keys | key | | 1 | SIMPLE | data_total | ALL | source| NULL | (Output chopped for better formatting) Thanks, Colin Martin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

Re: Availability of 5.1 as production release ?

Q3/Q4 this year, I believe -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Ekiga/Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Users Conference: http://www.mysqluc.com/ -- MySQL General Mailing List For list archives:

Re: incompatible libmysqld.a

is a problem. It compiles with glibc v2.5 on Fedora Core 6 This computer is a laptop Acer Aspire 5633WLMi, Intel Core Duo processor. Can you file a bug report at bugs.mysql.com? thanks -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12

Re: incompatible libmysqld.a

lease provide more details. Also, what version of gcc is this? thanks -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing

Re: mysql_upgrade shows errors

Yves Goergen wrote: On 14.02.2007 08:00 CE(S)T, Colin Charles wrote: The MySQL 5.0 release is available as a binary and is currently at 5.0.27. Grab it at: http://dev.mysql.com/downloads/mysql/5.0.html#downloads I read in the news some time ago that MySQL 5.0 is only going to be available as

Re: Error MYI 1016 - damaged database table

mmand, which is part of the MySQL installation, can be executed on the server when the database server is no longer running: myisamchk /path/to/database/directory/.MYI Dans quel fichier devrais-je intervenir? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mob

Re: Setting up multiple daemons

might consider reading: http://dev.mysql.com/doc/refman/5.0/en/multiple-unix-servers.html There is also documentation if you wanted to do this on Windows -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http

Re: mysql_upgrade shows errors

a apt-get? Debian has very sensible packaging, and its currently at version 5.0.32 afaik What do the above error messages mean? The upgrade script picked up on the fact that you had duplicate column names -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, ww

Re: Repairing a table

me usually (Falcon is meant to fix this)... Do you know why the disk is filling up so fast? What MySQL version is this? And how much *actual* free space do you have? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles

Re: Log Warnings Level

ted connections -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: yum version 5.*

at is currently released -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Please help*

://dev.mysql.com/doc/refman/5.0/en/installing-source.html -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives

Re: mysqld_safe failing

server can't access /var/run/mysqld I suggest making sure the permissions are correct (using chown will fix it) -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge:

Re: Log Warnings Level

documentation there is on this? What kind of additional information are you looking about the --W (or --log-warnings=N) option? I'd pay attention to aborted connections, as MySQL Network's monitoring service actually does do so kind regards -- Colin Charles, Community Enginee

Re: MySQL Administrator problem

Ed Reed wrote: Unable to manage user accounts through MySQL Administrator 1.2.8. I've found that I'm not the only one with this problem but no one seems to have an answer for it. Have you reported a bug to bugs.mysql.com ? kind regards -- Colin Charles, Community Enginee

MySQL MiniConf at linux.conf.au 2007 CfP

ld by Linux Australia. This means that you must register for LCA 2007 attendance to participate in the conference. For further details regarding registration and accommodation for LCA 2007, please visit LCA 2007. Speakers will be notified by 7th December 2007. -- Colin Charles, Community Engineer

MySQL Camp

Hi all, Please note that MySQL Camp will be happening soon in San Francisco, and its being hosted at the Google campus. Do pay it a visit if you're nearby http://mysqlcamp.org/ Check out the interesting topics! -- Colin Charles, Community Engineer MySQL AB, Melbourne, Aust

Re: Drupal and MySQL

Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: On Thu, Aug 31, 2006 at 09:52:37AM +1000, Colin Charles wrote: Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: Has anyone heard of drupal breaking under a minor upgrade from

Re: Support for JDBC 4.0?

x27;t even being released by Sun till late October. So, we expect to start shipping after Sun's sorted things out hope this helps -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12

Re: MySQL 5.1

7;re after 5.1, so you get disk as opposed to memory only based storage then -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/

Re: Drupal and MySQL

broke (which really shouldn't affect Drupal, unless PHP itself is to be blamed) -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysq

Re: MySQL+OpenVPN

PN is setup is a completely other matter -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For

Re: MySQL App development

[EMAIL PROTECTED] wrote: Is there anything called "MySQL application development environment guide", as it is there DB2 (IBM) which explains how to work with MySQL and C++ together? Can you show me what DB2 does that's different from our C++ API? Or can I refer DB2 App guide

Re: How does the federated engine table work

ander at the documentation? http://dev.mysql.com/doc/refman/5.0/en/federated-description.html http://www.oreillynet.com/pub/a/databases/2006/08/10/mysql-federated-tables.html hope this helps -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18

Re: installing mysql

read the 3-4 MySQL upgrade guide in our excellent documentation? best regards, -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http

Re: measuring query time

Deniz Ersoz wrote: Is there a way to get the time spent in the server for each query? Write it in a log or append it to the result ??? Will what is in the slow query log help? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46

Re: Error Messages

my.cnf config file Also, is this with MySQL 5.0.19? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles Using MySQL for a FLOSS application? http://dev.mysql.com/doc

Re: /var/log/mysql.000001 Not Found?

its worth, you should be logging to /var/log/mysql/foo, and make sure that /var/log/mysql can be read/written to by the mysql server HTH -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12

Re: Can MySQL jobs be posted to this list?

Beau Gould wrote: Thank you, Beau Gould The best place for this would probably be the Jobs forum located at http://forums.mysql.com/list.php?8 -- Colin Charles, Community Engineer MySQL AB, Kuala Lumpur, Malaysia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Are you

Re: upgrade advice

en/upgrade.html a visit as well. Hope this helps -- Colin Charles, Community Engineer MySQL AB, Kuala Lumpur, Malaysia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://

Re: How to create database in different location

to replicate? Or use clustering? More details are required. Kind regards -- Colin Charles, Community Engineer MySQL AB, Kuala Lumpur, Malaysia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For

Re: which release of Mysql is compatible with fedora core3 ?

the Fedora Project provided version, that caps of 3.23 (the RPM's available via yum) Hope this helps -- Colin Charles, Community Engineer MySQL AB, Kuala Lumpur, Malaysia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Are you MySQL certified? www.mysql.com/certific

.NET Connector Output Values

I have the following code: ... query = "INSERT INTO a_test_table (a_test_table_id,name,last_mod_date,create_date) VALUES (?a_test_table_id,?name,?last_mod_date,?create_date)"; ... command.Prepare(); ... command.Parameters.Add("?a_test_table_id", MySqlDbType.Int32); command.Parameters["?a_test_

Executing multiple queries at a time in Query Browser

re'); The seperator Œ;¹ doesn¹t seem to be enough. Is there some other command that I need to add between queries? Thanks, Colin

calling procedures from the .NET provider

procedure. Has anyone been able to get this to work? Thanks, Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to installing mysql5 on fc3?

e-download can/will solve Best regards -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

User Accounts

After installing MySQL on OS X, there don¹t appear to be any user accounts created by default. Does anyone know what user account to use or if there is a convention that I should use when creating an ŒAdmin¹ account? Cheers -c

Re: Moving Data

using ESS disks on SAN, and they're RAID 5. See www.baarf.com for comments against RAID 5 Colin Bull -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Foreign Key Constraints

doing reports is easiest and no constraint. Colin Bull -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: unique values across more than one column

the user table using a foreign key. Regards, Colin. -Original Message- From: Anand Buddhdev [mailto:[EMAIL PROTECTED] Sent: 27 February 2004 08:50 To: [EMAIL PROTECTED] Subject: unique values across more than one column Hi everyone, I'm using mysql version 3.23.58, on Fedora c

Installing MySQL 4.1 on RedHat Linux 7.2

using the '--nodeps' flag? Any ideas? Colin Lawrence

Create database error

database 'mydb'. (errno: 2)" Using perror, "errno: 2" means "No such file or directory". Does anyone know why it might be giving me that error? Thanks, Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Running mysql standalone

2. When I take that option out, it says "Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist". This, to me, suggests I need to install MySQL properly. But I don't want it to have to be installed! Any suggestions? Thank you, Colin O&#x

Re: count max days

Whenever you use the Max() function on a column while accessing other columns at the same time you need a GROUP BY statement so that the MAX() function knows how to "group" it's results. I suggest you look into the manual for this. In fact it has a tutorial showing you options on how to do exactly

error loading mod_auth_mysql

d/httpd.conf: Cannot load /usr/libexec/httpd/libphp4.so into server: (reason unknown) Is there a particular order that this had to go in the httpd.conf file? I can't understand why it is complaining about libphp4. What do you think I'm doing that I should be doing differently? Thanks ve

mysql fails at strat

art. As I could not find anything in the documentation about this I thought I better contact you. Best regards Colin Knowles How-To-Repeat: Fix: Submitter-Id: Colin Knowles Originator: [EMAIL PROTECTED] Organization: University of Bristol, Department of Economics

Problems returning a row count with rows() function

Many thanks for any help you can provide... Colin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <

RE: Sequential read on a file

$row = setVariables($row); foreach($row as $key => $value) $$key = $value;// copy value to key-named field/var. } mysql_free_result($result); return $num1; } ?> - As I said, we are fumbling a bit here as we look to move towards web-based systems. Regard

Sequential read on a file

y I am going about it "right" or is there a more simple/logical method? My main concern is that, with the key being auto-increment, as records are added and removed from the database, as simple +1/-1 may fall over. -Colin -

Re: MySQL3.23.52 with snort-1.9.0

Hi there , I am problems with snort logging to Mysql and I am wondering if this is a permissions problem . If any of you have worked on the snort IDS technology could you please help because I having severe difficulty with the product. The permissions I have given the User snort are >GRANT CREATE,I

Re: WoW!!!! SQL is something!

> I had a problem that required a proper sort of the following: > > IT66 > ITD38 . . . . > ITD100 > ITD101 > ITD102 > ITD103 > ITD104 > ITD105 > > > Because of the different lengths, this was a nightmare for "order by" and so > it led me to my first experiments with case > and I go the followin

Re: Formatting data in a query

Thanks in advance! You want to use the SUBSTRING function. E.g. SELECT password, SUBSTRING(username, 1, 6) FROM my_table WHERE ... See the MySQL manual for more info: http://www.mysql.com/doc/en/String_functions.html Thanks, Colin Anderso

For all you people looking for mysql shirts ;-)

ry in advance if anyone is offended by this post. FILTER FODDER{ SQL, SELECT, DATABASE } -- Colin Faber (303) 736-5160 fpsn.net, Inc. * Black holes are where God divided by zero. * - Before posting, please check:

repeated crashes (buffer overrun?)

up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 670938 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Any ideas? - Colin - Before posting, please check: http://www.mysql.com/

Re: a newserver would be better than this mailing list

are probably more arguments against it ;-) > So my question, why this mailing list, why not a newsserver? See http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&safe=off&group=mailing.database This list is already fed t

Re: Bash to remote MySql Server

http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: h

Re: Opposite of --skip-networking?

;http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc.

Re: copy question

(the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscrib

Re: MySQL on a Cobalt RAQ4

- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscrib

Re: Read-Only MySQL

fore posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try:

Re: ROOT Access Denied !!

Thank you Ray, this worked! Colin on 6/11/02 2:59 PM, Ray at [EMAIL PROTECTED] wrote: > mysql --password > (or just -p) > > On Tuesday 11 June 2002 7:30, you wrote: >> When I try to connect to mysql as 'root' I get the following: >>> [localhost:/Users

ROOT Access Denied !!

When I try to connect to mysql as 'root' I get the following: >[localhost:/Users/cooldaze] root# mysql >ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) I can connect as a normal user, but can't create any databases or do other necessary admin functions, so I need to be

Re: license...

-- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-m

Re: Newbie MySQL installation problems (specific)

I try to connect, either as root (which I understand is not a good idea) or under my normal login, I get the same error, i.e., that the socket can't be found. Very puzzling and I'm quickly approaching the point of concluding that the amount of time trying to troubleshoot this mess not

Newbie MySQL installation problems (specific)

.sock" error message. No matter what I try, I can't seem to connect to mysql so that I can even BEGIN to figure out how to correct the 1062 problem! Can anyone tell me how to what the "ERROR: 1062" message means and how to resolve this mess? I've sea

Re: MySQL and DBI remote access

ease check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]>

Re: Get message

---- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe,

Re: Tab delimited dump?

-- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing?

Re: Demande d'inscription à mysql-france

> Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <

Re: apparent bug

Hi Buff, Try under the optimization section. Though keep in mind the impact on speed shouldn't be that great.. By the way.. in an ideal design your primary key will be an integer ;-) Buff Smith wrote: > > Colin, > > Where can I read about the impact of having Primary Keys

Re: apparent bug

CHAR(30) NOT NULL, >Password CHAR(16) NOT NULL, >User_Access_Level_Code TINYINT NOT NULL, >User_SignUp_Date DATE NOT NULL, >Password_ReminderCHAR(64) NOT NULL, > User_Expire_Date DATE NOT NU

Re: Database's Disappear from phpMyAdmin

l.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribin

Re: Load data command?

, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting,

Re: Temp Table size?

> Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]

Re: empty?

t; Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (

Re: mysql error

h this MySQL version" > Is that command not availbale in version 3.23.49 if yes what is the > alternate command for it. > Would appreciate any help you can give me. > > Tristan -- Colin Faber (303) 736-5160 fpsn.net, Inc.

Re: Is there MySQL version 4.0.2 ?

it via "bk pull" and I have used the: > > >cd mysql-4.0 > >bk pull bk://work.mysql.com:7001 > Nothing to pull from bk://work.mysql.com:7001 > > when I have checked my local copy via: > > >bk -r check

Re: mixed up variables || solution found

fault NULL, > > ETPA_membership_expires date default NULL, > > face blob, > > KEY id (id), > > FULLTEXT KEY resid (resid) > > ) TYPE=MyISAM; > > > > > > - > > Before posting, pleas

Re: source code

ttp://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

  1   2   3   >