Re: problem with mysql threads on freebsd

On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote: > On Tue, 11 Jun 2002 08:36:55 +0200 > > Leo De Geer <[EMAIL PROTECTED]> wrote: > > im not abel to get mysql to use more then one thread on my freebsd > > 4.5-stable any one having a klue that wrong? > > from what method / tools, you ge

Re: problem with mysql threads on freebsd

Greetings! On Tue, 11 Jun 2002, Leo De Geer wrote: > On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote: > > On Tue, 11 Jun 2002 08:36:55 +0200 > > > > Leo De Geer <[EMAIL PROTECTED]> wrote: > > > im not abel to get mysql to use more then one thread on my freebsd > > > 4.5-stable any one h

Re: problem with mysql threads on freebsd

On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote: > On Tue, 11 Jun 2002 08:36:55 +0200 > > Leo De Geer <[EMAIL PROTECTED]> wrote: > > im not abel to get mysql to use more then one thread on my freebsd > > 4.5-stable any one having a klue that wrong? > > from what method / tools, you ge

problems with ' in db records

Hi there, I have some db records starting with a ' E.g: 'Aimburu Now I am wondering how to retrieve this records. without a addslashes it returns an error. So I did add a slash, but then it does not find this record. I tryed this query: ...like '\'Aimburu %' ... Do I have to change this db e

Re: problem with mysql threads on freebsd

On Tuesday 11 June 2002 09.26, Alexander V Zubchenko wrote: > Greetings! > > On Tue, 11 Jun 2002, Leo De Geer wrote: > > On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote: > > > On Tue, 11 Jun 2002 08:36:55 +0200 > > > > > > Leo De Geer <[EMAIL PROTECTED]> wrote: > > > > im not abel to get

Re: problem with mysql threads on freebsd

Greetings! On Tue, 11 Jun 2002, Leo De Geer wrote: > but in my case its not good to have it that way im having one dedikated dual > server for the sql and now im yust using one cpu for the sql questions. i > nead it to start sub conections to the sql to serv all my conections good. In such case p

GRANTs and %

Thanks Dan And Okan for replying to my email but I have tried what you have said but I still get the same problem. GRANT ALL ON newstesting.* 'clients'@'%' IDENTIFIED BY '123'; ERROR 1064: You have an error in your SQL syntax near ''clients'@'%' IDENTIFIED BY '123'' at line 1 GRANT ALL ON newste

RE: Rotating mysqld.log

> From: Ramasubramanian [mailto:[EMAIL PROTECTED]] > Hi, > I tried to flush the logs but still the rotation doesn't happen. > What else could be the problem ?? > I get the same message again > My config file read like this > "/var/log/mysqld.log" { > ro

RE: GRANTs and %

GRANT ALL ON newstesting.* TO 'clients'@'%' IDENTIFIED BY '123'; TO Simon -Original Message- From: Kaan Oglakci [mailto:[EMAIL PROTECTED]] Sent: 11 June 2002 09:05 To: '[EMAIL PROTECTED]' Subject: GRANTs and % Thanks Dan And Okan for replying to my email but I have tried what you ha

Unable to connect to remote mysql server.

Dear all, I hv mysql server running on a remote machine(ip 202.157.188.2) and i'm trying to connect to it by ssh from another machine(ip 202.157.137.97) as follows : $ mysql -h 202.157.188.2 -u root -p Enter password: ERROR 2003: Can't connect to MySQL server on '202.157.188.2' (61) Can you pl

Re: problem with mysql threads on freebsd

On Tuesday 11 June 2002 09.57, Alexander V Zubchenko wrote: > Greetings! > > On Tue, 11 Jun 2002, Leo De Geer wrote: > > but in my case its not good to have it that way im having one dedikated > > dual server for the sql and now im yust using one cpu for the sql > > questions. i nead it to start s

Re: GRANTs and %

On Tue, 11 Jun 2002 09:04:36 +0100 Kaan Oglakci <[EMAIL PROTECTED]> wrote: > Thanks Dan And Okan for replying to my email but I have tried what you have > said but I still get the same problem. > > GRANT ALL ON newstesting.* 'clients'@'%' IDENTIFIED BY '123'; > ERROR 1064: You have an error in y

Re: problem with mysql threads on freebsd

Leo, I believe there was a conversation about this subject several weeks ago, in which the conclusion was that a good reason to use Linux, in preference to FreeBSD, for database servers is that Linux multi-processor support works and FreeBSD doesn't. --Erv sql,query At 09:42 AM 6/11/2002 +0

Re: housekeeping

At 09:45 PM 6/10/2002 -0600, Day Irmiter wrote: >And yet my message comes through from the list. Is >anybody else having this experience? Everybody, I would guess. Two thoughtless subscribers have let their e-mail accounts fall into disuse without unsubscribing. So, when you post, you get the

RE: problem with mysql threads on freebsd

We are ruing a box with freeBSD and MySQL with twin processors It looked like it was using only on processor but we decided that it was the way FreeBSD's threads work? There seems to be two problems with ruing MySQL on FreeBSD. One: Seems not to use both processors (on twin system) Two: All wa

Re: GRANTs and %

On Tuesday 11 Jun 2002 11:04 am, Kaan Oglakci wrote: > Thanks Dan And Okan for replying to my email but I have tried what you have > said but I still get the same problem. > > GRANT ALL ON newstesting.* 'clients'@'%' IDENTIFIED BY '123'; > ERROR 1064: You have an error in your SQL syntax near ''cl

Re: problem with mysql threads on freebsd

On Tuesday 11 June 2002 10.48, Simon Green wrote: > We are ruing a box with freeBSD and MySQL with twin processors > It looked like it was using only on processor but we decided that it was > the way FreeBSD's threads work? > There seems to be two problems with ruing MySQL on FreeBSD. > One: S

Database Error

Hi, the harddisk of the mysql server ran out of space. As it did so somebody tried to write into some tables via the forum. Now there are three tables marked as "still in use". Everything we tried did not work - they are definitely not in use any more. Even the debug mode we could do nothing to

Re: Database Error

Uhm, get a bigger HD stop and move all DB/Files to that and edit your my.cnf file and restart? :) - Original Message - From: "[EFR]The HEAD" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 5:38 PM Subject: Database Error > Hi, > the harddisk of the mysql ser

mysql 3.23.50

where can i get the 3.23.50 packages with innodb support ? Pierre -- sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: mysql 3.23.50

Hi! http://www.mysql.com/downloads/mysql-3.23-pre.html EG > > where can i get the 3.23.50 packages with innodb support ? > > > Pierre > > > > > -- > sql,query > > > - > Before posting, please check: >http://www.mysql.com/m

maximum index size?

Hi, what is the maximum size of .MYI file MySQL can handle, assuming that operating system can handle files bigger that 4G? In the manual there is a section saying about size of the table, but what about indexes? TIA Rafal

replication once again

this is very, very strange if you remember well i was trying to get help with replication problem, i could have not make one of my linux machines a 'slave'. i could have though, make it a 'master'. finally, i have solved my problem - i have recompiled mysql instead of using rpm and now it works!

Re: MySQl price

MySQL, Tuesday, June 11, 2002, 1:10:02 AM, you wrote: MN> I will make a delphi-program that uses MySQL. MN> I want to sell the program, do I have to pay each time I sell a program? MN> Do I have to pay for MySQL? If your program is not under GPL, you should obtain a license. Check also the foll

Re: Cannot use mysql as

9DF12, Monday, June 10, 2002, 8:57:10 PM, you wrote: 9> I have just installed and run my mysql server as the root user. I have 9> entered 9> the MYSQL minitor. WHen I typed 'use mysql', I got the message-- 9> "Error 1044: Access denied fro user: 'root@localhost' to database 9> "mysql'". 9> Same e

Re: GRANTs and %

Kaan, Tuesday, June 11, 2002, 11:04:36 AM, you wrote: KO> Thanks Dan And Okan for replying to my email but I have tried what you have KO> said but I still get the same problem. KO> GRANT ALL ON newstesting.* 'clients'@'%' IDENTIFIED BY '123'; KO> ERROR 1064: You have an error in your SQL syntax

Re: Problem with MyCC download from the mirror site.

Gelu, Monday, June 10, 2002, 9:26:56 PM, you wrote: GG> I wish to download MyCC from mysql official site and i try allmost all the GG> mirroring site.The message is the next: GG> "You are downloading: mycc-0.8.3-src.tar.gz" GG> "There was an error with the mirror site you selected. Please choose

Re: Sql query

sharat, Monday, June 10, 2002, 3:43:58 PM, you wrote: sk> What are the main api's available for Mysql? sk> And what is the meaning of API? sk> And can one use VB with mysql? sk> IS API are used for making connection? You can find description of APIs for MySQL at: http://www.mysql.com/doc/C/

Handling 'one-off' customers wirh MySQL

Hi All, I am developing an application for an online CD-shop using PHP and MySQL and I need to be able to handle 'one-off' customers. This category includes customers who do not want their details to be retained in the shop's database once the order is shipped to them. I am not quite sure whethe

Handling 'one-off' customers with MySQL

Hi All, I am developing an application for an online CD-shop using PHP and MySQL and I need to be able to handle 'one-off' customers. This category includes customers who do not want their details to be retained in the shop's database once the order is shipped to them. I am not quite sure wheth

dumping only selected records into another table

Hi there, I have some data in one table which I have to move to another. No I thought of a mysqldump with a where clause. The problem though is, that it also tryes to insert the ID which is a autoinc. primary key and already in use by another record. How can I produce a insert statement withouth

Re: MySQL AB: Need documentation clarification

Erv, - Original Message - From: "Erv Young" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, June 11, 2002 3:49 AM Subject: MySQL AB: Need documentation clarification > 2) Also, the discussion of ANALYZE TABLE at > http://www.mysql.com/doc/A/N/ANALYZE_TABLE.html lea

Re: MySQL AB: Need documentation clarification

For the mail filter: SQL database - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 2:47 PM Subject: Re: MySQL AB: Need documentation clarification > Erv, > > > - Original Message - > From: "Erv Young" <[EMAIL PROT

RE: when will mysql 4.1 be released?

> I'm implementing a bridge between MySQL and Lotus Domino. > In our application we realy need stored procedures (triggers). > I saw that MySQL does not yet support stored procedures. (This will be > one of the features of version 4.1). Is it worth to wait for version 4.1 > or should we switch t

Re: dumping only selected records into another table

Use the INSERT/SELECT combo like this: INSERT INTO dba (field1,field2,...) SELECT fielda,fieldb,... FROM dba WHERE ... > Hi there, > > I have some data in one table which I have to move to another. No I thought > of a mysqldump with a where clause. The problem though is, that it also > tryes t

Possible bug -- enum element is single space, but this is invalid as default

I have encountered a strange problem with the enum type in version 3.23.49. It may be a bug, but I'd be grateful to hear comments. Here's a short example which illustrates the problem. First, I create a table with an enum column whose allowed elements are single letters, including a single space:

Problems in compiling Mysql-3.23.49. on AIX 4.2

Dear Sir/Madam! I tried compiling the MySQL-3.23.39 on AIX 4.2 but I failed. Attached please find : 1.A script (aixconf) that I used to compile the software: aixconf file. 2.The error messages obtained when running the script: config.log file. 3.OS version: AIX 4.2 0051482C400 I

Reseting auto_incremented id's

Hello everyone, I have a perl script that talks to a mysql database. What I am doing is grabbing a bunch of users of a server and putting them into a table. Then as the script runs on each user I am giving the status of the script as associated with the user. For example user abc will

RE: Reseting auto_incremented id's

[snip] Is there any way to reset this id field to 0 when I am done processing the users? I read this can be accomplished by an myisamchk. But I do not want to have system calls thru my script? Is there any other way to do this? [/snip] TRUNCATE tablename Empties the table and resets the A

RE: MySQl price

Well, I'm under the impression that if the application you're selling provides links to MySQL but not the database itself you don't have to pay for a license for each sale; it's up to the buyer of the app to obtain a MySQL license. I'd sure talk to someone at mysql.com, though. --Walt Weaver B

Re: Unable to connect to remote mysql server.

1. What does this have to do with ssh? 2. Does root@yourmachine have permission to connect to mysqld on 202.157.188.2? ally wrote: > Dear all, > >I hv mysql server running on a remote machine(ip 202.157.188.2) and i'm >trying to connect to it by ssh from another machine(ip 202.157.137.97) as >f

Re: Unable to connect to remote mysql server.

The port number is wrong. Change it to 3306, and u should be fine. :>I hv mysql server running on a remote machine(ip 202.157.188.2) and i'm :>trying to connect to it by ssh from another machine(ip 202.157.137.97) as :>follows : :> :>$ mysql -h 202.157.188.2 -u root -p :>Enter password:

Studying mysql

Hello Listreaders, I'm new on this list and i'm trying to get a mysql database working on my workstation. I work with the Powerpack distribution from Linux Mandrake edition 8.0. For the moment I don't have installed an ethernet card for server facillities. I do everything from the KDE desktop env

on delete cascade

does mysql-max 3.23.50 support the option on delete cascade for the foreign key, the documentation is not very clear on this point Pierre -- sql,query - Before posting, please check: http://www.mysql.com/manual.php (th

RE: on delete cascade

[snip] does mysql-max 3.23.50 support the option on delete cascade for the foreign key, the documentation is not very clear on this point [/snip] No , it does not. Jay sql, mysql, query - Before posting, please check: http

Re: license...

Silmara, Monday, June 10, 2002, 10:19:28 PM, you wrote: SCB> I'm developing a program, that is not free software and i'm using mysql with SCB> myodbc. The question is if i need a license or not... Yes, you need license. Using any of MySQL API's for commercial programs requires licences. Please

Reg. Host Problem in MYSQL

Hi, I installed MySQL from your site.After setup.exe i followed your instructions. When i want to check the installtion by the following command D:\mysql\bin>mysqlcheck -h=pc271 mysql it gives the error. mysqlcheck: Got error: 2005: Unknown MySQL Server Host '=pc271' (11001) when try in

Re: problem with mysql threads on freebsd

In the last episode (Jun 11), Leo De Geer said: > im not abel to get mysql to use more then one thread on my freebsd > 4.5-stable any one having a klue that wrong? Do not assume that the way Linux manages threads is the only one. Mysql on FreeBSD does create threads; they are just not visibl

Re: license...

- Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 10:03 AM Subject: Re: license... | Silmara, | Monday, June 10, 2002, 10:19:28 PM, you wrote: | | SCB> I'm developing a program, that is not free software and i'm usi

Is Table Name 'PURGE' ALLOWED

Does mysql allow you to name your tables anything. I created a table called 'purge' and insert 3 field purgeday, purgemonth, purgeyear. ALL of the fields are set to INT or INT NOT NULL. When I try to add a record to this table I get and error 'SELECT * FROM purge LIMIT 0,50' Anyone have a clu

Re: Is Table Name 'PURGE' ALLOWED

I get the ID-10-T award of the day. http://www.mysql.com/doc/R/e/Reserved_words.html To answer my own question yes this work is reserved. PEBKAC Thank You /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\ Does mysql allow you to name your table

RE: stupid question

I am assuming this is not a MySQL question since MySQL interacts with SQL commands that are all in characters. try using strstream. You can poke just about anything into it and get a string out. If you must have a char*, then use the c_str() function of the string class. The best implementatio

Re: problem with mysql threads on freebsd

Hello Leo De Geer <[EMAIL PROTECTED]>, > the problen nr 2 i dont have but the server we have dont handle the load on > one cpu. at the moment we are runing the sql on a linux instead (same > hardwere) but i sucks. alla auter servers is freebsd and they run mutch beter > Why MySQL on Linux suc

Re: How to set max_connections ?

Hello Steve Katen <[EMAIL PROTECTED]>, How do you tell the number of connections currently in use? On Mon, 10 Jun 2002 18:17:19 -0700 Steve Katen <[EMAIL PROTECTED]> wrote: > what do you mean it doesn't do anything? > > you should be able to set it on the command line as: > > --set-variable=

Re: problem with mysql threads on freebsd

Hello, Out of curiosity--Is this the key reason that Yahoo finance switched from FreeBSD to Linux? :-) \\sql\\ -- Patrick Hsieh <[EMAIL PROTECTED]> GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - Before posting, pl

Re: Reg. Host Problem in MYSQL

Arulmanikandan, Tuesday, June 11, 2002, 5:21:40 PM, you wrote: A>I installed MySQL from your site.After setup.exe i A> followed your instructions. A> When i want to check the installtion by the following A> command A> D:\mysql\bin>mysqlcheck -h=pc271 mysql A> it gives the error. A> m

Re: on delete cascade

Pierre, Tuesday, June 11, 2002, 4:51:16 PM, you wrote: PB> does mysql-max 3.23.50 support the option on delete cascade for the PB> foreign key, the documentation is not very clear on this point Yes, since 3.23.50 MySQL supports ON DELETE CASCADE and ON DELETE SET NULL on InnoDB tables. PB> Pie

Re: Possible bug -- enum element is single space, but this is invalid as

David, Tuesday, June 11, 2002, 3:28:52 PM, you wrote: DH> I have encountered a strange problem with the enum type in version DH> 3.23.49. It may be a bug, but I'd be grateful to hear comments. DH> Here's a short example which illustrates the problem. First, I create DH> a table with an enum colu

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: my

Database renaming?

Hi there, I was wondering if I can rename a MySQL instance (MyISAM) by simple stopping the server and rename the data directory? A quick test did not show any problems. I am now wondering if I can get other problems which I have not encountered so far. Please reply to my mail, I'm no subscriber

RE: Is Table Name 'PURGE' ALLOWED

Hi, > To answer my own question yes this word is reserved. Yes, it is reserved, but you may still use it any query that you like, by quoting the name. To take from the manual: "Note that if the identifier is a restricted word or contains special characters you must always quote it with ` when y

Re: problem with mysql threads on freebsd

On Tuesday 11 June 2002 16.30, Dan Nelson wrote: > In the last episode (Jun 11), Leo De Geer said: > > im not abel to get mysql to use more then one thread on my freebsd > > 4.5-stable any one having a klue that wrong? > > Do not assume that the way Linux manages threads is the only one. > Mys

not able to edit table:((

Hi, I am not able to edit a table: the sql queries i tried are follows: >delete form documents where id = 134;gives the following error: error: table documents is read only repair doesnt seem to work repair table documents; Table Op Mst_typeMsg_text mydb.docume

mysql auto_increment question

Hi all. I have searched the documentation, and i found some info, but I wanted to ask the lsit a little more about auto_increment. First, if I use auto_increment, and then delete a field, I assume mysql leaves the remaining fields with the original numbers... i.e. if I haverows 1 through 10 and

Re: license...

Hi, According to the Arguments document this isn't true. The API's are published under the LGPL license and are not governed by the same restrictions as the server it self. Also regarding GPL'd software. Should you develop software to interface MyODBC or MySQL that is completely up to you. You

Re: not able to edit table:((

Greetings, Stop the MySQL server and check the table files. I think they are read only if you use Win32, or under Linux the user 'mysql' does not have the write right to the tables or its directories In the last case: chmod 660 * and/or chown mysql:mysql * At 12:39 2002.06.11. -0400, you wro

mysqld refusing connections while getting sloooow

Dear list, a friend of mine asked for assistance on the following problem (which I cannot solve myself): He has a mysqld 3.23.38 running on Linux, with 2 cpus (400 MHz celeron) and 512 MB ram. mysqld runs as a production server, with some applications running about 80 queries per second. There a

RE: How to set max_connections ?

Where can I get a sample my.cnf? Thanks, Rekha -Original Message- From: Steve Katen [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 6:17 PM To: Rekha Das; '[EMAIL PROTECTED]' Subject: Re: How to set max_connections ? what do you mean it doesn't do anything? you should be able t

programming for Oracle and Mysql

Dear all: Thanks to those of you who responded to my 'scripts needed' email. Programming for Oracle and MySQL - is the syntax for both of these products VERY different ? Or are they pretty close ? Oracle uses PL/SQL (which I know a bit) but what does MySQL use ? Is it worlds apart from PL/S

Re: not able to edit table:((

The persmissions seems to be ok. ne other ideas!! - Original Message - From: "Kiss Dániel" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 12:59 PM Subject: Re: not able to edit table:(( > Greetings, > > Stop the MySQL server and

Re: Cannot use mysql as

HI, Egor: Thank you very much for your help. I had this MySQL before. NOw it is working after I did as you told. Thanks again! Duo> 9DF12, > Monday, June 10, 2002, 8:57:10 PM, you wrote: > > 9> I have just installed and run my mysql server as the root user. I > have > 9> entered > 9> the MYSQL mi

MySQl and Dot Net

Hi all I need you help can I use MySql database with .Net Freamwork ? I'm programming with VB.Net thnks _ Téléchargez MSN Explorer gratuitement à l'adresse http://explorer.msn.fr/intl.asp. --

RE: MySQl and Dot Net

[snip] Hi all I need you help can I use MySql database with .Net Freamwork ? I'm programming with VB.Net thnks [/snip] Yes, ODBC. HTH! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

Re: mysqld refusing connections while getting sloooow

We've seen very similar behavior when there are very long SQL queries being run that are disk intensive.. generally speaking, something is having to traverse the table (or a temp table) line by line. If he has any logging capability, see long each SQL query is taking to return to his app then cle

RE: How to set max_connections ?

Do I need to have some kind of permissions to change a variable ? Thanks, Rekha -Original Message- From: Steve Katen [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 6:17 PM To: Rekha Das; '[EMAIL PROTECTED]' Subject: Re: How to set max_connections ? what do you mean it doesn't d

query

When I try to make a backup executing the sql: backup tb_name1, tb_name2 to 'c:\temp' and I have a error like "Failed copying .frm file: errno =3D 2" What I have to do in this case. Regards Alexander A busca mais veloz e precisa da internet. Acess

RE: mysqld refusing connections while getting sloooow

I think increasing memory and giving more memory to MySQL would help. Nilesh -Original Message- From: Jared Richardson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 1:48 PM To: Stefan Hinz; [EMAIL PROTECTED] Subject: Re: mysqld refusing connections while getting slw We'v

Errno 13 on starting mysqld (Suse 8)

Errno 13 on starting mysqld I am using SUSE 8.0 on a 586 computer I installed MYSQL 3.23.48 from the Suse-CD (By the while four times) At first I was running (as described in /usr/share/doc/packages/mysql/README.Suse ) "rcmysql start" as root from /var/lib/mysql/ (and later from /usr/bin/) C

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: mysqld refusing connections while getting sloooow

Hi, My opinion is: This is a specific behaviour for tables which are not properly indexed. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Ori

ROOT Access Denied !!

Hi, Try using the following command: mysql -u root -p Where is the name of the database you wish to use. If everything works you will get the password prompt: [root@nms-des root]# mysql -u root -p telefonia Enter password: Then put your root password (by default is null - simply press ent

MySQL DBA wanted

> Sorry for Job posting. Looking at the popularity of MySQL it would be > better if there is separate mailing list for Job Offered/Wanted for > MySQL. > > We are SIP based VoIP company located in Edision,NJ,USA looking for > MySQL DBA with 1-2 years of solid MySQL experience. Experience with

Re: Database renaming?

Any permissions set for users on the database will be invalid. Martin Rode wrote: >Hi there, > >I was wondering if I can rename a MySQL instance (MyISAM) by simple >stopping the server and rename the data directory? A quick test did not >show any problems. I am now wondering if I can get other p

Update problem

Good afternoon! I have a table of subscribers from which I select data to create another table which will indicate which of these subscribers should get a reminder letter. I need to set a column in the subscriber file indicating the date of the reminder, so that the subscriber will not be sent an

Re: mysql auto_increment question

Taylor Lewick wrote: >Hi all. I have searched the documentation, and i found some info, but I wanted to ask >the lsit a little more about auto_increment. > >First, if I use auto_increment, and then delete a field, I assume mysql leaves the >remaining fields with the original numbers... >i.e.

Re: Errno 13 on starting mysqld (Suse 8)

MySQL doesn't own the files. chown -R mysql /var/lib/mysql eh wrote: >Errno 13 on starting mysqld > >I am using SUSE 8.0 >on a 586 computer >I installed MYSQL 3.23.48 from the Suse-CD (By the while four times) > >At first I was running (as described in >/usr/share/doc/packages/mysql/README.Su

Re: not able to edit table:((

The mysql user was not granted write permission on the database? Anil Garg wrote: >The persmissions seems to be ok. >ne other ideas!! >- Original Message - >From: "Kiss Dániel" <[EMAIL PROTECTED]> >To: "Anil Garg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Tuesday, June 11, 2002 12:

security paranoia

i'd like to setup a system that would allow for sensitive information to be encoded (like cc numbers), however having different keys for encoding & decoding the data. found these in the manual, but they use the same pass_str. ENCODE(str,pass_str) Encrypt str using pass_str as the password. To

Re: security paranoia

On Tue, 11 Jun 2002, Ray wrote: > looking for something like > encrypt(str, protected_str) > and > decrypt (crypt_str, private_str) > and probably a make_key_pair() > > its not a vital part of my current project, but i'm sure someone will get > cracked into (again) and then there will be anothe

Re: license...

On Tue, 11 Jun 2002, Colin Faber wrote: > According to the Arguments document this isn't true. The API's are > published under the LGPL license and are not governed by the same > restrictions as the server it self. 3.23.x API is LGPL 4.x is API is GPL 3.23.x and 4.x servers are both GPL Own

Advise Requested: Troubleshooting Perl/Mysql/Sendmail Performance

Hi: I'm hoping you can lend some helping thoughts The system: a perl mailing list tool which accepts add/deletes via emails (sendmail piped) and then updates the backend database accordingly. The problem: once about 10 or more emails arrive, I begin to get performance problems from the Linu

Mysql..Python..& ..MSQLdb

I have been using perl and Mysql together but have decided to try python and Mysql together. I download and extracted MYSQLdb 0.35-1 from Andy Dustman's page. The module does not seen to have instructions for use. Can anyone point me to intructions or examples. My purpose is a user friendly GUI

Re: mysqld refusing connections while getting sloooow

Dear Nilesh, > I think increasing memory and giving more memory to MySQL would help. I will advice my friend to buy more RAM, faster harddisks (good for the hardware industry, too), and to do better indexing :) Thanks! Regards, -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iCon

Re: mysqld refusing connections while getting sloooow

Dear Gelu, > This is a specific behaviour for tables which are not properly indexed. Looks like my friend needs more RAM and better indexing :-) Thanks! Regards, -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iConnect GmbH Heesestr. 6, 12169 Berlin (German

Re: Advise Requested: Troubleshooting Perl/Mysql/Sendmail Performance

On Tue, 11 Jun 2002, Keith Smith (E-mail) wrote: > The system: a perl mailing list tool which accepts add/deletes via > emails (sendmail piped) and then updates the backend database > accordingly. > > The problem: once about 10 or more emails arrive, I begin to get > performance problems from t

Which Language to use

Afternoon We are currently using MySql to drive our web server. We are in the process of pondering the thought of using it for our meat and potatoes applications. The problem/blessing is that our current database is Informix which comes with its own 4gl. In order for us to move to MySql we would

Re: Mysql..Python..& ..MSQLdb

At 16:30 -0400 6/11/02, R Talbot wrote: >I have been using perl and Mysql together but have >decided to try python and Mysql together. > I download and extracted MYSQLdb 0.35-1 from Andy Dustman's page. >The module does not seen to have instructions for use. Can anyone point >me to intructions or

Re: ROOT Access Denied !!

Add -p to the command line. [localhost:/Users/cooldaze] root# mysql -p On Tuesday 11 June 2002 09:30, Colin Cooler wrote: > 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 pas

Re: Mysql..Python..& ..MSQLdb

I haven't used Python...I use PHP and MySQL...I've found PHP does everything I have asked it to do (and I have a lot more to work with). And, it has been incredibly easy to pick up and use. - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "R Talbot" <[EMAIL PROTECTED]>; <[

MySQLHost? What MySQLHost?

Hi, OK - Here's plain text. I don't know anybody else that uses it, so let's see if you accept it THIS time! I have a network made up of two PCs, one is Win98 and the Server is Linux. I am not using NIS, preferring to use "host" instead. I can ping each machine at either end and Samba works just

  1   2   >