RE: mysqlimport --use-threads / mysqladmin processlist
I'm skeptical that use-treads can every be very effective. What order are the rows in? They are probably in PRIMARY KEY order, which means that the INSERTing threads will be fighting over similar spots in the table. Is it I/O bound when it is single-threaded? If so, then there can't be any improvement with use-threads. etc. Suggest you file a bug with bugs.mysql.com. If nothing else, the documentation should say more than it does. -Original Message- From: Róbert Kohányi [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 the database schema, the second one contains only tab delimited data (via mysqldump --tab). I edit my InnoDB schema here and there (ENGINE=InnoDB to ENGINE=NDB, 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 this: mysqladmin --sleep=1 processlist this is what I see: http://pastebin.com/raw.php?i=M23fWVjc Only a single process seems to be loading my data. Is this what I *should* see, or, in my case using 4 threads, should I see four processes? I'm not asking which one will be faster, I'm just simply confused because I don't know what to expect. If I start four different mysqlimport processes, each one importing different files, then I can see four different process in the mysql processlist. If it's matters, here is my server version (I use the official binaries). Server version: 5.5.25a-ndb-7.2.7-gpl MySQL Cluster Community Server (GPL) Regards, Kohányi Róbert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysqlimport --use-threads / mysqladmin processlist
Yes, the rows are in primary key order, however each row contains specific integer primary keys; I'm not inserting nulls into a table where the primary key is auto increment, so I don't see why concurrent inserts would fight for similar spots (although, I'm admittedly not a MySQL hotshot, so the basis of my assumption is a *hunch* only). I'm not sure (yet) if a single-threaded operation would run into an i/o bottleneck. I didn't run mysqlimport using --use-threads=1 just yet (will do if I have the time), but when I've ran it with --use-threads=4 the import (of a ~500 MB dump) took more time than running for different processes (I've split my tab delimited dumps with split into four even pieces and imported those in four different sessions). Anyway, it seems that doing a simple import (from a dump, which isn't tab delimited, but contains complete or extended inserts) takes the same amount of time than doing a mysqlimport using --use-threads=4 and as it turns out splitting my tab delimited dump is too complex to handle gracefully, because my data contains newline characters all over the place, so I've dropped the idea of this whole mysqlimport thing for now. (I'll try the method of migrating an InnoDB database to an NDBCluster described here[1] instead.) If I have the time I'll write up a bug report, or documentation enhancement request for this. Thanks for the input! Regards, Kohányi Róbert [1]: http://johanandersson.blogspot.se/2012/04/mysql-cluster-how-to-load-it-with-data.html On Wed, Jul 25, 2012 at 6:49 PM, Rick James rja...@yahoo-inc.com wrote: I'm skeptical that use-treads can every be very effective. What order are the rows in? They are probably in PRIMARY KEY order, which means that the INSERTing threads will be fighting over similar spots in the table. Is it I/O bound when it is single-threaded? If so, then there can't be any improvement with use-threads. etc. Suggest you file a bug with bugs.mysql.com. If nothing else, the documentation should say more than it does. -Original Message- From: Róbert Kohányi [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 the database schema, the second one contains only tab delimited data (via mysqldump --tab). I edit my InnoDB schema here and there (ENGINE=InnoDB to ENGINE=NDB, 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 this: mysqladmin --sleep=1 processlist this is what I see: http://pastebin.com/raw.php?i=M23fWVjc Only a single process seems to be loading my data. Is this what I *should* see, or, in my case using 4 threads, should I see four processes? I'm not asking which one will be faster, I'm just simply confused because I don't know what to expect. If I start four different mysqlimport processes, each one importing different files, then I can see four different process in the mysql processlist. If it's matters, here is my server version (I use the official binaries). Server version: 5.5.25a-ndb-7.2.7-gpl MySQL Cluster Community Server (GPL) Regards, Kohányi Róbert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
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 edit my InnoDB schema here and there (ENGINE=InnoDB to ENGINE=NDB, 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 this: mysqladmin --sleep=1 processlist this is what I see: http://pastebin.com/raw.php?i=M23fWVjc Only a single process seems to be loading my data. Is this what I *should* see, or, in my case using 4 threads, should I see four processes? I'm not asking which one will be faster, I'm just simply confused because I don't know what to expect. If I start four different mysqlimport processes, each one importing different files, then I can see four different process in the mysql processlist. If it's matters, here is my server version (I use the official binaries). Server version: 5.5.25a-ndb-7.2.7-gpl MySQL Cluster Community Server (GPL) Regards, Kohányi Róbert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Monitor 'mysqladmin flush-hosts'
- 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 issue. Usually, that's rare; but it's generally recommended to authorize based off IPs and set skip-name-resolve anyway - without that option, DNS is a weak point not under your control even if you only use IPs. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Monitor 'mysqladmin flush-hosts'
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
Re: Access denied with mysqladmin
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. Õæ¸ßÐËÄÜÔÚÕâÀï¼ûµ½×Ô¼ºÈË¡£Ï£ÍûÒÔºóÄܶà¶àÖ¸½Ì£¬Ð»Ð»¡£ Xiaoming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Access denied with mysqladmin
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\MySQL\MySQL Server 5.1\binmysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)' -- Why do I get this result? Thanks. Best Regards Xiaoming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Access denied with mysqladmin
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: -- C:\Program Files\MySQL\MySQL Server 5.1\binmysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)' -- Why do I get this result? Thanks. Best Regards Xiaoming As the console print,do you enter the password for user ODBC correctly? ODBC用户密码不对,说的很明显. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Access denied with mysqladmin
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Óû§ÃÜÂë²»¶Ô£¬ËµµÄºÜÃ÷ÏÔ. ÎÒÊÇÐÂÊÖ£¬»¹²»»áʹÓÃMySQL¡£ÇëÎÊÈçºÎÔÚÔËÐÐmysqladminÕâ¸öÃüÁîÐгÌÐòµÄʱºòÊäÈëÃÜÂ룿лл£¡ Best Regards. Xiaoming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Access denied with mysqladmin
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: -- C:\Program Files\MySQL\MySQL Server 5.1\binmysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)' -- Why do I get this result? Thanks. Best Regards Xiaoming You forgot to use -- before the option version. Try this instead mysqladmin --version Let us know your results. -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Access denied with mysqladmin
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 for your help. Best Regards Xiaoming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Access denied with mysqladmin
都是中国人就说中文吧^_^ 明天会更好 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: mysqladmin --version I got the following result: mysqladmin Ver 8.42 Distrib 5.1.50, for Win32 on ia32 Many thanks for your help. Best Regards Xiaoming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=neocana...@gmail.com
Re: Access denied with mysqladmin
太搞笑了,哈哈 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. 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 for your help. Best Regards Xiaoming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=neocana...@gmail.com
mysql5.4 bugs about mysqladmin??
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 主题: Problem setting up slow logging in my,ini file I'm having a problem defining slow logging file in my.ini (Windows XP). I'm using MySQL 5.1.30. In the MySQL reference manual it says: As of MySQL 5.1.29, the --log-slow-queries option is deprecated and will be removed (along with the log_slow_queries system variable) in MySQL 7.0. Instead, use the --slow_query_log option to enable the slow query log and the --slow_query_log_file=file_name option to set the slow query log file name. So my.ini has: [mysqld] general_log=1 log-output=FILE general_log_file=LOG.TXT slow_query_log=1 slow_query_log_file=SLOWLOG.TXT After I restart MySQL, the variables have: Variable_nameValue --- -- log ON log_bin OFF log_output FILE log_queries_not_using_indexesOFF log_slow_queries ON log_warnings 1 slow_query_log ON slow_query_log_file OFF sql_log_bin ON sql_log_off OFF sql_log_update ON So why is the variable slow_query_log_file set to OFF because it is not boolean and should be a file name? Why isn't it set to the file name SLOWLOG.TXT? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=yanwei.z...@opi-corp.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
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 at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)' How can I correct this? Is this because of a firewall preventing access to port 3306?If a firewall is preventing access how was it able to ask for the password? I have Nortan Internet Security trial version running and the windows firewall is disabled.If this is caused by a firewall barrier please tell me how to open the port in Nortan Internet Security. Varuna
Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
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 mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)' How can I correct this? Is this because of a firewall preventing access to port 3306?If a firewall is preventing access how was it able to ask for the password? I have Nortan Internet Security trial version running and the windows firewall is disabled.If this is caused by a firewall barrier please tell me how to open the port in Nortan Internet Security. 1. Nortan - Norton 2. man mysql - mysql -ufoo -pbar t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
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 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 at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)' How can I correct this? Is this because of a firewall preventing access to port 3306?If a firewall is preventing access how was it able to ask for the password? I have Nortan Internet Security trial version running and the windows firewall is disabled.If this is caused by a firewall barrier please tell me how to open the port in Nortan Internet Security. Varuna -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
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 is denied for [EMAIL PROTECTED], rather than [EMAIL PROTECTED] Thanks On Sat, 2008-10-04 at 13:56 +0530, Varuna Seneviratna wrote: 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 at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)' How can I correct this? Is this because of a firewall preventing access to port 3306?If a firewall is preventing access how was it able to ask for the password? I have Nortan Internet Security trial version running and the windows firewall is disabled.If this is caused by a firewall barrier please tell me how to open the port in Nortan Internet Security. Varuna -- Ian Simpson System Administrator MyJobGroup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
Hi Ian Thanks! Your advice worked.I have another problem.I stopped the service from the services shortcut in the Administrative tools.then according to to the reference manual to start the server for the first time the command to run is given as C:\C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld --console But it didn't work, the following was the displayed message 'C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld' is not recognized as an i nternal or external command, operable program or batch file. *But when I used mysqld-nt The following is the out put* C:\C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt --console 081004 16:56:01 InnoDB: Started; log sequence number 0 43655 081004 16:56:01 [Warning] Neither --relay-log nor --relay-log-index were used; s o replication may break when this MySQL server acts as a slave and has his hostn ame changed!! Please use '--relay-log=varuna-e2a34b74-relay-bin' to avoid this p roblem. 081004 16:56:01 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: re ady for connections. Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 1 In the reference manual there are three server types how can I start the mysqld server? 2 What is the difference between installing MySQL as a server and a service, Is it only that when installed as a service MySQL server starts when Windows starts and when Windows stops it stops? 3 After starting the server in above mentioned way How can I use MySQL 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 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 is denied for [EMAIL PROTECTED], rather than [EMAIL PROTECTED] Thanks On Sat, 2008-10-04 at 13:56 +0530, Varuna Seneviratna wrote: 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 at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)' How can I correct this? Is this because of a firewall preventing access to port 3306?If a firewall is preventing access how was it able to ask for the password? I have Nortan Internet Security trial version running and the windows firewall is disabled.If this is caused by a firewall barrier please tell me how to open the port in Nortan Internet Security. Varuna -- Ian Simpson System Administrator MyJobGroup
Re: flush logs vs. mysqladmin
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 a flush logs command, it flushes the binary logs and the slow query log as well. - Redhat ES 4 - MySQL 5.0.24 from redhat-supplied RPM - Both mysqladmin from cron, and my mysql flush logs, use -u root Why does mysqladmin not flush the slow query log? It does, but the slow query log (just like the general query log) isn't created as a numbered sequence of files. You'll need to rotate it yourself. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
flush logs vs. mysqladmin
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 and the slow query log as well. - Redhat ES 4 - MySQL 5.0.24 from redhat-supplied RPM - Both mysqladmin from cron, and my mysql flush logs, use -u root Why does mysqladmin not flush the slow query log? -- Cos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5.0.x and 5.1.x Compiling options and settings on Linux IA64: one more question: ./bin/mysqladmin: connect to server at 'localhost' failed
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 error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Fwd: Re: MySQL 5.0.x and 5.1.x Compiling options and settings on Linux IA64: one more question: ./bin/mysqladmin: connect to server at 'localhost' failed
Hi, After having compiled (debug and optimized version) of MySQL 5.1.14 on Itanium-2 using icc, I have run mysql_install_db --user=... and started mysqld_safe in both scenarios (debug and optimized). In both cases mysqld starts without any errors. Unfortunaly when 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 procedure applied on the mysqld compiled with debug version (--with-debug) has no problem and I am able to set up the root password without any problems. Is there a bug in the MySQL 5.1.14 version when not compiled with --with-debug or am I missing something ? P.S. I have also tried to set the root password using the debug version, shut-down the mysqld debug, replaced the mysql subdirectory in the data subdir in the optimized version and restarted the optimized mysqld with the new mysql subdir in the data subdir, but I got the same error. Could you please help ? Thanks in advance for your help, Mariella - Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers.
mysqladmin claims password in crontab !
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, this command failed /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' So, I did a simple test : I just run mysqladmin version using the batch command (it runs a tasks as cron, but immediately) : it works ! So , what !! Help please ! p4.vert.ukl.yahoo.com uncompressed Thu Aug 17 06:27:00 GMT 2006 ___ Découvrez un nouveau moyen de poser toutes vos questions quelque soit le sujet ! Yahoo! Questions/Réponses pour partager vos connaissances, vos opinions et vos expériences. http://fr.answers.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin claims password in crontab !
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). Unfortunately, this command failed /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' So, I did a simple test : I just run mysqladmin version using the batch command (it runs a tasks as cron, but immediately) : it works ! The cron version doesn't know where the my.cnf file is, add: --defaults-extra-file=/path/to/.my.cnf to the end of your crontab line. So: mysql -u root --defaults-extra-file=/root/.my.cnf . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin claims password in crontab !
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
can't connect to server using mysqladmin or mysql
Description: I'm sorry This is long, but it's because I've tried hard to fix this myself; please bear with me. Last week, for unknown reason, my root password for MySQL wasn't working. I may have changed it without updating the /root/.my.cnf file. So, I went to the online documentation (which is usually excellent) and followed the instructions for resetting the password. I first tried the one with the init-file and that didn't work, so then I used the one where you skip the grant tables, and that didn't work either. I would update the mysql.user table, and I would see the changed encrypted password, but the new password wouldn't work. I should probably have stopped there, but seeing that there was a new, stable version of MySQL (I was running 4.1.9), I decided to upgrade, figuring that the instructions for setting the password would take care of the problem. In any event, I figured that you'd rather fix the problem in 5.0.22. So, I downloaded the RPM and installed it. Here is the transcript: # rpm -Uvh MySQL-server-standard-5.0.22-0.rhel3.i386.rpm Preparing...### [100%] Giving mysqld a couple of seconds to exit 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 puma.wellesley.edu password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com /usr/bin/mysqlcheck: unknown option '--check-upgrade' This script updates all the mysql privilege tables to be usable by MySQL 4.0 and above. This is needed if you want to use the new GRANT functions, CREATE AGGREGATE FUNCTION, stored procedures, or more secure passwords in 4.1 Got a failure from command: cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=mysql --host=localhost --database=mysql Please check the above output and try again. Running the script with the --verbose option may give you some information of what went wrong. If you get an 'Access denied' error, you should run this script again and give the MySQL root user password as an argument with the --password= option Starting MySQL.[ OK ] # Following your instructions, I started the server and ran the password-setting command. Here's the transcript: # service mysql start Starting MySQL [ OK ] # mysqladmin -u root password 'blahblah' mysqladmin: connect to server at 'puma' failed error: 'Lost connection to MySQL server during query' # ps -ef | grep mysql root 12811 1 0 11:11 pts/000:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/puma.wellesley.edu.pid mysql12832 12811 0 11:11 pts/000:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/puma.wellesley.edu.pid --skip-locking So, it looks like the server is running, but for some reason I can't connect. I've tried a bunch of other ways (such as starting it with --skip-grant-tables) but no luck. I've checked the error log, and it's quite clean. For example: 060801 11:39:31 mysqld started 060801 11:39:31 InnoDB: Started; log sequence number 0 81455176 060801 11:39:31 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.22-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL) Interestingly, if I use nmap, it shows that port 3306 is open, but if I try to telnet to that port, it never responds. How-To-Repeat: Start mysql server in the usual way, which yields no errors, then try something as simple as # mysqladmin -u root ping This will hang for a very long time (several minutes) and eventually say: mysqladmin: connect to server at 'puma' failed error: 'Lost connection to MySQL server during query' Fix: None that I know of. This is a real problem for me. Submitter-Id: submitter ID Originator:root Organization: Wellesley College Computer Science MySQL support: none Synopsis: can't connect to server and can't reset root password Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-5.0.22-standard (MySQL Community Edition - Standard (GPL)) C compiler:gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52) C++ compiler: gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52) Environment: System: Linux puma.wellesley.edu 2.4.21-47.ELsmp
Re: can't connect to server using mysqladmin or mysql
I would like to withdraw my earlier bug report with the same subject line. I discovered that an erroneous IP address for the server machine had gotten into /etc/hosts (due to some IP changes in my organization). Once the DNS error was resolved, I was able to connect correctly and fix the password problem. I apologize for the mistake. Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: Wellesley College Computer Science MySQL support: none Synopsis: can't connect to server and can't reset root password Severity: 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 This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 5.0.22-standard Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 56 min 0 sec Threads: 1 Questions: 876 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 64 Queries per second avg: 0.261 C compiler:gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52) C++ compiler: gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52) Environment: System: Linux puma.wellesley.edu 2.4.21-47.ELsmp #1 SMP Wed Jul 5 20:38:41 EDT 2006 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2.3/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --host=i386-redhat-linux Thread model: posix gcc version 3.2.3 20030502 (Red Hat Linux 3.2.3-56) Compilation info: CC='gcc' CFLAGS='-O2 -g -pipe -march=i386 -mcpu=i686' CXX='gcc' CXXFLAGS='-O2 -g -pipe -march=i386 -mcpu=i686' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jul 25 18:20 /lib/libc.so.6 - libc-2.3.2.so -rwxr-xr-x1 root root 1512793 Jun 16 07:32 /lib/libc-2.3.2.so -rw-r--r--1 root root 2468490 Jun 16 06:50 /usr/lib/libc.a -rw-r--r--1 root root 204 Jun 16 06:36 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-server-suffix=-standard' '--without-embedded-server' '--with-innodb' '--with-archive-storage-engine' '--without-bench' '--with-zlib-dir=bundled' '--with-big-tables' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--with-pic' '--prefix=/' '--with-extra-charsets=complex' '--with-yassl' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--libdir=/usr/lib' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--enable-thread-safe-client' '--with-comment=MySQL Community Edition - Standard (GPL)' '--with-readline' 'CC=gcc' 'CFLAGS=-O2 -g -pipe -march=i386 -mcpu=i686' 'CXXFLAGS=-O2 -g -pipe -march=i386 -mcpu=i686' 'CXX=gcc' 'LDFLAGS=' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
trouble finding WinMySQLadmin, and opening MySQLadmin
Hi everybody, I have Windows XP computer and I've installed Apache, and MySQL 5.0.18. I downloaded MySQL from: http://www.softpedia.com/progDownload/MySQL-for-Windows-Download-2668.html but the following problem occurs. According to the instructions in php 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 the MySQLadmin program instead. According to the instructions I should be able to double click it so it wil open a new window. Now the second problem: It opens, but for a tiny fraction of a second. I've tried several other links to download MySQL but it's the same with all versions. What am I doing wrong? Best regards, Bibi
Re: trouble finding WinMySQLadmin, and opening MySQLadmin
Bibi, WinMySqlAdmin has been disocntinued. Try mysql/bin/MySqlInstqanceConfig.exe. Getting PHP to work with MySQL under Windows is a bit tricky at first, but once set up it's solid. For setup have a look at http://forums.mysql.com/read.php?52,70381,70628#msg-70628. PB http://www.artfulsoftware.com - Bibi Snelderwaard wrote: Hi everybody, I have Windows XP computer and I've installed Apache, and MySQL 5.0.18. I downloaded MySQL from: http://www.softpedia.com/progDownload/MySQL-for-Windows-Download-2668.html but the following problem occurs. According to the instructions in php 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 the MySQLadmin program instead. According to the instructions I should be able to double click it so it wil open a new window. Now the second problem: It opens, but for a tiny fraction of a second. I've tried several other links to download MySQL but it's the same with all versions. What am I doing wrong? Best regards, Bibi No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.1.2/274 - Release Date: 3/3/2006 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.1.2/274 - Release Date: 3/3/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqladmin --skip-grant-tables error
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 --skip-grant-tables, I get the error message mysqladmin: ERROR: unknown option '--grant-tables' I also tried ./mysqladmin --skip-grant-tables --user=root and this didn't help either I'm using Mysql version 4.0.17-standard which came bundled with my OS (Ubuntu Linux Warty) Pointers much appreciated. Thanks, Alfred Vahau IT Services University of Papua New Guinea -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin --skip-grant-tables error
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 the command ./mysqladmin --skip-grant-tables, I get the error message mysqladmin: ERROR: unknown option '--grant-tables' I also tried ./mysqladmin --skip-grant-tables --user=root and this didn't help either I'm using Mysql version 4.0.17-standard which came bundled with my OS (Ubuntu Linux Warty) Pointers much appreciated. Thanks, Alfred Vahau IT Services University of Papua New Guinea You appear to have misread the manual. --skip-grant-tables is not a mysqladmin option. It's a mysqld option. Just follow the directions in the manual http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin --skip-grant-tables error
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 problem is when I issue the command ./mysqladmin --skip-grant-tables, I get the error message mysqladmin: ERROR: unknown option '--grant-tables' I also tried ./mysqladmin --skip-grant-tables --user=root and this didn't help either I'm using Mysql version 4.0.17-standard which came bundled with my OS (Ubuntu Linux Warty) Pointers much appreciated. Thanks, Alfred Vahau IT Services University of Papua New Guinea You appear to have misread the manual. --skip-grant-tables is not a mysqladmin option. It's a mysqld option. Just follow the directions in the manual http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html. Michael Thanks. Problem fixed. Alfred, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Min permissions to run `mysqladmin version`
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 Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Min permissions to run `mysqladmin version`
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 to be able to connect to the server. For example, either of these statements will create the account: CREATE USER 'vuser'@'remote-host' IDENTIFIED BY 'vpass'; GRANT USAGE ON *.* TO 'vuser'@'remote-host' IDENTIFIED BY 'vpass'; -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin question
Hello. MySQL team verified this issue, but they've said that this is rather a feature request, not really a bug. See: http://bugs.mysql.com/bug.php?id=13032 Jason Pyeron [EMAIL PROTECTED] wrote: Thanks Michael, but it now seems that on prepared selects, the values are still place holders, whilst on prepared inserts they are substituted in. Does anyone know how to address this issue? +-+---++---+-+--+--++ | Id | User | Host | db| Command | Time | State | Info | +-+---++---+-+--+--++ | 110 | crisfield | 192.168.1.104:2655 | crisfield | Query |0 | NULL | show full processlist | | 117 | crisfield | testserver:40291 | crisfield | Execute |0 | Sending data | SELECT id, pathref, version, mdate, ddate,size, md5 FROM files WHERE (version, pathref)=(SELECT MAX(version),pathref FROM files WHERE pathref=? group by pathref) | +-+---++---+-+--+--++ 2 rows in set (0.01 sec) mysql show full processlist; +-+---++---+-+--++--+ | Id | User | Host | db| Command | Time | State | Info| +-+---++---+-+--++--+ | 110 | crisfield | 192.168.1.104:2655 | crisfield | Query |0 | NULL | show full processlist | | 117 | crisfield | testserver:40291 | crisfield | Execute |0 | update | INSERT INTO files (pathref, version, mdate, ddate, size, md5) VALUES (51943,0,1060907651000,NULL,64685,NULL) | +-+---++---+-+--++--+ 2 rows in set (0.06 sec) mysql On Tue, 6 Sep 2005, Michael Barnett wrote: 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 at that moment in time? [EMAIL PROTECTED] root]# mysqladmin process +-+---++---+-+ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Anyone knows what happens at mysqladmin startup time?
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 -uroot password mypwd #error: can't connect to local MySQL server through socket '/tmp/mysql.sock'(111) but, the server is *really* running. #ps -e | grep mysqld shows mysqld_safe and several other mysqld threads. i'm wodering if mysqladmin requires parsing some .rc files(if any) or interpreting some environment variables(if any) but they have wrong settings or values? any hits or help or advice would be most appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Anyone knows what happens at mysqladmin startup time?
It appears that mysqld is not listening on /tmp/mysql.sock. Log into mysql and run show variables like 'socket'; This will tell you where mysqld is actually listening for socket connections. Then update your my.cnf files so they all have the same sock file location as the one that mysqld 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 111 occured. #mysqladmin -uroot password mypwd #error: can't connect to local MySQL server through socket '/tmp/mysql.sock'(111) but, the server is *really* running. #ps -e | grep mysqld shows mysqld_safe and several other mysqld threads. i'm wodering if mysqladmin requires parsing some .rc files(if any) or interpreting some environment variables(if any) but they have wrong settings or values? any hits or help or advice would be most appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqladmin question
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 +-+---++---+-+--+--+--+ | Id | User | Host | db| Command | Time | State | Info | +-+---++---+-+--+--+--+ | 110 | crisfield | 192.168.1.104:2655 | crisfield | Sleep | 70 | | | | 117 | crisfield | testserver:40291 | crisfield | Execute | 0| Sending data | SELECT id, pathref, version, mdate, ddate, size, md5 FROM files WHERE (version, pathref)=(SELECT MAX | | 127 | root | localhost | | Query | 0| | show processlist | +-+---++---+-+--+--+--+ [EMAIL PROTECTED] root]# -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin question
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 at that moment in time? [EMAIL PROTECTED] root]# mysqladmin process +-+---++---+-+-- +-- +- -+ | Id | User | Host | db| Command | Time | State| Info | +-+---++---+-+-- +-- +- -+ | 110 | crisfield | 192.168.1.104:2655 | crisfield | Sleep | 70 | | | | 117 | crisfield | testserver:40291 | crisfield | Execute | 0 | Sending data | SELECT id, pathref, version, mdate, ddate, size, md5 FROM files WHERE (version, pathref)=(SELECT MAX | | 127 | root | localhost | | Query | 0 | | show processlist | +-+---++---+-+-- +-- +- -+ [EMAIL PROTECTED] root]# -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin question
Thanks Michael, but it now seems that on prepared selects, the values are still place holders, whilst on prepared inserts they are substituted in. Does anyone know how to address this issue? +-+---++---+-+--+--++ | Id | User | Host | db| Command | Time | State | Info | +-+---++---+-+--+--++ | 110 | crisfield | 192.168.1.104:2655 | crisfield | Query |0 | NULL | show full processlist | | 117 | crisfield | testserver:40291 | crisfield | Execute |0 | Sending data | SELECT id, pathref, version, mdate, ddate,size, md5 FROM files WHERE (version, pathref)=(SELECT MAX(version),pathref FROM files WHERE pathref=? group by pathref) | +-+---++---+-+--+--++ 2 rows in set (0.01 sec) mysql show full processlist; +-+---++---+-+--++--+ | Id | User | Host | db| Command | Time | State | Info| +-+---++---+-+--++--+ | 110 | crisfield | 192.168.1.104:2655 | crisfield | Query |0 | NULL | show full processlist | | 117 | crisfield | testserver:40291 | crisfield | Execute |0 | update | INSERT INTO files (pathref, version, mdate, ddate, size, md5) VALUES (51943,0,1060907651000,NULL,64685,NULL) | +-+---++---+-+--++--+ 2 rows in set (0.06 sec) mysql On Tue, 6 Sep 2005, Michael Barnett wrote: 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 at that moment in time? [EMAIL PROTECTED] root]# mysqladmin process +-+---++---+-+-- +-- +- -+ | Id | User | Host | db| Command | Time | State | Info | +-+---++---+-+-- +-- +- -+ | 110 | crisfield | 192.168.1.104:2655 | crisfield | Sleep | 70 | | | | 117 | crisfield | testserver:40291 | crisfield | Execute | 0| Sending data | SELECT id, pathref, version, mdate, ddate, size, md5 FROM files WHERE (version, pathref)=(SELECT MAX | | 127 | root | localhost | | Query | 0| | show processlist | +-+---++---+-+-- +-- +- -+ [EMAIL PROTECTED] root]# -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from
mysqladmin Shutdown fail
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 list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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] 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' (using password: NO) Does anyone know why? Please share with us. Thankyou..Phong -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Power to people, Linux is here.
Re : mysqladmin Shutdown fail
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:\mysql\bin\mysqladmin -u root shutdown -pmypassword Note : there is no space left between the -p and your password. Regards, Rakki Muthu Kumar N P | Project Engineer | Wipro Technologies | Bangalore | India - As 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 : 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 list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin Shutdown fail
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' (using password: NO) Does anyone know why? Please share with us. Thankyou..Phong -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqladmin Shutdown fail
Thankyou. But, when I startup I got error like Innodb: error: log file .\ib_logfile (0,1) is different size Innodb: than specifiled in the .cnf file 050729: {eror} can't init database 050729:{error} aborting Could you please tell me why? Thank you -Original Message- From: Scott 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 PROTECTED] mailto:[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' (using password: NO) Does anyone know why? Please share with us. Thankyou..Phong -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] http://lists.mysql.com/[EMAIL PROTECTED] -- Power to people, Linux is here.
Re: mysqladmin Shutdown fail
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. Thankyou. But, when I startup I got error like Innodb: error: log file .\ib_logfile (0,1) is different size Innodb: than specifiled in the .cnf file 050729: {eror} can't init database 050729:{error} aborting Could you please tell me why? Thank you Nguyen, Phong [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysqladmin bug
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 || | | 2521498154 | web | 192.168.11.60:2570 | | Sleep | 335 || | | 2521570862 | web | 192.168.11.60:2600 | | Sleep | 190 || I tried to kill 2521570862 and got an error [EMAIL PROTECTED] mwright]$ mysqladmin kill 2521570862 mysqladmin: kill failed on 2147483647; error: 'Unknown thread id: 2147483647' I think the thread id number is too large for mysqladmin to deal with, 2147483647 is the max size of an int. Marvin Wright Flights Developer Lastminute.com [EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **
Re: Mysqladmin bug
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 needed to kill. I did a mysqladmin process list and got the following | 2521285658 | web | 192.168.11.60:2482 | | Sleep | 747 || | | 2521498154 | web | 192.168.11.60:2570 | | Sleep | 335 || | | 2521570862 | web | 192.168.11.60:2600 | | Sleep | 190 || I tried to kill 2521570862 and got an error [EMAIL PROTECTED] mwright]$ mysqladmin kill 2521570862 mysqladmin: kill failed on 2147483647; error: 'Unknown thread id: 2147483647' I think the thread id number is too large for mysqladmin to deal with, 2147483647 is the max size of an int. Marvin Wright Flights Developer Lastminute.com [EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.7 has --old-passwords set but mysqladmin client still using new hash
Hello. I've reported a bug: http://bugs.mysql.com/7451 Jason Joines [EMAIL PROTECTED] wrote: I've got a 4.1.7 server on Linux and I need to use the old-passwords option. It has taken effect as 'show variables' confirms. Also, if I set a user's password using 'set password 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 mysqladmin obey the old-passwords option? Jason Joines = -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
4.1.7 has --old-passwords set but mysqladmin client still using new hash
I've got a 4.1.7 server on Linux and I need to use the old-passwords option. It has taken effect as 'show variables' confirms. Also, if I set a user's password using 'set password 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 mysqladmin obey the old-passwords option? Jason Joines = -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Using mysql and mysqladmin
Hello, I have installed MySQL-server-4.0.22-0.i386.rpm as server at a linux computer and at the PC (windows 2000) as client was installed mysql-administrator-1.0.14-win.msi and mysql-query-browser-1.1.1-gamma-win.msi. Now I have two questions: Although the installtion at the server 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 commands at the server: kill `cat /usr/lib/x.pid` mysqld_safe --skip-grant-tables the access was allowed (no passwords are necessary after that modification). Now I`ve changed at the PC with the administration tool the passwords for the users. After that change the access to the server was denied as before. Do you know the causes for that problems? Thanks in advance Gunter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqladmin extended-status: useless statistics when running server for a while?
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. The cache miss rate can be calculated with Key_reads/Key_read_request The rate was way to low after running the server for app. 80 days, so I doubled the key-cache and started again, controlling the ratio every 48 hours. Rate seemed to be much better (1/200 instead of 1/20 before) but from one day to the other the result dropped down on 1/4. Knowing that it can't be I controlled the absolute values and figured out, that the Key_reads-variable had an overflow reaching 4Billion. My conclusion was that the value is saved as an unsigned-int which is far to small for a long running statistic if it should be usefull longer than a couple of days. Now my question, especially for the Mysql-developers is, if it is possible to store this values as float or another type to make the statistics usable for a longer time. Our server isn't really a big one, but the overflow happened after running the server only for 11 days. Greetings from Germany Lutz Maibach -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Databases not showing in cmd and mysqladmin?
Just so you know I am pretty new to all this. I recently installed MySQL 4 on my PC. My friend gave me mysqlgui.exe to help configure stuff. So I made several databases using it. Now I know these databases are there, because I am running IPB on one of them, and they show up under the data 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?
RE: Databases not showing in cmd and mysqladmin?
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 this. I recently installed MySQL 4 on my PC. My friend gave me mysqlgui.exe to help configure stuff. So I made several databases using it. Now I know these databases are there, because I am running IPB on one of them, and they show up under the data 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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Databases not showing in cmd and mysqladmin?
Sounds like a permissions problem. Make sure the login you are using has the rights to see the databases in question. (http://dev.mysql.com/doc/mysql/en/SHOW_GRANTS.html) You may need to GRANT yourself additional privileges. (http://dev.mysql.com/doc/mysql/en/GRANT.html) Respecfully, Shawn Green Database Administrator Unimin Corporation - Spruce Pine [EMAIL PROTECTED] wrote on 08/19/2004 10:44:01 AM: Just so you know I am pretty new to all this. I recently installed MySQL 4 on my PC. My friend gave me mysqlgui.exe to help configure stuff. So I made several databases using it. Now I know these databases are there, because I am running IPB on one of them, and they show up under the data 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?
Re: Databases not showing in cmd and mysqladmin?
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 can see all of the accounts that are logged in to a MySQL server and what they are currently doing if you run a SHOW FULL PROCESSLIST. That may help you to verify that the other programs you are using have their appropriate privileges. Also, and this is _not_ just to you but to all others who ask the list for help, please always cc: the list when you respond to a list response (unless the message is truly private) . Your problem will be seen by MANY people and any of them could have seen your situation before. Not only could your situation and it's resolution be helpful to others, it just saves time in the long run. Respecfully, Shawn Green Database Administrator Unimin Corporation - Spruce Pine [EMAIL PROTECTED] wrote on 08/19/2004 11:27:42 AM: I checked my grants, and it says I have everything. In fact, when logged in under that all-privileged account, I can even log in to the databases created with mysqlgui. However, when I go to mysqlshow, they still don't come up and same with mysqladmin. I guess this is mostly a superficial problem, because I long as I can log in and edit I'm okay..however I would like to be able to manage my databases in mysqladmin.
Re: Databases not showing in cmd [SOLVD] and mysqladmin [pending]?
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...
ERROR 1045: Access denied for user: 'mysqladmin@localhost' (Using password: YES)
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]
RE: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)
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 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)
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 try. 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]
Re: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)
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 mysqladmin to mysql or something similar? I'll try. Laurent Laurent, with a fresh install, use 'root' as username and no password. Be sure to set a password later. Thomas Spahni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)
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 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 try. 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (Using password: YES)
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. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqladmin shutdown command hangs
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 database on our our server. The data and log files are stored on an external SCSI disk array which is connected to our server using FC cable connected to SCSI port. The mysql process is running on the local machine 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 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqladmin shutdown command hangs
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 it's dealing with pulled out from under it. With mysqladmin shutdown or a simple kill `cat /var/run/mysqld.pid`, the process is going to patiently wait for the data to be available for writing again. Perhaps your OS might have some tunables that control how long a process sits waiting on blocked disk reads/writes. You could probably just send a kill to the server instead, as that may be more scriptable. As far as I know, this is basically the same as the shutdown command (and it's how all the system shutdown scripts for mysqld I've seen work). Your script can then wait a bit and see if mysql has stopped or not. If it hasn't, then you can get out the kill -9 hammer. Thanks, Charles Thanks again, Ravi -Original Message- From: Charles Sprickman [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 10:07 PM To: Ravi T Ramachandra (WT01 - EMBEDDED PRODUCT ENGINEERING SOLUTIONS) Cc: [EMAIL PROTECTED] Subject: Re: mysqladmin shutdown command hangs On Thu, 8 Jul 2004 [EMAIL PROTECTED] wrote: 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 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 directory. Shutting it down seems like a bad thing to do; I would imagine stopping client access to the db would be a more useful action to take if you lose the array. Charles We tried the --force option also with the mysqladmin shutdown command, but it still hung. Does anybody have any suggestion/solution. Thanks, Ravi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin shutdown command hangs
[EMAIL PROTECTED] wrote: We have installed a mysql database on our our server. The data and log files are stored on an external SCSI disk array which is connected to our server using FC cable connected to SCSI port. The mysql process is running on the local machine but the data and logs 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 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 killall -9 mysqld then but it's brute force. In the first case there is no need to restart MySQL (and theoreticly it should flush and shutdown with no problems). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqladmin shutdown command hangs
Hello: We are using mysql 4.0.17 on Linux We have installed a mysql database on our our server. The data and log files are stored on an external SCSI disk array which is connected to our server using FC cable connected to SCSI port. The mysql process is running on the local machine 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 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
Re: mysqladmin shutdown command hangs
On Thu, 8 Jul 2004 [EMAIL PROTECTED] wrote: 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 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 directory. Shutting it down seems like a bad thing to do; I would imagine stopping client access to the db would be a more useful action to take if you lose the array. Charles We tried the --force option also with the mysqladmin shutdown command, but it still hung. Does anybody have any suggestion/solution. Thanks, Ravi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqladmin shutdown command hangs
Charles, Sometimes, the connection to disk array will not be available to this server for long time and in such a case, we want another server to connect to the disk array and run mysql processes. Unfortunately, from our design, this cannot happen until the existing server shuts down. 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. Thanks again, Ravi -Original Message- From: Charles Sprickman [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 10:07 PM To: Ravi T Ramachandra (WT01 - EMBEDDED PRODUCT ENGINEERING SOLUTIONS) Cc: [EMAIL PROTECTED] Subject: Re: mysqladmin shutdown command hangs On Thu, 8 Jul 2004 [EMAIL PROTECTED] wrote: 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 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 directory. Shutting it down seems like a bad thing to do; I would imagine stopping client access to the db would be a more useful action to take if you lose the array. Charles We tried the --force option also with the mysqladmin shutdown command, but it still hung. Does anybody have any suggestion/solution. Thanks, Ravi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqladmin flush-logs
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 of 'refresh (for performance reason). If i issue the flush logs command directly using mysql, the query log show 'flush logs'. Is this a problem on mysqladmin. Version used : 4.0.20 Regards, Michael --- KMB E-mail Disclaimer This e-mail may contain confidential, proprietary or legally privileged information and is intended for the attention and use of the addressee(s) only. If you are not the intended recipient of this message, you must not copy, use or disclose any part of its contents. Please notify the sender immediately and delete this message from your system. The KMB Group and each of its affiliates and the sender of this message shall not be responsible or liable for any errors or omissions in the contents of this message as secure or error free e-mail transmission cannot be guaranteed. Information sent via e-mail could arrive late or contain viruses or be intercepted, corrupted, lost, destroyed, or incomplete. Unless otherwise stated, any information given in this message is indicative only and is subject to our formal written confirmation.
mysqladmin variables is broken
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 proclist ] [ -g pgrplist ] [ -s sidlist ] 'format' is one or more of: user ruser group rgroup uid ruid gid rgid pid ppid pgid sid taskid pri opri pcpu pmem vsz rss osz nice class time etime stime f s c lwp nlwp psr tty addr wchan fname comm args projid project pset -e Number of processes running now: 0 040617 09:31:41 mysqld restarted How-To-Repeat: NOTE: mysqladmin -u root -P 9000 -h catchall -p version WORKS FINE FAILS: mysqladmin -u root -P 9000 -h catchall -p variables Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: mysqladmin variables is broken Severity: Priority: Category: mysql Class: Release: mysql-4.0.20 (Source distribution) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: SunOS HOSTNAME_REMOVED 5.9 Generic_112233-11 sun4u sparc SUNW,Sun-Fire-V210 Architecture: sun4 Some paths: /afs/rcf/lang/bin/perl /usr/rcf/bin/make /usr/rcf/bin/gcc /afs/rcf/apps/Forte/current/SUNWspro/bin/cc GCC: Reading specs from /usr/rcf/lib/gcc-lib/sparc-sun-solaris2.9/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='ccache gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS='' ASFLAGS='' LIBC: -rw-r--r-- 1 root bin 1850244 Aug 22 2003 /lib/libc.a lrwxrwxrwx 1 root root 11 Apr 24 09:39 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 866400 Aug 22 2003 /lib/libc.so.1 -rw-r--r-- 1 root bin 1850244 Aug 22 2003 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Apr 24 09:39 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 866400 Aug 22 2003 /usr/lib/libc.so.1 Configure command: ./configure '--prefix=/usr/local/mysql' '--enable-assembler' '--with-extra-charsets=complex' '--with-innodb' '--with-berkeley-db' '--with-embedded-server' '--enable-thread-safe-client' '--with-openssl' '--with-vio' '--with-raid' '--enable-local-infile' 'CFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXX=ccache gcc' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqladmin shutdown
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 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 only doing it when running it through my script from a cron job. I could even run the script from the command line and it would work. It was just when I ran it through a cron job at 1am every morning. Thanks Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 (on a linux box). i would like to know which user/program is responsible for tuning purposes. i can use mysqladmin processlist and it gives me a list (including an id) of what processes are running but how do i tie this in with unix' pid? tks tom
Re: mysqladmin processlist and pid
Hi Tom, You can't. MySQL's own thread ids are sequential. The OS pids are random. There's no connection between them. Besides, mysqld is really only running in a single real process, it's just that LinuxThreads shows each thread as a process. Matt - Original Message - From: Tom 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 (on a linux box). i would like to know which user/program is responsible for tuning purposes. i can use mysqladmin processlist and it gives me a list (including an id) of what processes are running but how do i tie this in with unix' pid? tks tom -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is mysqladmin part of Os X package
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: will all comments (text enclosed in `' and `'). SEND-PR: From: Hanon Sinay To: [EMAIL PROTECTED] Subject: Unable to open and run mysqladmin, Mac Os X Description: I am trying to use mysqlbug script in a conforming way as requested. I may not have it right. Sorry! (I am obviuosly a new user. I am trying.) Unable to open and run mysqladmin from the terminal window shell command line, Mac Os X 10.2.8. I get no error messages. I simply get the next line prompt for a new shell command. I believe the file is not present. The manual and installation documentation all refer to the presence of mysqladmin. Is mysqladmin supposed to be present in the Mac Os X package? Am I looking for a fie that is not supposed to be present in the package? I am not running Mac Os X Server. I use: Mac osX v 10.2.8 (jaguar) on Mac G-4, with 940 mb ram mysql version 4.0.15, installed from download package mysql-standard-4.0.15.dmg mysql startup installed from download package MySQLStartupItem.pkg Installation was successful with no apparent problems (installation this past week). mysqld process is running automatically on startup. I am able to open and access mysqldump in the terminal window from shell. I am able to open and access mysqlshow in the terminal window from shell. I am able to open and access mysqlbinlog in the terminal window from shell. I am able to open and access mysqlmanager in the terminal window from shell. I am able to open and access mysql in the terminal window from shell. I find three mysqladmin files with zero bytes of content located at: 1) /root/(This is my root user home) 2) /usr/local/mysql/bin/ 3) /usr/local/mysql/ I find one mysqladmin.1 file with 8k bytes of content located at: /usr/local/mysql/man/man1/ (If mysqladmin.1 is the intended file instead of mysqladmin it will not open or run either) I have identified three files with the basic name mysqlmanager. Is mysqlmanager intended to replace mysqladmin for the mac os X package download? I want to implement a stable and secure mysql data base on my local mac (production environment). The data base will later be deployed in an open internet environment. I appreciate your reply. Thank you. Hanon Sinay How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:System Administrator Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) :**-F1 mysqlbug (Fundamental)--L1--Top Auto-saving...done
Error trying to start mysqladmin
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 this error: mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' I have tried everything I can think of including 'mysqladmin -u root', 'mysqladmin -u root -p' and various other flavors and still the same error. I have tried setting the password from within mysql and checked the mysql database for users and everything is there. I have checked documentation and can't find anything that addresses this. What am I missing? = Carol Andrejak Webmaster Delaware State University Grossley Hall Rm. 1 302-857-7045 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fwd: Re: Error trying to start mysqladmin
--- 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 all the grant tables and re-ran mysql_install_db. Then I tried the mysqladmin -u root password 'password' command again but still got the same error. So I went into the mysql database and took a look at the user table and this is what it has for Host | User | Password localhost | root | (password) www.desu.edu | root | (password) localhost | (empty) | (empty) www.desu.edu | (empty) | (empty) I keep reading the manual looking for more ideas but I've tried just about everything. Anybody have any ideas? --- Carol Andrejak [EMAIL PROTECTED] wrote: 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 this error: mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' I have tried everything I can think of including 'mysqladmin -u root', 'mysqladmin -u root -p' and various other flavors and still the same error. I have tried setting the password from within mysql and checked the mysql database for users and everything is there. I have checked documentation and can't find anything that addresses this. What am I missing? = Carol Andrejak Webmaster Delaware State University Grossley Hall Rm. 1 302-857-7045 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] = Carol Andrejak Webmaster Delaware State University Grossley Hall Rm. 1 302-857-7045 = Carol Andrejak Webmaster Delaware State University Grossley Hall Rm. 1 302-857-7045 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin: connect to server at 'localhost' failed
Seems like I forgot to post to the list again. O.K this one is for the record ;-) Nils Valentin Tokyo/Japan 2003 7 24 13:54: Hi Saravanan, Thats a simple question. You have to specify a username and a password when connecting to the mysql server. I guess thats similar to Oracle ( have 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 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 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqladmin: connect to server at 'localhost' failed
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
Re: mysqladmin: connect to server at 'localhost' failed
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 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2013: Lost connection to MySQL server during query ERROR 1129: Host 'webfrontend' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'
Hi! I've look a bit around google for theese errors - but i can't find any useful answers to my problem. My setup is; web frontend running apache/php for dynamic page creation (p4 - 2,4 Ghz - 1Gb - ide) sql backend running mysql 4.0.12-log (p3 - 1 Ghz - ide) both machines running debian gnu/linux 2.4 linux kernels - alle software installed from debian packages. the web frontend are serving 1,4 mill dynamic pages / day (access file recording) the sql server says: Connection: majeskuel via TCP/IP Uptime: 3 hours 53 min 36 sec Threads: 226 Questions: 1616956 Slow queries: 79 Opens: 467 Flush tables: 1 Open tables: 461 Queries per second avg: 115.365 Essentials from my.conf; set-variable= key_buffer=384M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= long_query_time=2 set-variable= max_connections=525 set-variable= thread_cache=8 set-variable= thread_concurrency=2 set-variable= myisam_sort_buffer_size=64M set-variable= query_cache_size=64M My Problem is... I restarted my mysql server last nite - and suddenly this afternoon my error reporting system flushed me with theese 2 errors happining at connect time: 2013: Lost connection to MySQL server during query 1129: Host '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 down the services and started them agian. (and flush-hosts also stop it) ...and... I've checked for code changes in the web application. Somebody says its tcp/ip stack problem - but no packets are dropped on the ethernenet layer. Nothing in the mysql err log either.. *looking kinda desperate ;)* Stefan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
showing Host name in mysqladmin proc with wins using samba
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 proc in the linux box it shows the ip in Host column, not the name. If I add the name of the workstation to /etc/hosts it shows the name in mysql admin proc. Iago Sineiro. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation: mysqladmin and mysqlshow missing
John Telford [EMAIL PROTECTED] wrote: I have had a problem with my install of MySQL on Rehat7.0 and I wonder if anyone has any advice. Here is what I have done. 1. When I installed RedHat, I installed the MySQL libraries from the RedHat CD. I think it was version 3.23 2. I installed the shared compat lib using rpm 3. I upgraded to version 4.0 using RPM I do have some of the scripts and the daemon, but I don't have any /usr/local/mysql directory. Do I need to just start completely from scratch? If so what would be the best approach. Any help anyone could provide would 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, too. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Warning: Host 'localhost.localdomain' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'
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 understrand that an interface is blocked when more than ten bad connects occur. On the shared hosting we share the same interface. My admin has responded by shutting down the other site till the scripts are fixed. He has also set cron job every hour to flush-hosts. How can i stop it happening? I am nervous that another user will clobber the whole server again. On my server the mysql.sock file is not present so i can not connect via unix sockets. Should I perhaps insist that I be able to connect via unix socket. It is my understanding that the unix socket does not have the same connection error counting. regards Marty martinATbarlowDOTname -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqladmin -u root -h myhost password 'new-password' fails
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 mysql_install_db is telling us to do something that doesn't work (and, even worse, leaves the [EMAIL PROTECTED] user without a password). So either mysql_install_db should be changed to say the right thing, or the command should be made to work :). I do not know enough to even guess what the underlying problem might be. Thanks, karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqladmin -u root -h myhost password 'new-password' fails
Description: I installed the 4.0.12-max binary distribution for x86-linux (got the same behavior with -standard). This was a brand new installation. When I ran scripts/mysql_install_db, it tells me: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/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, the second command, with the -h tug.org, fails, with the error message mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' More importantly, I can still run commands like mysqladmin -u root -h tug.org variables without being asked for a password. (By the way, I suggest adding this test to the other ones listed in the `General security' node.) When I inspected the user table as explained in the manual, there are lines for both localhost and tug.org, and only the localhost line has a password (which I've x'd it below): mysql select Host,User,Password from mysql.user WHERE User='root'; +---+--+--+ | Host | User | Password | +---+--+--+ | localhost | root | | | tug.org | root | | +---+--+--+ So I looked in the manual, but found no information on this error. I also tried searching the mailing lists at lists.mysql.com with no luck, although searching was so slow I couldn't be as thorough as I would liked to have been. I also searched for this on google[/groups] with no results, but found (not surprisingly) a number of other people reporting the exact same problem: http://groups.google.com/groups?q=mysqladmin+%22find+any+matching+row%22hl=enlr=ie=UTF-8oe=UTF-8selm=alig93%242t8e%241%40FreeBSD.csie.NCTU.edu.twrnum=3 http://groups.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8th=5bca2770813d0016rnum=6 http://groups.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8th=8a5b663b86b4373brnum=4 I expect I could explicitly set the password for [EMAIL PROTECTED] with set password. But the point is that the mysql_install_db script is telling me to do something that doesn't work. Any help appreciated ... How-To-Repeat: ... follow INSTALL-BINARY instructions and: ... root# mysqladmin -u root -h tug.org password mynewpassword mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' Submitter-Id: submitter ID Originator:Karl Berry Organization: MySQL support: none Synopsis: mysqladmin -u root -h myhost password 'new-password' fails Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.12-max (Official MySQL-max binary) Server: /usr/local/mysql/bin/mysqladmin Ver 8.40 Distrib 4.0.12, for pc-linux on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.12-max-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 37 min 7 sec Threads: 1 Questions: 52 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.023 C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux tug.org 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O2 -mpentiumpro -DBIG_TABLES' CXX='gcc' CXXFLAGS='-O2 -mpentiumpro -felide-constructors -DBIG_TABLES' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Aug 14 2002 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x2 root root 1285884 Aug 7 2002 /lib/libc-2.2.4.so -rw-r--r--1 root root 27336078 Aug 7 2002 /usr/lib/libc.a -rw-r--r--1 root root 178 Aug 7 2002 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official MySQL-max binary' '--with-extra-charsets=complex' '--with-server-suffix=-max' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-berkeley-db' '--with-raid' '--with-innodb' 'CFLAGS=-O2 -mpentiumpro -DBIG_TABLES' 'CXXFLAGS=-O2 -mpentiumpro -felide-constructors -DBIG_TABLES' 'CXX=gcc' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, but then when I used mysql -u root -h hostname -p and typed in the password, mysql also denied access saying the access was denied. The problem does not exist in mysql 3.23.56. Any help appreciated. Thanks Chee Wai --- [EMAIL PROTECTED] wrote: Description: I installed the 4.0.12-max binary distribution for x86-linux (got the same behavior with -standard). This was a brand new installation. When I ran scripts/mysql_install_db, it tells me: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/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, the second command, with the -h tug.org, fails, with the error message mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' More importantly, I can still run commands like mysqladmin -u root -h tug.org variables without being asked for a password. (By the way, I suggest adding this test to the other ones listed in the `General security' node.) When I inspected the user table as explained in the manual, there are lines for both localhost and tug.org, and only the localhost line has a password (which I've x'd it below): mysql select Host,User,Password from mysql.user WHERE User='root'; +---+--+--+ | Host | User | Password | +---+--+--+ | localhost | root | | | tug.org | root | | +---+--+--+ So I looked in the manual, but found no information on this error. I also tried searching the mailing lists at lists.mysql.com with no luck, although searching was so slow I couldn't be as thorough as I would liked to have been. I also searched for this on google[/groups] with no results, but found (not surprisingly) a number of other people reporting the exact same problem: http://groups.google.com/groups?q=mysqladmin+%22find+any+matching+row%22hl=enlr=ie=UTF-8oe=UTF-8selm=alig93%242t8e%241%40FreeBSD.csie.NCTU.edu.twrnum=3 http://groups.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8th=5bca2770813d0016rnum=6 http://groups.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8th=8a5b663b86b4373brnum=4 I expect I could explicitly set the password for [EMAIL PROTECTED] with set password. But the point is that the mysql_install_db script is telling me to do something that doesn't work. Any help appreciated ... How-To-Repeat: ... follow INSTALL-BINARY instructions and: ... root# mysqladmin -u root -h tug.org password mynewpassword mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' Submitter-Id:submitter ID Originator: Karl Berry Organization: MySQL support: none Synopsis:mysqladmin -u root -h myhost password 'new-password' fails Severity:non-critical Priority:medium Category:mysql Class: sw-bug Release: mysql-4.0.12-max (Official MySQL-max binary) Server: /usr/local/mysql/bin/mysqladmin Ver 8.40 Distrib 4.0.12, for pc-linux on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version4.0.12-max-log Protocol version 10 ConnectionLocalhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 37 min 7 sec Threads: 1 Questions: 52 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.023 C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux tug.org 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O2 -mpentiumpro -DBIG_TABLES' CXX='gcc' CXXFLAGS='-O2 -mpentiumpro -felide-constructors -DBIG_TABLES' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Aug 14 2002 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x2 root root 1285884 Aug 7 2002 /lib/libc-2.2.4.so -rw-r--r--1 root root 27336078 Aug 7 2002 /usr/lib/libc.a -rw-r--r--1 root root 178 Aug 7 2002 /usr/lib/libc.so Configure command
RE: mysqladmin -u root -h myhost password 'new-password' fails
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 -Original Message- From: Chee-Wai Yeung [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 5:09 PM To: [EMAIL PROTECTED]; [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, but then when I used mysql -u root -h hostname -p and typed in the password, mysql also denied access saying the access was denied. The problem does not exist in mysql 3.23.56. Any help appreciated. Thanks Chee Wai --- [EMAIL PROTECTED] wrote: Description: I installed the 4.0.12-max binary distribution for x86-linux (got the same behavior with -standard). This was a brand new installation. When I ran scripts/mysql_install_db, it tells me: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/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, the second command, with the -h tug.org, fails, with the error message mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' More importantly, I can still run commands like mysqladmin -u root -h tug.org variables without being asked for a password. (By the way, I suggest adding this test to the other ones listed in the `General security' node.) When I inspected the user table as explained in the manual, there are lines for both localhost and tug.org, and only the localhost line has a password (which I've x'd it below): mysql select Host,User,Password from mysql.user WHERE User='root'; +---+--+--+ | Host | User | Password | +---+--+--+ | localhost | root | | | tug.org | root | | +---+--+--+ So I looked in the manual, but found no information on this error. I also tried searching the mailing lists at lists.mysql.com with no luck, although searching was so slow I couldn't be as thorough as I would liked to have been. I also searched for this on google[/groups] with no results, but found (not surprisingly) a number of other people reporting the exact same problem: http://groups.google.com/groups?q=mysqladmin+%22find+any+matching+row%22hl= enlr=ie=UTF-8oe=UTF-8selm=alig93%242t8e%241%40FreeBSD.csie.NCTU.edu.twr num=3 http://groups.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8th=5bca2770813d0 016rnum=6 http://groups.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8th=8a5b663b86b43 73brnum=4 I expect I could explicitly set the password for [EMAIL PROTECTED] with set password. But the point is that the mysql_install_db script is telling me to do something that doesn't work. Any help appreciated ... How-To-Repeat: ... follow INSTALL-BINARY instructions and: ... root# mysqladmin -u root -h tug.org password mynewpassword mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' Submitter-Id:submitter ID Originator: Karl Berry Organization: MySQL support: none Synopsis:mysqladmin -u root -h myhost password 'new-password' fails Severity:non-critical Priority:medium Category:mysql Class: sw-bug Release: mysql-4.0.12-max (Official MySQL-max binary) Server: /usr/local/mysql/bin/mysqladmin Ver 8.40 Distrib 4.0.12, for pc-linux on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version4.0.12-max-log Protocol version 10 ConnectionLocalhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 37 min 7 sec Threads: 1 Questions: 52 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.023 C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux tug.org 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O2 -mpentiumpro -DBIG_TABLES' CXX='gcc' CXXFLAGS='-O2 -mpentiumpro -felide
where is mysqladmin?
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 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? -- John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: where is mysqladmin?
At 17:50 + 3/21/03, John Poltorak wrote: Hi, I'm new to the list having just tried to install MySQL v4.0 onto Linux Redhat v7.3 using an RPM distribution. You need to install both the server *and* the client RPM files. 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 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://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqladmin processlist = weird in version 4.0.12
-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 +-+-+--+--+ | Id | User| Host | db | Command +-+-+--+--+ | 530 | fcgi| 146.101.143.72:48753 | multimap | Sleep | 536 | fcgi| 146.101.143.72:48139 | multimap | Sleep | 545 | fcgi| 146.101.143.72:45618 | multimap | Sleep | 556 | fcgi| 146.101.143.72:49311 | multimap | Sleep | 570 | fcgi| 146.101.143.72:40745 | multimap | Sleep It used to show: +-+-+---+--+ | Id | User| Host | db | Command +-+-+---+--+ | 530 | fcgi| host1 | multimap | Sleep | 536 | fcgi| host2 | multimap | Sleep | 545 | fcgi| host3 | multimap | Sleep | 556 | fcgi| host2 | multimap | Sleep | 570 | fcgi| host3 | multimap | Sleep Any ideas anyone? It seems to be a bug - I've now entered it into our bug database: http://bugs.mysql.com/?id=164 Thanks for spotting this! It will be fixed for the next release. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE+eHtWSVDhKrJykfIRArHvAJ9WmjFwoNDOoLI6/Qi2CSOhUYniGgCfTzNI C8D5o3fmmpnjMMR13SxZ4HU= =gn2i -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqladmin processlist = weird in version 4.0.12
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 +-+-+--+--+ | 530 | fcgi| 146.101.143.72:48753 | multimap | Sleep | 536 | fcgi| 146.101.143.72:48139 | multimap | Sleep | 545 | fcgi| 146.101.143.72:45618 | multimap | Sleep | 556 | fcgi| 146.101.143.72:49311 | multimap | Sleep | 570 | fcgi| 146.101.143.72:40745 | multimap | Sleep It used to show: +-+-+---+--+ | Id | User| Host | db | Command +-+-+---+--+ | 530 | fcgi| host1 | multimap | Sleep | 536 | fcgi| host2 | multimap | Sleep | 545 | fcgi| host3 | multimap | Sleep | 556 | fcgi| host2 | multimap | Sleep | 570 | fcgi| host3 | multimap | Sleep Any ideas anyone? Cheers, Andrew mysql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqladmin processlist = weird in version 4.0.12
The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of messages ago): Functionality added or changed: * `SHOW PROCESSLIST' will now include the client TCP port after the hostname to make it easier to know from which client the request originated. I guess whenever 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 +-+-+--+--+ | Id | User| Host | db | Command +-+-+--+--+ | 530 | fcgi| 146.101.143.72:48753 | multimap | Sleep | 536 | fcgi| 146.101.143.72:48139 | multimap | Sleep | 545 | fcgi| 146.101.143.72:45618 | multimap | Sleep | 556 | fcgi| 146.101.143.72:49311 | multimap | Sleep | 570 | fcgi| 146.101.143.72:40745 | multimap | Sleep It used to show: +-+-+---+--+ | Id | User| Host | db | Command +-+-+---+--+ | 530 | fcgi| host1 | multimap | Sleep | 536 | fcgi| host2 | multimap | Sleep | 545 | fcgi| host3 | multimap | Sleep | 556 | fcgi| host2 | multimap | Sleep | 570 | fcgi| host3 | multimap | Sleep Any ideas anyone? Cheers, Andrew mysql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysqladmin processlist = weird in version 4.0.12
It says in the change log that it added the port to make it easier to see where the connection is coming from. 146.101.143.72:48753 gives you a lot more information than host1 From the release announcement -- * `SHOW PROCESSLIST' will now include the client TCP port after the hostname 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 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 +-+-+--+--+ | 530 | fcgi| 146.101.143.72:48753 | multimap | Sleep | 536 | fcgi| 146.101.143.72:48139 | multimap | Sleep | 545 | fcgi| 146.101.143.72:45618 | multimap | Sleep | 556 | fcgi| 146.101.143.72:49311 | multimap | Sleep | 570 | fcgi| 146.101.143.72:40745 | multimap | Sleep It used to show: +-+-+---+--+ | Id | User| Host | db | Command +-+-+---+--+ | 530 | fcgi| host1 | multimap | Sleep | 536 | fcgi| host2 | multimap | Sleep | 545 | fcgi| host3 | multimap | Sleep | 556 | fcgi| host2 | multimap | Sleep | 570 | fcgi| host3 | multimap | Sleep Any ideas anyone? Cheers, Andrew mysql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysqladmin processlist = weird in version 4.0.12
Hi, I do understand what you're saying and I did read the 4.0.12 changelog and appreciate the addition of the TCP port in that display, but all the hostnames in the processlist are displaying as the localhost of the mysql server that they are connecting to instead of the hostnames of the server 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 processlist = weird in version 4.0.12 The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of messages ago): Functionality added or changed: * `SHOW PROCESSLIST' will now include the client TCP port after the hostname to make it easier to know from which client the request originated. I guess whenever 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 +-+-+--+--+ | Id | User| Host | db | Command +-+-+--+--+ | 530 | fcgi| 146.101.143.72:48753 | multimap | Sleep | 536 | fcgi| 146.101.143.72:48139 | multimap | Sleep | 545 | fcgi| 146.101.143.72:45618 | multimap | Sleep | 556 | fcgi| 146.101.143.72:49311 | multimap | Sleep | 570 | fcgi| 146.101.143.72:40745 | multimap | Sleep It used to show: +-+-+---+--+ | Id | User| Host | db | Command +-+-+---+--+ | 530 | fcgi| host1 | multimap | Sleep | 536 | fcgi| host2 | multimap | Sleep | 545 | fcgi| host3 | multimap | Sleep | 556 | fcgi| host2 | multimap | Sleep | 570 | fcgi| host3 | multimap | Sleep Any ideas anyone? Cheers, Andrew mysql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysqladmin processlist = weird in version 4.0.12
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 read the 4.0.12 changelog and appreciate the addition of the TCP port in that display, but all the hostnames in the processlist are displaying as the localhost of the mysql server that they are connecting to instead of the hostnames of the server 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 processlist = weird in version 4.0.12 The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of messages ago): Functionality added or changed: * `SHOW PROCESSLIST' will now include the client TCP port after the hostname to make it easier to know from which client the request originated. I guess whenever 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 +-+-+--+--+ | Id | User| Host | db | Command +-+-+--+--+ | 530 | fcgi| 146.101.143.72:48753 | multimap | Sleep | 536 | fcgi| 146.101.143.72:48139 | multimap | Sleep | 545 | fcgi| 146.101.143.72:45618 | multimap | Sleep | 556 | fcgi| 146.101.143.72:49311 | multimap | Sleep | 570 | fcgi| 146.101.143.72:40745 | multimap | Sleep It used to show: +-+-+---+--+ | Id | User| Host | db | Command +-+-+---+--+ | 530 | fcgi| host1 | multimap | Sleep | 536 | fcgi| host2 | multimap | Sleep | 545 | fcgi| host3 | multimap | Sleep | 556 | fcgi| host2 | multimap | Sleep | 570 | fcgi| host3 | multimap | Sleep Any ideas anyone? Cheers, Andrew mysql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqladmin password has no effect in 4.0.10 gamma max-nt.
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 user's password. After running this command, with or without mysqadmin -u root reload, I am still able to: 1) Connect using mysql mysql -u root 2) Shut down using mysqladmin -u root shutdown Fix: I fixed the problem using mysql mysql -u root update user set password=PASSWORD('your_password') where user='root'; flush privileges; However, this does not change the fact that mysqladmin appears to be bugged. Release: MySQL 4.0.10. Executable: mysql-max-nt running as a service Environment: 1) Toshiba Laptop, 1.1 GHz PIII, 256 RAM, 30 GBHD. 2) Dell PowerEdge Server, dual 1.2 GHz P Xeon, 2 GB Ram, 200 GBHD System: 1) Windows XP Home 2) Windows 2000 Server Compiler: Binary distribution. Thanks! Dan Ertman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 'mysqladmin slave-st(art|op)' - is it implemented?
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)' - is it implemented? 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, and can't find any mention of them in there... Can anyone tell me whether these options for mysqladmin are implemented? If not, can anyone tell me whether I can tell mysqld to stop or start replicating from a shell script rather than the mysql client? Thanks in advance, Guy. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
'mysqladmin slave-st(art|op)' - is it implemented?
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, and can't find any mention of them in there... Can anyone tell me whether these options for mysqladmin are implemented? If not, can anyone tell me whether I can tell mysqld to stop or start replicating from a shell script rather than the mysql client? Thanks in advance, Guy. -- Guy Waugh Unix Team Information Technology Telecommunication Services Southern Cross University P.O. Box 157 Lismore NSW 2480 Ph: 61 2 6620 3196 Fax: 61 2 6620 3033 www.scu.edu.au/admin/it -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php