Hello.
Have you changed InnoDB log file sizes? See:
http://dev.mysql.com/doc/mysql/en/adding-and-removing.html
Manual says that you have to stop mysql, then change the parameter in my.cnf,
then I moved to another directory the log file just to be cautious, and then
restarted mysql
Hamm [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 02, 2005 8:06 AM
To: Nguyen, Phong
Cc: mysql@lists.mysql.com
Subject: Re: mysqladmin Shutdown fail
If you got password set for root, try c:\mysql\bin\mysqladmin -u root -p
it should prompt for password.
On 8/2/05, Nguyen, Phong < [EMAIL P
Hello.
See:
http://dev.mysql.com/doc/mysql/en/access-denied.html
"Nguyen, Phong" <[EMAIL PROTECTED]> wrote:
> I used command: c:\mysql\bin\mysqladmin -u root shutdown
> and I got error :
>
> mysqladmin: connect to sever at 'localhost' fail
> error 'Access denied for user 'root'@ 'loc
long as you live, keep learning how to live !!
-Original Message-
From: Nguyen, Phong [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 02, 2005 5:31 PM
To: mysql@lists.mysql.com
Subject: mysqladmin Shutdown fail
I used command: c:\mysql\bin\mysqladmin -u root shutdown and I got error
If you got password set for root, try c:\mysql\bin\mysqladmin -u root -p
it should prompt for password.
On 8/2/05, Nguyen, Phong <[EMAIL PROTECTED]> wrote:
>
> I used command: c:\mysql\bin\mysqladmin -u root shutdown
> and I got error :
>
> mysqladmin: connect to sever at 'localhost' fail
> er
I used command: c:\mysql\bin\mysqladmin -u root shutdown
and I got error :
mysqladmin: connect to sever at 'localhost' fail
error 'Access denied for user 'root'@ 'localhost' (using password: NO)
Does anyone know why? Please share with us.
Thankyou..Phong
--
MySQL General Mailing List
For l
own the mysql process by using mysqladmin shutdown option. However
> this command hangs and does not complete. =20
What is the kind of the communication breakdown: a temporary one or the array
goes offline forever?
In the later case MySQL will hang until disk is available to flush data. You
can kill
On Thu, 8 Jul 2004 [EMAIL PROTECTED] wrote:
> I am happy even if mysqladmin reports that mysqladmin shutdown has
> failed instead of hanging so that I can kill/stop the process using
> cruder methods.
I am about 99.9% sure that all gentle methods of stopping mysqld will
fail; it'
Are you able to communicate with the database server at all. Login, query,
etc.?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 7/7/04 11:38 PM
Subject: mysqladmin shutdown command hangs
Hello:
We are using mysql 4.0.17 on Linux
We have installed a mysql
happy even if mysqladmin reports that mysqladmin shutdown has
failed instead of hanging so that I can kill/stop the process using
cruder methods.
Thanks again,
Ravi
-Original Message-
From: Charles Sprickman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 07, 2004 10:07 PM
To: Ravi T
ess by using mysqladmin shutdown option. However
> this command hangs and does not complete.
I would imagine it would continue to hang until the array becomes
available. It's probably in "disk wait" state, since mysql wants to
do a clean shutdown, which I'm sure requires it
shutdown option. However
this command hangs and does not complete.
We tried the --force option also with the mysqladmin shutdown command,
but it still hung.
Does anybody have any suggestion/solution.
Thanks,
Ravi
t. Problem was, and I
am not sure if it is related to it, but when restarting, it wasn't
recreating the /var/lib/mysql/mysql.sock file. Strange though because I
could run the mysqladmin shutdown on the command line and then the
init.d/mysqld start and everything worked just fine. It was onl
Hi all.
Hi spam filter. SQL. Query.
MySQL versions 4.0.3, 4.0.4 and 4.0.5 all have the following problem...
When I use 'mysqladmin shutdown', 2 processes are left running and can
only be killed with a 'kill -9 '.
At midnight I run a script which backs up each database and then
Hi all.
This is a re-post of a problem I originally had under MySQL-4.0.3, which
I thought might be due to me compiling with K6 flags, but I have
recompiled using i686 flags (and using MySQL-4.0.4) and still get stray
processes running:
bash-2.05# ps ax | grep mysql
11565 ?S< 0:00
Eric Lamendola wrote:
> Hey,
>
> I thought you could just use
>
> mysqladmin refresh -pPASSWORD -- or
> mysqladmin reload -pPASSWORD
>
> To kickstart logging again?
>
> If not - hey, what do I know
>
> Eric Lamendola
>
Yeah that only restarts the binary log. I like to have a human-readable
log
for a week or so now, and
>have noticed that the command:
> mysqladmin shutdown -ppassword
>doesn't shut down all mysql processes.
>I use the following script to backup our database and restart mysql:
>
>---
>cd /root/sql/backups
>for I in EnergyShop NUS ebills irm m
Hi all.
I've been using MySQL-4.0.3 (on Slackware-8.0) for a week or so now, and
have noticed that the command:
mysqladmin shutdown -ppassword
doesn't shut down all mysql processes.
I use the following script to backup our database and restart mysql:
---
cd /root/sql/backup
I just installed mysql-3.23.43-apple-darwin1.3.1 on my OS X (10.1) machine.
When I use the "mysqladmin shutdown" command, the command seems to hang.
Running top in a separate terminal window shows both the server and the
mysqladmin process as still running.
Is this a kno
>Description:
When the system is loaded down and using the max number of connections,
if you do a mysqladmin shutdown, it kills all the mysql processes except
a few. One of the mysqld processes uses 100% cpu and writes this out
to the log file continuou
I can run mysqld by the book on MacOS X but trying to shut it down with "mysqladmin -u
root -p shutdown" timeout after a long time, leave the daemon running... What can I do
?
TIA
Greg
-
Before posting, please check:
http:/
21 matches
Mail list logo
