TTBMK, there is no such thing as 'auto flush' in MySQL.
When you say "Everytime I add some record on my local computer then upload
..." are you saying you upload the raw database files (from your data
directory), or are you inserting/updating the data in your Linux databases
with a query?
If you
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
#
Andrew,
Not trying to be a smart-ass, but give this link a try from the Mysql
website. Most likely covers your situation.
http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html
Don
-Original Message-
From: Andrew Rich [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 3:18 P
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
> 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
-
The password starts off as nothing
i.e on a fresh install you dont need to supply a password,
another way to set the password is to log in
, switch to the mysql database (use mysql;) and issue these queries
UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
FLUSH PRIVILEGES;
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
