Subject: mysqlimport --use-threads / mysqladmin processlist
I'm in the middle of migrating an InnoDB database to an NDBCluster. I
use mysqldump to first create two dumps, the first one contains only
the database schema, the second one contains only tab delimited data
(via mysqldump --tab). I
[mailto:kohanyi.rob...@gmail.com]
Sent: Tuesday, July 24, 2012 10:52 AM
To: mysql@lists.mysql.com
Subject: mysqlimport --use-threads / mysqladmin processlist
I'm in the middle of migrating an InnoDB database to an NDBCluster. I
use mysqldump to first create two dumps, the first one contains only
, etc.) import it and after this I import
the InnoDB data *as is* using mysqlimport.
I use it like this:
mysqlimport --local --use-threads=4 db dir/*.txt
(dir of course cotains the tab delimited data I dumped before.)
The import starts, and I check its progress via mysqladmin, like
- Original Message -
From: Brent Clark brentgclarkl...@gmail.com
I was wondering. Is there anyway Mysql can be monitored for when you
need to run mysqladmin flush-hosts?
You'd only need to run that when the DNS entries for a client changes, so it's
not really a mysql monitoring
Hiya
I was wondering. Is there anyway Mysql can be monitored for when you need to
run mysqladmin flush-hosts?
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi,
¶¼ÊÇÖйúÈ˾Í˵ÖÐÎÄ°É^_^
Nice to meet you. But I think that this newsgroup is for the people who come
from all of the world. So post topics in English is better for anyone who is
also interested about this topic, right?
Ã÷Ìì»á¸üºÃ
I like this sentence.
Dear all,
I have installed the MySQL version 5.1.50 with complete installation. After
the installation process is finished and the configuration is done, when I
run 'mysqladmin' with option 'version' in prompt, I got the following error
message:
--
C:\Program Files
On 2010年09月24日 16:11, Ma Xiaoming wrote:
Dear all,
I have installed the MySQL version 5.1.50 with complete installation. After
the installation process is finished and the configuration is done, when I
run 'mysqladmin' with option 'version' in prompt, I got the following error
message
Hi,
As the console print,do you enter the password for user ODBC correctly?
How to correctly use this console application, that is how to pass password
when calling this console application? Thanks.
ODBCÓû§ÃÜÂë²»¶Ô£¬ËµµÄºÜÃ÷ÏÔ.
On 9/24/2010 4:11 AM, Ma Xiaoming wrote:
Dear all,
I have installed the MySQL version 5.1.50 with complete installation. After
the installation process is finished and the configuration is done, when I
run 'mysqladmin' with option 'version' in prompt, I got the following error
message
Hi Shawn,
You forgot to use -- before the option version. Try this instead
mysqladmin --version
Let us know your results.
Oh yes, it works. When I typed the right command: mysqladmin --version
I got the following result: mysqladmin Ver 8.42 Distrib 5.1.50, for Win32 on
ia32
Many thanks
都是中国人就说中文吧^_^
明天会更好
On Sat, Sep 25, 2010 at 9:21 AM, Ma Xiaoming maxiaoming10...@hotmail.comwrote:
Hi Shawn,
You forgot to use -- before the option version. Try this instead
mysqladmin --version
Let us know your results.
Oh yes, it works. When I typed the right command
太搞笑了,哈哈
2010/9/25 Neo neocana...@gmail.com
都是中国人就说中文吧^_^
明天会更好
On Sat, Sep 25, 2010 at 9:21 AM, Ma Xiaoming maxiaoming10...@hotmail.com
wrote:
Hi Shawn,
You forgot to use -- before the option version. Try this instead
mysqladmin --version
Let us know your results
Hi,I'm using mysql5.4-beta now.when I use flow command ,it does not works,is
mysql5.4 bug?
The command
mysqladmin -p -r --sleep=1 --count=100 extended-status
It run only one time.
Thanks!
-邮件原件-
发件人: mos [mailto:mo...@fastmail.fm]
发送时间: 2009年5月18日 2:14
收件人: mysql@lists.mysql.com
主
I am using WinXP.I am wanted to shutdown MySQL service from the command line
and ran the command mysqladmin -p root shutdown next the root password was
asked for,I entered the correct password, when I entered the password the
below displayed error was the result
mysqladmin: connect to server
Varuna Seneviratna írta:
I am using WinXP.I am wanted to shutdown MySQL service from the command line
and ran the command mysqladmin -p root shutdown next the root password was
asked for,I entered the correct password, when I entered the password the
below displayed error was the result
Hi Varuna,
I think you're missing the -u option (User for login if not current user.)
Try: mysqladmin -u root -p shutdown
(-p without a value indicates to prompt for a password from the terminal.)
Andy
Varuna Seneviratna wrote:
I am using WinXP.I am wanted to shutdown MySQL service from
Hi Varuna,
The problem looks like it is with the command you issued. The correct
syntax is:
mysqladmin -uroot -p shutdown
then supply root password.
Without giving the -uroot argument, it doesn't know that you are trying
to log in as the root user, which is why it is telling you that access
server Do I have to open another console window and do what?
Thanks Varuna
On Sat, Oct 4, 2008 at 2:19 PM, Ian Simpson [EMAIL PROTECTED] wrote:
Hi Varuna,
The problem looks like it is with the command you issued. The correct
syntax is:
mysqladmin -uroot -p shutdown
then supply root
At 12:12 PM -0400 6/12/07, Ofer Inbar wrote:
We run a mysqladmin flush-logs from cron every night. This causes our
server to start a new binary log. However, the slow query log does
not get flushed - our server continues updating the same slow query
log file.
If I run mysql and then issue
We run a mysqladmin flush-logs from cron every night. This causes our
server to start a new binary log. However, the slow query log does
not get flushed - our server continues updating the same slow query
log file.
If I run mysql and then issue a flush logs command, it flushes the
binary logs
Don't include the password, let mysql prompt for it. ' ./bin/
mysqladmin -u root password -p '.
Daniel Culver
[EMAIL PROTECTED]
On Jan 17, 2007, at 7:57 PM, Mariella Petrini wrote:
./bin/mysqladmin -u root password '***'
./bin/mysqladmin: connect to server at 'localhost' failed
running the optimized version of mysqld I am not able to
connect and set the root password.
./bin/mysqladmin -u root password '***'
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
The same
Hi,
I work under Mandrake 10.1
First, I have a .my.cnf, which works quite well, since I can enter mysql
without entering any password.
Even mysqladmin works !
But, I have a batch process run by crontab as root, which tests if mysql is
running (mysqladmin version --silent).
Unfortunately
Marc MENDEZ wrote:
Hi,
I work under Mandrake 10.1
First, I have a .my.cnf, which works quite well, since I can enter mysql
without entering any password.
Even mysqladmin works !
But, I have a batch process run by crontab as root, which tests if mysql
is running (mysqladmin version --silent
Marc MENDEZ wrote:
Hi,
For mysqladmin, this parameter does not exist. I'll try anyway by
forcing password and user on the command line.
I'll check tomorrow.
Sure it does.
$ mysqladmin --help | grep extra
--defaults-extra-file=# Read this file after the global files are read
--
MySQL
nicely
1:MySQL-server-standard ### [100%]
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h
: critical
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-5.0.22-standard (MySQL Community Edition - Standard (GPL))
Server: /usr/bin/mysqladmin Ver 8.41 Distrib 5.0.22, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
should find a program called WinMySQLadmin, located in mysql/bin.
First, this program is nowhere to be found (used start/find but nothing) I
did however find the program MySQLadmin. Since WinMySQLadmin isn't there I
thought it might work if I use the MySQLadmin program instead. According
and mysql for dummies (I'm a newbee) I
should find a program called WinMySQLadmin, located in mysql/bin.
First, this program is nowhere to be found (used start/find but nothing) I
did however find the program MySQLadmin. Since WinMySQLadmin isn't there I
thought it might work if I use
According to the Mysql online manual, to reset a root password one
procedure is to issue the command:
./mysqladmin --skip-grant-tables
to have full access to the database and update the root password as per
the instructions in the manual.
My problem is when I issue the command
./mysqladmin
Alfred Vahau wrote:
According to the Mysql online manual, to reset a root password one
procedure is to issue the command:
./mysqladmin --skip-grant-tables
to have full access to the database and update the root password as per
the instructions in the manual.
My problem is when I issue
Michael Stassen wrote:
Alfred Vahau wrote:
According to the Mysql online manual, to reset a root password one
procedure is to issue the command:
./mysqladmin --skip-grant-tables
to have full access to the database and update the root password as
per the instructions in the manual.
My
I need to run `mysqladmin version` from a remote host, on the same LAN, what
are the min permissions for a user I need to set up to get this data?
--
-
Scott HanedaTel: 415.898.2602
http://www.newgeo.com
At 16:33 -0800 12/9/05, Scott Haneda wrote:
I need to run `mysqladmin version` from a remote host, on the same LAN, what
are the min permissions for a user I need to set up to get this data?
No permissions are necessary, you just need an account that has no privileges.
The account needs only
wrote:
mysqladmin is truncating the output, how can i disable this?
or is there a better way to examine what the serer is executing at that
moment in time?
[EMAIL PROTECTED] root]# mysqladmin process
hi all, here is the suituation
i've installed mysql4.1.14 under the /usr/local directory. the problem
is, the server can work properly, however, mysqladmin doesn't. i
posted it yesterday, and someone suggested me to issue the following
command, however the same error 111 occured.
#mysqladmin
is listening on.
$B2@E(B wrote:
hi all, here is the suituation
i've installed mysql4.1.14 under the /usr/local directory. the problem
is, the server can work properly, however, mysqladmin doesn't. i
posted it yesterday, and someone suggested me to issue the following
command, however the same error
mysqladmin is truncating the output, how can i disable this?
or is there a better way to examine what the serer is executing at that
moment in time?
[EMAIL PROTECTED] root]# mysqladmin process
You can log on to your mysql server and run:
show full processlist;
That should give you what you are looking for.
-m
On Sep 6, 2005, at 1:24 PM, Jason Pyeron wrote:
mysqladmin is truncating the output, how can i disable this?
or is there a better way to examine what the serer is executing
, Jason Pyeron wrote:
mysqladmin is truncating the output, how can i disable this?
or is there a better way to examine what the serer is executing at that
moment in time?
[EMAIL PROTECTED] root]# mysqladmin process
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
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
error
Do you have any root password set? If so, you should mention -p option in
the command. The command should be of the following :
c:\mysql\bin\mysqladmin -u root shutdown -p
Which will ask you to enter the root password, else you can type your
password along with the -p option as follows :
c
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'@ 'localhost
[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 PROTECTED
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
Hi,
Our database has been running for some time and it had some threads on it
that I needed to kill.
I did a mysqladmin process list and got the following
| 2521285658 | web | 192.168.11.60:2482 | | Sleep |
747
Try enclosing 2521570862 in single quotes on the command line. It's
just a guess but it might be bash overflowing that number and not
mysqladmin.
-Eric
On 4/18/05, Marvin Wright [EMAIL PROTECTED] wrote:
Hi,
Our database has been running for some time and it had some threads on it
that I
for user =
password('apassword')' it honors the old-passwords option. However, if
a user changes their password with the mysqladmin client like
'mysqladmin --password=currentpassword password newpassword' the hash
stored is the new long password hash.
Is there any way to make
their password with the mysqladmin client like
'mysqladmin --password=currentpassword password newpassword' the hash
stored is the new long password hash.
Is there any way to make mysqladmin obey the old-passwords option?
Jason Joines
=
--
MySQL General Mailing List
For list
was successful there doesn`t exists
the tool mysql and mysqladmin
in the path /user/bin/. There are only tools like mysqld_safe, mysqltest,
myisamchk,
I've done searches for that executive files but it wasn`t detected.
After installation the access to the mysql server was denied. After the
following
Hello,
I tried to optimize our server according to the hints given in the mysql
manual and some articles I read. To find out whether our system needs
tuning I performed what's written in the manual section 4.6.8.3:
If Key_reads is big, then your key_buffer_size variable is probably
too small.
directory. However, when I run and look at mysql via the command
prompt, and enter in the mysqlshow command, all it does is show the original
test database. This same thing occurs when I look at my databases in mysqladmin.
All it shows is the original test database. What is going on?
Has the ODBC user been removed? Have you logged into mysql, mysql -uuser -p
and done show databases?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/19/04 9:44 AM
Subject: Databases not showing in cmd and mysqladmin?
Just so you know I am pretty new to all
occurs when I look at my databases in
mysqladmin.
All it shows is the original test database. What is going on?
I guess I must be a dinosaur because I don't use either mysqladmin or
mysqlgui. So I don't know how else to help. Could it be logging in as
something else and THAT account is the one without access to the other
tables?
What do you get when you do a SHOW DATABASES from each client program?
You
Whoa, I ran SHOW DATABASES and everything came up!
Now I just have to figure out how to do that with mysqladmin
(c:/mysql/bin/mysqadmin - or that is how windows default goes anyway for MySQL 4)
Sorry, thanks for the tip. I'm new to mailing lists in general...
User mysqladmin has not the rights to access mysql? How can that be?
Laurent
--
Linux is like an Indian tent: no Windows, no Gates, and an Apache inside!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqladmin is an executable. Did you set up an user named mysqladmin that
can connect from the localhost?
-Original Message-
From: Laurent
To: [EMAIL PROTECTED]
Sent: 7/19/04 6:55 AM
Subject: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
User mysqladmin
On Monday 19 July 2004 14:59, Victor Pendleton wrote:
mysqladmin is an executable. Did you set up an user named mysqladmin that
can connect from the localhost?
Exactly, it should be able to connect, but it doesn't. Should I change the
name from mysqladmin to mysql or something similar? I'll
On Mon, 19 Jul 2004, Laurent wrote:
On Monday 19 July 2004 14:59, Victor Pendleton wrote:
mysqladmin is an executable. Did you set up an user named mysqladmin that
can connect from the localhost?
Exactly, it should be able to connect, but it doesn't. Should I change the
name from
Have you tried another user.
-Original Message-
From: Laurent
To: [EMAIL PROTECTED]
Sent: 7/19/04 8:07 AM
Subject: Re: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (U
sing password: YES)
On Monday 19 July 2004 14:59, Victor Pendleton wrote:
mysqladmin is an executable. Did
Laurent [EMAIL PROTECTED] wrote:
User mysqladmin has not the rights to access mysql? How can that be?
Have you created the mysqladmin user? By default there is no such user and
it's not supposed to be there. There is no special meaning for it - mysqladmin
usually logs in as root user
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
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's had all the files
are stored on the
disk array.
=20
When there is an accidental communication breakdown between disk array
and server on which mysql process is running (e.g, pulling out FC
cable), this is being detected by our scripts and then we are trying to
shutdown the mysql process by using mysqladmin shutdown
but the data and logs are stored on the
disk array.
When there is an accidental communication breakdown between disk array
and server on which mysql process is running (e.g, pulling out FC
cable), this is being detected by our scripts and then we are trying to
shutdown the mysql process by using mysqladmin
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 touching a number of files
in your db
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
Hi,
I would like to use logrotate to manage the log files generated by MySQL.
I used the command mysqladmin flush-logs to close the log file. However,
the sql command displayed on the query log is Refresh.
According to the information from this forum, command flush logs should
be used instead
Description:
FAILS: mysqladmin -u root -P 9000 -h catchall -p variables
mysqladmin: unable to show variables; error: 'Lost connection to MySQL server
during query'
usage: ps [ -aAdeflcjLPy ] [ -o format ] [ -t termlist ]
[ -u userlist ] [ -U userlist ] [ -G grouplist ]
[ -p
Was wondering if anybody knows if there are advantages to using
mysqladmin -pPassword shutdown compared to /etc/rc.d/init.d/mysqld
stop? I have a script that was using mysqladmin to shutdown the daemon
and then /etc/rc.d/init.d/mysqld start to restart it. Problem was, and I
am not sure
hi listers
how would i determine the association between the id from mysqladmin processlist to a
pid?
what i'm after is that i notice some of the mysql threads have a high cpu utilization.
i see this using top (on a linux box). i would like to know which user/program is
responsible for tuning
Roos
Sent: Tuesday, March 09, 2004 6:05 AM
Subject: mysqladmin processlist and pid
hi listers
how would i determine the association between the id from mysqladmin
processlist to a pid?
what i'm after is that i notice some of the mysql threads have a high
cpu utilization. i see this using top
From: Hanon Sinay [EMAIL PROTECTED]
Date: Friday Nov 14, 2003 12:24:44 PM America/Los_Angeles
Subject: Unable to open and run mysqladmin Mac Os X
File Edit Options Buffers Tools Help
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR
I have just installed latest version of MySQL on
RedHat 8 and am trying to get mysqladmin to run. I
have run the mysql_install_db and set the root and
host passwords. I am able to log in to regular mysql
ok and issue commands. But whenever I try to use
mysqladmin to check version status etc. I get
--- Carol Andrejak [EMAIL PROTECTED] wrote:
Date: Fri, 10 Oct 2003 10:40:53 -0700 (PDT)
From: Carol Andrejak [EMAIL PROTECTED]
Subject: Re: Error trying to start mysqladmin
To: Carol Andrejak [EMAIL PROTECTED]
While I've been waiting, these are the other things
I
have tried:
I deleted
never tried it so just a guess)
try it like this:
mysqladmin -u username -p command
f.e. mysqladmin -u root -p processlist
Best regards
Nils Valentin
Tokyo/Japan
2003 7 23 18:51Saravanan Kulandaivelu :
Hi,
I am getting the following error:
mysqladmin: connect to server
Hi,
I am getting the following error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
if some one knows the answer . Pl. let me know.
Thanks,
Saravanan K
Check the sysntax!
It should be
mysqladmin -u root -p shutdown (If u r shutting down the server)
You should provide the password if you have one for the root user.
Saravanan Kulandaivelu [EMAIL PROTECTED]
7/23/2003 3:21:59 PM
Hi,
I am getting the following error:
mysqladmin: connect
'webfrontend' is blocked because of many connection
errors. Unblock with 'mysqladmin flush-hosts'
(both php scripts and some cron job are sending theese errors)
it's coming in periods of cuple of minutes up til 14 minutes.. It
stops by it self sometimes and other times i've tried with shutting
Hi all.
I configured a linux box for viewing the WinNT workstations of a NT network
using samba as client of wins service from an NT server.
If I execute a ping to the name of a WinNT workstation in the network it
works. But if I connected to mysql from a WinNT workstation and execute
mysqladmin
be appreciated. If more
information is needed, please let me know. Thanks.
You don't have /usr/local/mysql because you install MySQL server using RPM.
Did you install only shared libraries?
If you want to use mysqladmin and mysqlshow as mentioned in the subject, you need to
install client package
I have recently just changed hosting companies.
It is a shared hosting server using ensim webappliance pro.
This problem keeps happening. Mysql will work for half an hour and then
go down. My admin has confirmed that another site had problems in the
script and was blocking everyone.
I
You guys probably need to start mysql with the --skip-grant option
and fix the allow tables...
See the mysql.com website or google.com for lost password mysql
Thanks for the tip about how to proceed.
Just so we don't lose track here, the point of the bug we're reporting
is that
/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h tug.org password 'new-password'
See the manual for more instructions.
The first command, without the -h, worked fine, and indeed I must type
password now when I say mysqladmin -u root or -u root -h localhost.
However
Karl,
yes, same problem here.
Looking at the user table it seems the entry is there,
but mysqladmin failed. I also attempted to set by hand
the password using update table. The update succeeded,
but then when I used mysql -u root -h hostname -p
and
typed in the password, mysql also denied access
]; [EMAIL PROTECTED]
Subject: Re: mysqladmin -u root -h myhost password 'new-password' fails
Karl,
yes, same problem here.
Looking at the user table it seems the entry is there,
but mysqladmin failed. I also attempted to set by hand
the password using update table. The update succeeded
Hi,
I'm new to the list having just tried to install MySQL v4.0 onto Linux
Redhat v7.3 using an RPM distribution.
According to the docs I should be able to set a password for the MySQL
root user by running mysqladmin, but I don't see this program. Where
should I expect
root user by running mysqladmin, but I don't see this program. Where
should I expect it to be?
This is what I grabbed:-
ftp://ftp.plig.org/pub/mysql/Downloads/MySQL-4.0/MySQL-server-4.0.12-0.i386.rpm
and installed it via Webmin.
Do I need an additional package?
Yep. :-)
--
Paul DuBois
http
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 18 Mar 2003, Andrew Braithwaite wrote:
Anyone know why mysqladmin processlist is not showing the host that is
connected, but instead is showing the following in v4.0.12:
truncated excerpt
Hi all,
Anyone know why mysqladmin processlist is not showing the host that is
connected, but instead is showing the following in v4.0.12:
truncated excerpt
+-+-+--+--+
| Id | User| Host | db | Command
the hostname lookup fails you just see the IP address.
HTH/h
On 3/18/03 2:36 PM, Andrew Braithwaite [EMAIL PROTECTED] wrote:
Hi all,
Anyone know why mysqladmin processlist is not showing the host that is
connected, but instead is showing the following in v4.0.12:
truncated excerpt
to make it easier to know from which client the request
originated.
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 2:36 PM
To: [EMAIL PROTECTED]
Subject: mysqladmin processlist = weird in version 4.0.12
Hi all,
Anyone know why mysqladmin
that is connecting. The /etc/hosts file is fine and is the same as it was
before
Bug or feature?
Cheers,
Andrew
-Original Message-
From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]
Sent: Tuesday 18 March 2003 22:48
To: Andrew Braithwaite; MySQL Mailinglist
Subject: Re: mysqladmin
Anyone else notice this, or is it just me?
Andrew
-Original Message-
From: Andrew Braithwaite
Sent: Tuesday 18 March 2003 23:05
To: 'R. Hannes Niedner'; MySQL Mailinglist
Subject: RE: mysqladmin processlist = weird in version 4.0.12
Hi,
I do understand what you're saying and I did
Hello,
The documentation says that in order to change the root user's password, you
should run
C:\mysql\bin\mysqladmin -u root password your_password
I have tried this multiple times, on Windows 2000 and Windows XP, running
mysql as a service (mysql-max-nt), and it has had no effect on the root
Hello again,
Turns out it is implemented - but it's 'stop-slave' and 'start-slave'. Shoulda done a
'mysqladmin --help'. Grepping the source found it.
- GW.
Date: Wed, 29 Jan 2003 11:19:06 +1100
To: [EMAIL PROTECTED]
From: Guy Waugh [EMAIL PROTECTED]
Subject: 'mysqladmin slave-st(art|op
Hello,
I see in the mysqladmin man page for version 3.23.55-1 that 'slave-start' and
'slave-stop' have at least been thought of at some stage (they're listed in the
COMMAND SYNOPSIS section), but they don't seem to work when I try them... I've just
been through the change logs for version 4
1 - 100 of 239 matches
Mail list logo