Hi!
Peter == Peter Lauri [EMAIL PROTECTED] writes:
Peter Best group member,
Peter My computer stopped working. And I was able to install Windows on another
Peter partition and now I face one problem. I was running Windows with MySQL
4.1.
Peter I have all C: working, and can access all files.
I did something very stupid: I locked myself out of the
MySQL server (all accounts, incl administrator)...
My problem: I use MySQLFront to change the allowed
hosts and did it for all users. They were 'localhost'
and I set them to 'localhost; EcolMod1' where the
EcolMod1 is the name of
restart mysql with the skip-grants option
-Original Message-
From: Rainer M. Krug [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 3:03 AM
To: [EMAIL PROTECTED]
Subject: Urgent problem
Hi
I did something very stupid: I locked myself out of the
MySQL server (all accounts,
Neither of these two machines send the request.
I have 12 webservers, which send the requests.
I have 5 database servers, 1 master(for updates/inserts/deletes) and 4
slaves(for selects).
Machine A below was the current Master DB server, however it is old and was
being replaced by machine B
--
When you said you modified the scripts, are these the scripts on the 12
webservers (mysql clients) ?
If not, then these mysql clients (webservers) would still be wanting to send
to IP addres 192.168.1.71 as configured for php or in your client.
Best regards
Nils Valentin
Tokyo/Japan
2003 6
Hi Keith,
from your last e-mail I understand now finally that we are talking about
replication here. Would have been a short cut to mention it in your first
e-mail.
The failed login attempts couldn't be from your slaves trying to login, but
you havent set them up on the master yet ?
Just a
, June 27, 2003 1:30 PM
Subject: Re: URGENT problem with mysql processes
Hi Keith,
from your last e-mail I understand now finally that we are talking about
replication here. Would have been a short cut to mention it in your first
e-mail.
The failed login attempts couldn't be from your slaves trying
No, the slaves replicate fine and I can see their entries in the processlist
normally (as their hostname), not as unauthenticated user..
--
Keith Bussey
Wisol, Inc.
Chief Technology Manager
(514) 398-9994 ext.225
Quoting Nils Valentin [EMAIL PROTECTED]:
Hi Keith,
from your last e-mail I
Subject: Re: URGENT problem with mysql processes
Hi Keith,
from your last e-mail I understand now finally that we are talking about
replication here. Would have been a short cut to mention it in your first
e-mail.
The failed login attempts couldn't be from your slaves trying to login
Quoting Nils Valentin [EMAIL PROTECTED]:
When you said you modified the scripts, are these the scripts on the 12
webservers (mysql clients) ?
Yes, when I mention modifying my scripts, I mean the scripts/pages on the 12
webservers
If not, then these mysql clients (webservers) would still be
Hi Keith,
The wrong IP address could only avoid a client to connect to the database
server.
If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in
config.inc.php or which ever tool you use than of course it will try to
connect to this IP address.
Best regards
Nils
My guess. . .
I have seen this problem with other databases . . . don't know if it is
true for MySQL as well. Try to change to your field definition to
float(5,2) as it may be counting the (.) as part of your field size.
So if you number is xx.xx you will need 5,2. 4,2 would give you xx.x
Hi Shankar,
This is your old buddy Scott S.
Try order by rather than group byThis will get you what you are looking
for
Scott Salisbury
- Original Message -
From: SankaraNarayanan Mahadevan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 16, 2002 3:42 PM
On Sat, Jul 14, 2001 at 01:04:41AM +0200, Fournier Jocelyn [Presence-PC] wrote:
Hi,
I'm administrating a machine which has just badly crashed, and a MYI
file has disappeared for one table. Is this possible to repair this
table?
Try to touch the file (to create an empty one), and see if
14 matches
Mail list logo