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
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
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
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
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
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
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
#
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:
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
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
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
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
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
-
;
> 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
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'
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
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
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
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
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
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
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
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
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
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
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
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
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
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
>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
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
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
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
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
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
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
> 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
-
;;
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
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
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
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
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
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
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
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
45 matches
Mail list logo