this error indicates either root doesn't have sufficient privilege or the password entered was bad. try running it this way:
./mysqltuner.pl --user root --pass <password> Jeetendra Ranjan wrote: > Hi, > > I run the mysqltuner at my server as below and i got error like below. > [r...@127 /]# ./mysqltuner.pl > > >> MySQLTuner 1.0.1 - Major Hayden <ma...@mhtx.net> > >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ > >> Run with '--help' for additional options and output filtering > Please enter your MySQL administrative login: root > Please enter your MySQL administrative password: > [!!] Attempted to use login credentials, but they were invalid. > > On some other server this script is running absolutely fine without any > change in mysqltuner.pl. > > Please guide me how can i run this script > > > Thanks & Regards > Jeetendra Ranjan > > ----- Original Message ----- > From: "Bruce Ferrell" <bferr...@baywinds.org> > To: <jeetendra.ran...@sampatti.com> > Cc: <mysql@lists.mysql.com> > Sent: Thursday, October 15, 2009 12:20 PM > Subject: Re: Req. suitable .cnf file for Server used by 2000 users daily > > >> Have a look at mysqltuner. It reads the stats from a running mysql >> instances and makes suggestions for what can be changed >> >> http://blog.mysqltuner.com/ >> >> >> >> Gavin Towey wrote: >>> Hi, >>> >>> This script might help with some tuning suggestions, run it after you have >>> some production traffic running against your database. >>> https://launchpad.net/mysql-tuning-primer >>> >>> Also you should enable the slow query log, so you can capture queries to be >>> optimized: >>> http://dev.mysql.com/doc/mysql/en/Slow_query_log.html >>> >>> http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html >>> >>> >>> Regards, >>> Gavin Towey >>> >>> >>> -----Original Message----- >>> From: jeetendra.ran...@sampatti.com [mailto:jeetendra.ran...@sampatti.com] >>> Sent: Wednesday, October 14, 2009 3:21 AM >>> To: mysql@lists.mysql.com >>> Subject: Req. suitable .cnf file for Server used by 2000 users daily >>> >>> Hi, >>> Will you plesae guide me ? >>> We are about to launch one website whose database is in MySQL. I am very >>> exited about the server setting specially about .cnf file. >>> I have below hardware and .cnf details. Will you please guide me is the >>> .cnf file details sufficient to support current hardware. >>> Initially 2000 users will visit this site everyday. >>> >>> Hardware and OS >>> ************* >>> Operating System : Red Hat Fedora Core 8 >>> Processor : Intel Core 2 Quad - 2.83 GHz, >>> RAM : 4 GB >>> Total Disk Space : 600 GB (300 GB usable) >>> RAID : RAID1 >>> Disk Drive(s) : 300 GB (Drive #1), 300 GB (Drive #2) >>> Bandwidth Quota : 500 GB >>> Firewall : PIX 501 >>> Version : 5.0.81-community-log >>> Version_comment : MySQL Community Edition (GPL) >>> Version Compile Machine : i686 >>> Version Compile OS : pc-linux-gnu >>> my.cnf details >>> *********** >>> [mysqld] >>> datadir=/var/lib/mysql >>> socket=/var/lib/mysql/mysql.sock >>> user=mysql >>> # Default to using old password format for compatibility with mysql 3.x >>> # clients (those using the mysqlclient10 compatibility package). >>> old_passwords=1 >>> key_buffer = 16M >>> key_buffer_size=4M >>> sort_buffer_size=2M >>> query_cache_size=64M >>> log-bin >>> log_queries_not_using_indexes=1 >>> long_query_time=1 >>> log_slow_queries=slowQry.log >>> join_buffer_size=4M >>> max_connections=150 >>> max_allowed_packet = 32M >>> table_cache = 256 >>> net_buffer_length = 8K >>> read_buffer_size = 2M >>> read_rnd_buffer_size = 2M >>> myisam_sort_buffer_size = 8M >>> thread_stack=5M >>> thread_cache_size=128M >>> connect_timeout=30 >>> query_cache_limit=32M >>> log-error >>> # Comment the following if you are using InnoDB tables >>> innodb_data_home_dir = /var/lib/mysql/ >>> innodb_data_file_path = ibdata1:10M:autoextend >>> innodb_log_group_home_dir = /var/lib/mysql/ >>> # You can set .._buffer_pool_size up to 50 - 80 % >>> # of RAM but beware of setting memory usage too high >>> innodb_buffer_pool_size = 4M >>> innodb_additional_mem_pool_size = 2M >>> # Set .._log_file_size to 25 % of buffer pool size >>> innodb_log_file_size = 16M >>> innodb_log_buffer_size = 8M >>> innodb_flush_log_at_trx_commit = 1 >>> innodb_lock_wait_timeout = 50 >>> [mysqld_safe] >>> log-error=/var/log/mysqld.log >>> pid-file=/var/run/mysqld/mysqld.pid >>> Thanks in advance >>> Regards >>> Jeetendra Ranjan >>> >>> >>> The information contained in this transmission may contain privileged and >>> confidential information. It is intended only for the use of the person(s) >>> named above. If you are not the intended recipient, you are hereby notified >>> that any review, dissemination, distribution or duplication of this >>> communication is strictly prohibited. If you are not the intended >>> recipient, please contact the sender by reply email and destroy all copies >>> of the original message. >>> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
