Re: Mysql Linux can't auto flush-tables

2004-04-07 Thread Gerald R. Jensen
CTED]> Sent: Tuesday, April 06, 2004 8:23 PM Subject: Mysql Linux can't auto flush-tables > Hi, > > I have problem with Mysql 3.23.58 on Linux > Mysql can't auto Flush-Tables > > I work with Mysql 3.23.58 windows version on my local computer... > Then I upload

Mysql Linux can't auto flush-tables

2004-04-06 Thread starofframe
Hi, I have problem with Mysql 3.23.58 on Linux Mysql can't auto Flush-Tables I work with Mysql 3.23.58 windows version on my local computer... Then I upload to web-hosting that working with Mysql 3.23.58 on Linux.. Everytime I add some record on my local computer then upload to web-hosti

MySQL, linux, ia32, >4GB RAM

2003-07-10 Thread Andy Stubbs
Hi, I wonder if anybody here is using MySQL (3.23.56?) on a linux/intel ia32 (e.g., Xeon) with more than 4 GB RAM? Did you find a performance enhancement? With PAE mode on? How does this affect MySQL - being a multithreaded process, is there any benefit in having all that extra memory as anything

AW: AW: mysql linux user

2003-06-09 Thread Dingfelder Andy
Ursprungliche Nachricht- > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Gesendet: Samstag, 7. Juni 2003 18:48 > Cc: [EMAIL PROTECTED] > Betreff: Re: AW: mysql linux user > > > Dingfelder Andy schrieb: > > >Hi, > > > >I?ve forgot to say, that i?m a newb

Re: AW: mysql linux user

2003-06-07 Thread [EMAIL PROTECTED]
Dingfelder Andy schrieb: Hi, I?ve forgot to say, that i?m a newbie to linux. So, what do you want to say, with these lines? That the 'mysql' user is not a shell user? yes i am no expert too a daemon should run as a unprivileged user, if possible # ps auxw | less for this you need an account t

AW: mysql linux user

2003-06-07 Thread Dingfelder Andy
17:01 > An: [EMAIL PROTECTED] > Betreff: Re: mysql linux user > > > Dingfelder Andy schrieb: > > Hello, > > > > if I install mysql under linux, there is a user created calld 'mysql'. > > My question is, whether this user has a default pas

Re: mysql linux user

2003-06-06 Thread [EMAIL PROTECTED]
Dingfelder Andy schrieb: Hello, if I install mysql under linux, there is a user created calld 'mysql'. My question is, whether this user has a default password, which should be changed to avoid security problems? # grep mysql /etc/passwd mysql:x:27:27:MySQL Server:/var/lib/mysql:/sbin/nologin #

mysql linux user

2003-06-06 Thread Dingfelder Andy
Hello, if I install mysql under linux, there is a user created calld 'mysql'. My question is, whether this user has a default password, which should be changed to avoid security problems? Regards Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: A question about using C API in mysql (linux platform)

2003-04-03 Thread Martin
tin - Original Message - From: "Li Yang" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Thursday, April 03, 2003 7:32 PM Subject: A question about using C API in mysql (linux platform) Hi, I'm a newbie to MySQL Now I am using C to connect mysql

A question about using C API in mysql (linux platform)

2003-04-03 Thread Li Yang
Hi, I'm a newbie to MySQL Now I am using C to connect mysql in Linux The heaser souce code like: #include #include #include and After I use "gcc test.c -L /usr/local/mysql/lib/ -shared " to compile it , and when I run the a.out ,it always say that "Segmentation Fault

Future outlook: MySql + Linux and 2gig ram limit..

2003-02-14 Thread xing
Hi, I am wondering if the MySQL staff have been working on a way to circumvent the current 2G ram usage limit for MySQL under LInux for maybe the 5.0 release? Did a list search but did not find a thread regarding this matter so I want to get this question out of my system. With the rising nee

RE: Random ID creation in MySQL /Linux

2003-01-19 Thread Daevid Vincent
Original Message- > From: DIetrich Speer [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 19, 2003 6:26 PM > To: [EMAIL PROTECTED] > Subject: Random ID creation in MySQL /Linux > > > Hello: > I am trying to find a way to create a random ID for use as a > session

Random ID creation in MySQL /Linux

2003-01-19 Thread DIetrich Speer
Hello: I am trying to find a way to create a random ID for use as a session ID in a MySQL table. In MS SQL I use NewID(). Does anybody know an equivalent to use for MySQL, running on RedHat Linux 8.0? I'd be greatful for any tip. thks! Dietrich -

RE: MySQL - Windows vs MySQL Linux

2002-11-05 Thread John Ragan
; > Regards > > Kevin > > -Original Message- > From: John Ragan [mailto:jragan@;arkansas.net] > Sent: 05 November 2002 19:22 > To: Mysql (E-mail); Kevin Passey > Subject: Re: MySQL - Windows vs MySQL Linux > > > > you've insured that you

RE: MySQL - Windows vs MySQL Linux

2002-11-05 Thread Kevin Passey
field names it works fine on both platforms Thanks for your help Regards Kevin -Original Message- From: John Ragan [mailto:jragan@;arkansas.net] Sent: 05 November 2002 19:22 To: Mysql (E-mail); Kevin Passey Subject: Re: MySQL - Windows vs MySQL Linux you've insured that you'

RE: MySQL - Windows vs MySQL Linux

2002-11-05 Thread Black, Kelly W [PCS]
John Ragan [mailto:jragan@;arkansas.net] Sent: Tuesday, November 05, 2002 11:22 AM To: Mysql (E-mail); Kevin Passey Subject: Re: MySQL - Windows vs MySQL Linux you've insured that you're not simply encountering a problem with case sensitivity ? windows is not case sensitive. > Hi all

Re: MySQL - Windows vs MySQL Linux

2002-11-05 Thread John Ragan
you've insured that you're not simply encountering a problem with case sensitivity ? windows is not case sensitive. > Hi all, > > I have a problem - I've built some JSP which runs ok on a windows install of > MySQL, but on a Linux install of MySQL only the update part works. > > Here is wha

MySQL - Windows vs MySQL Linux

2002-11-05 Thread Kevin Passey
Hi all, I have a problem - I've built some JSP which runs ok on a windows install of MySQL, but on a Linux install of MySQL only the update part works. Here is what it does - SELECT date, clicks FROM bsafeLinks WHERE date = DATE INSERT INTO bsafeLinks (date,clicks) VALUES (CURDATE(),'0') UPD

Re: New User: Installing MySQL - Linux Mandrake ?

2002-05-28 Thread Victoria Reznichenko
pmoscatt, Tuesday, May 28, 2002, 2:23:00 AM, you wrote: p> I am new to mysql and having trouble understanding the installation procedures for linux (Mandrake). p> I have downloaded the "mysql-3.23.49a-pc-linux-gnu-i686.tar.gz" and unpacked it in /usr/local as root. p> I then issued the followin

New User: Installing MySQL - Linux Mandrake ?

2002-05-27 Thread pmoscatt
I am new to mysql and having trouble understanding the installation procedures for linux (Mandrake). I have downloaded the "mysql-3.23.49a-pc-linux-gnu-i686.tar.gz" and unpacked it in /usr/local as root. I then issued the following commands as per the install procedures: groupadd mysql us

RE: MYSQL Linux

2002-04-25 Thread Whitlow, Don
PM To: [EMAIL PROTECTED] Subject: MYSQL Linux Dear Experts > >When ever i try to run MySQL under linux it gives me following error > >ERROR 2002 : can't connect to local MYSQL server through socket '/var/lib/mysql.sock' (111) > >what could be possible

MYSQL Linux

2002-04-25 Thread Andrew Rich
Dear Experts > >When ever i try to run MySQL under linux it gives me following error > >ERROR 2002 : can't connect to local MYSQL server through socket '/var/lib/mysql.sock' (111) > >what could be possible remedy/rectification of the above ? > >million thx in advance

Re: MYSQL,Linux & large threads number

2002-03-18 Thread Bill Davidsen
On Fri, 15 Mar 2002, Peter Zaitsev wrote: > Hello mysql, > > Some time ago I wrote about slow down of mysql with large number of > threads, which is quite common in Linux-Apache-Mysql-PHP enviroment. > > The test was simulating the worst case of concurrency - all the > threads are modif

Re: MYSQL,Linux & large threads number

2002-03-15 Thread Sinisa Milivojevic
Peter Zaitsev writes: > Hello mysql, > > Some time ago I wrote about slow down of mysql with large number of > threads, which is quite common in Linux-Apache-Mysql-PHP enviroment. > > The test was simulating the worst case of concurrency - all the > threads are modified global variable i

MYSQL,Linux & large threads number

2002-03-15 Thread Peter Zaitsev
Hello mysql, Some time ago I wrote about slow down of mysql with large number of threads, which is quite common in Linux-Apache-Mysql-PHP enviroment. The test was simulating the worst case of concurrency - all the threads are modified global variable in a loop 500 times in total, u

M$ Access and MySQL (Linux)

2002-02-01 Thread Jeremy McNamara
I have just started playing with MySQL about a week ago. I have read as much as I can about optimizing the performance of MySQL and believe I have everything setup according to the documenation i've read and am very skilled at Linux. When we attempt to link a table from MySQL, using the MyODBC d

Re: Faking MS Access on MySQL linux box

2001-11-09 Thread Bill Adams
mweb wrote: > Thanks for the shameless plug, I'll look into your code. However, > shouldn't something like what I want be possible in PHP with ODBC? Yes, you can install UnixODBC or similar and use the odbc_* calls in PHP on both os's. I just do not know how reliable ODBC is on the *nix. b. my

Re: Faking MS Access on MySQL linux box

2001-11-09 Thread mweb
Thanks for the shameless plug, I'll look into your code. However, shouldn't something like what I want be possible in PHP with ODBC? mweb On Fri, Nov 09, 2001 15:22:11 at 03:22:11PM -0800, Bill Adams wrote: > mweb wrote: > > > >mweb, > > > To make sure I understand you correctl

Re: Faking MS Access on MySQL linux box

2001-11-09 Thread Bill Adams
mweb wrote: > >mweb, > > To make sure I understand you correctly, you want to create > >and > >test your PHP/MySQL database on your Linux/Apache box, then upload it > >to > >your ISP server that is running PHP/Access? I'm sorry but that's not > >going > >to work. You can't transparently s

Re: Faking MS Access on MySQL linux box

2001-11-09 Thread mweb
>mweb, > To make sure I understand you correctly, you want to create >and >test your PHP/MySQL database on your Linux/Apache box, then upload it >to >your ISP server that is running PHP/Access? I'm sorry but that's not >going >to work. You can't transparently switch a PHP application from

Faking MS Access on MySQL linux box

2001-11-09 Thread [EMAIL PROTECTED]
Hello, I have another question about the situation explained in my other message "Keeping SQL DBs separated". If it's not possible reconfigure SQL on the ISP server, then I will have to test on Linux/Apache some PHP/MySQL pages that will have to access via ODBC a MS Access database on an NT/IIS

ERROR rotating logs problem in MySQL(Linux)

2001-08-08 Thread Mike Yuen
I'm pretty new to the Linux world and i'm getting the following error: errors occured while rotating /var/log/mysqld.log mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' erorr running prerotate script -- leaving old in place Does anyone know ho

RE: Help required for OLEDB on win32 for MySQL(linux)

2001-07-30 Thread Bruce Stewart
Asit, Did you ever solve your problem? - I have the same... Bruce -Original Message- From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]] Sent: Thu, 07 June 2001 21:42 To: asit; [EMAIL PROTECTED] Subject: Re: Help required for OLEDB on win32 for MySQL(linux) At 20:56 07/06/2001

Re: PLEASE help me!! MySQL Linux Problem

2001-07-18 Thread Mike Baranski
Read the man page for gcc and note the command line switch to point the linker at specific libraries, then use those switches on the command line. This is a linker error, rather than a compiler error: Example: g++ myGreatProgram.cpp -L/usr/mysql/lib -lmysqlclient On Wednesday 18 July 2001 1

PLEASE help me!! MySQL Linux Problem

2001-07-18 Thread David Ayliffe
I am having A LOT of trouble compiling the code Simple1.cc which comes with the C++ API for Linux I have extracted the API to a directory in /root/ and MySQL is installed and works in /usr/local/mysql PLEASE someone please help me compile just this simple program. What am I missing? When I co

Re: Getting more than 256 connections with MySQL/Linux

2001-07-15 Thread Tonu Samuel
Alex Coke-Smyth wrote: > max_connections=300 > > basically anything over 256 ends up giving the error : > > Can't create a new thread (errno 11). If you are not out of available > memory, you can consult the manual for a possible OS-dependent bug > > after 256 connections are open. > > The

RE: MySQL + Linux

2001-06-27 Thread Chris Bolt
> Hi! > > Does anybody know how do i change the 'root' password for mysql server? > > I installation guide they say that it's done by typing > '/usr/local/bin/mysqladmin -u root -p password new-password', but how > would i know the old passsword? > Am i mising anything? Leave out -p -

RE: MySQL + Linux

2001-06-27 Thread sean . odonnell
;; FLUSH PRIVILEGES; -Original Message- From: Oscar E. Salninch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 9:04 AM To: MySQL Discussions Subject: MySQL + Linux Hi! Does anybody know how do i change the 'root' password for mysql server? I installation guide the

MySQL + Linux

2001-06-26 Thread Oscar E. Salninch
Hi! Does anybody know how do i change the 'root' password for mysql server? I installation guide they say that it's done by typing '/usr/local/bin/mysqladmin -u root -p password new-password', but how would i know the old passsword? Am i mising anything? Thanks for helping! By the way, i'm fre

Re: Help required for OLEDB on win32 for MySQL(linux)

2001-06-07 Thread Miguel Angel Solórzano
At 20:56 07/06/2001 +0530, asit wrote: Hi, Please take a look on the help file, where you should find that your connection string is wrong. You find the instructions of the connection string just below of Overview item. server=192.168.100.101 ? Regards, Miguel >Hi, > >I am facing problem whil

Help required for OLEDB on win32 for MySQL(linux)

2001-06-07 Thread asit
Hi, I am facing problem while connecting to MYSQL server (linux) from Win32 VB client through OLEDB provider from MYSQL. I am successfully connecting to server through MyODBC using DSN but unable to connect to through OLEDB provider ( downloaded from www.MYSQL.com) Following is the script in

Getting more than 256 connections with MySQL/Linux

2001-06-06 Thread Alex Coke-Smyth
Hi, I am receiving errors when setting max_connections=300 basically anything over 256 ends up giving the error : Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug after 256 connections are open. There is

Re: MySQL, Linux and Hardware config

2001-02-26 Thread William R. Mussatto
ocess data...just a thought. Check /proc/sys/fs/file-nr You must be root to chane this. On Mon, 26 Feb 2001, Joseph Bueno wrote: > Date: Mon, 26 Feb 2001 13:56:52 +0100 > From: Joseph Bueno <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: mysql <[EMAIL PROTECTED]> &g

Re: MySQL, Linux and Hardware config

2001-02-26 Thread Joseph Bueno
Mohamed Sadok MOUHA a écrit : > > We plan to use MySQL in a database of more than 200 000 client. > Every client has about 1000 bytes of information (stored in 40 fields). > The number of simultaneos connections could reach 1000. > With such environment, what di you requires as OS? Do

MySQL, Linux and Hardware config

2001-02-26 Thread Mohamed Sadok MOUHA
We plan to use MySQL in a database of more than 200 000 client. Every client has about 1000 bytes of information (stored in 40 fields). The number of simultaneos connections could reach 1000. With such environment, what di you requires as OS? Does Linux RH 6.2 is ok? Does MySQL is also