// 5.6.24 // Build used commit: 97543660999308893335d81b92307c389e6821a5 date: 2015-03-25 17:22:45 +0100 build-date: 2015-03-25 17:26:48 +0100 short: 9754366 branch: mysql-5.6.24-release MySQL source 5.6.24 // Conf file used [mysqld_multi] mysqld = /export/umesh/server/binaries/mysql-5.6.24/bin/mysqld_safe mysqladmin = /export/umesh/server/binaries/mysql-5.6.24/bin/mysqladmin user = root #password = log = /export/umesh/server/binaries/mysql-5.6.24/run/multi.log [mysqld2] socket = /tmp/mysql_ushastry_mysqld2.sock port = 3307 pid-file = /export/umesh/server/binaries/mysql-5.6.24/run/mysqld2.pid log_error = /export/umesh/server/binaries/mysql-5.6.24/run/mysqld2.log basedir = /export/umesh/server/binaries/mysql-5.6.24 datadir = /export/umesh/server/binaries/mysql-5.6.24/data2 language = /export/umesh/server/binaries/mysql-5.6.24/share/english user = umshastr [mysqld3] socket = /tmp/mysql_ushastry_mysqld3.sock port = 3308 pid-file = /export/umesh/server/binaries/mysql-5.6.24/run/mysqld3.pid log_error = /export/umesh/server/binaries/mysql-5.6.24/run/mysqld3.log basedir = /export/umesh/server/binaries/mysql-5.6.24 datadir = /export/umesh/server/binaries/mysql-5.6.24/data3 language = /export/umesh/server/binaries/mysql-5.6.24/share/english user = umshastr [mysqld4] socket = /tmp/mysql_ushastry_mysqld4.sock port = 3309 pid-file = /export/umesh/server/binaries/mysql-5.6.24/run/mysqld4.pid log_error = /export/umesh/server/binaries/mysql-5.6.24/run/mysqld4.log basedir = /export/umesh/server/binaries/mysql-5.6.24 datadir = /export/umesh/server/binaries/mysql-5.6.24/data4 language = /export/umesh/server/binaries/mysql-5.6.24/share/english user = umshastr [mysqld5] socket = /tmp/mysql_ushastry_mysqld5.sock port = 3310 pid-file = /export/umesh/server/binaries/mysql-5.6.24/run/mysqld5.pid log_error = /export/umesh/server/binaries/mysql-5.6.24/run/mysqld5.log basedir = /export/umesh/server/binaries/mysql-5.6.24 datadir = /export/umesh/server/binaries/mysql-5.6.24/data5 language = /export/umesh/server/binaries/mysql-5.6.24/share/english user = umshastr ############ Datadir initializtion [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: scripts/mysql_install_db --datadir=/export/umesh/server/binaries/mysql-5.6.24/data2 . [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: scripts/mysql_install_db --datadir=/export/umesh/server/binaries/mysql-5.6.24/data3 . [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: scripts/mysql_install_db --datadir=/export/umesh/server/binaries/mysql-5.6.24/data4 . [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: scripts/mysql_install_db --datadir=/export/umesh/server/binaries/mysql-5.6.24/data5 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: ############ Startup each nodes (make sure my_print_defaults is available and in your path.) [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is not running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: bin/mysqld_multi --defaults-file=./my.cnf start 2 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is running MySQL server from group: mysqld3 is not running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: ps aux|grep mysqld umshastr 22393 0.0 0.0 113240 1612 pts/0 S 09:49 0:00 /bin/sh /export/umesh/server/binaries/mysql-5.6.24/bin/mysqld_safe --socket=/tmp/mysql_ushastry_mysqld2.sock --port=3307 --pid-file=/export/umesh/server/binaries/mysql-5.6.24/run/mysqld2.pid --log_error=/export/umesh/server/binaries/mysql-5.6.24/run/mysqld2.log --basedir=/export/umesh/server/binaries/mysql-5.6.24 --datadir=/export/umesh/server/binaries/mysql-5.6.24/data2 --language=/export/umesh/server/binaries/mysql-5.6.24/share/english --user=umshastr umshastr 22621 0.3 0.1 1076000 450140 pts/0 Sl 09:49 0:00 /export/umesh/server/binaries/mysql-5.6.24/bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.6.24 --datadir=/export/umesh/server/binaries/mysql-5.6.24/data2 --plugin-dir=/export/umesh/server/binaries/mysql-5.6.24/lib/plugin --language=/export/umesh/server/binaries/mysql-5.6.24/share/english --log-error=/export/umesh/server/binaries/mysql-5.6.24/run/mysqld2.log --pid-file=/export/umesh/server/binaries/mysql-5.6.24/run/mysqld2.pid --socket=/tmp/mysql_ushastry_mysqld2.sock --port=3307 umshastr 23005 0.0 0.0 112624 972 pts/0 S+ 09:52 0:00 grep --color=auto mysqld [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: bin/mysql -u root -p -S/tmp/mysql_ushastry_mysqld2.sock Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.24 MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show variables like 'port'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | port | 3307 | +---------------+-------+ 1 row in set (0.00 sec) mysql> ## Stop node 2 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is running MySQL server from group: mysqld3 is not running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: bin/mysqld_multi --defaults-file=./my.cnf stop 2 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is not running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: ps aux|grep mysqld umshastr 23047 0.0 0.0 112624 968 pts/0 S+ 09:52 0:00 grep --color=auto mysqld [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: ## Set root password, and then attempt to start/stop [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is not running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: bin/mysqld_multi --defaults-file=./my.cnf start 5 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is not running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: ps aux|grep mysqld umshastr 27210 0.0 0.0 113240 1624 pts/0 S 10:40 0:00 /bin/sh /export/umesh/server/binaries/mysql-5.6.24/bin/mysqld_safe --socket=/tmp/mysql_ushastry_mysqld5.sock --port=3310 --pid-file=/export/umesh/server/binaries/mysql-5.6.24/run/mysqld5.pid --log_error=/export/umesh/server/binaries/mysql-5.6.24/run/mysqld5.log --basedir=/export/umesh/server/binaries/mysql-5.6.24 --datadir=/export/umesh/server/binaries/mysql-5.6.24/data5 --language=/export/umesh/server/binaries/mysql-5.6.24/share/english --user=umshastr umshastr 27438 4.4 0.1 1076012 449392 pts/0 Sl 10:40 0:00 /export/umesh/server/binaries/mysql-5.6.24/bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.6.24 --datadir=/export/umesh/server/binaries/mysql-5.6.24/data5 --plugin-dir=/export/umesh/server/binaries/mysql-5.6.24/lib/plugin --language=/export/umesh/server/binaries/mysql-5.6.24/share/english --log-error=/export/umesh/server/binaries/mysql-5.6.24/run/mysqld5.log --pid-file=/export/umesh/server/binaries/mysql-5.6.24/run/mysqld5.pid --socket=/tmp/mysql_ushastry_mysqld5.sock --port=3310 umshastr 27477 0.0 0.0 112624 968 pts/0 S+ 10:40 0:00 grep --color=auto mysqld [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: bin/mysql -u root -p -S/tmp/mysql_ushastry_mysqld5.sock Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.24 MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show variables like 'port'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | port | 3310 | +---------------+-------+ 1 row in set (0.00 sec) mysql> UPDATE mysql.user SET Password = PASSWORD('123456') WHERE User = 'root'; Query OK, 4 rows affected (0.00 sec) Rows matched: 4 Changed: 4 Warnings: 0 mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql> \q Bye [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: vi my.cnf [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: cat my.cnf|grep password password = 123456 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is not running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: bin/mysqld_multi --defaults-file=./my.cnf stop 5 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is not running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: ps aux|grep mysqld umshastr 27862 0.0 0.0 112624 972 pts/0 S+ 10:43 0:00 grep --color=auto mysqld [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.24: ######################## // 5.6.25 // Build used commit: 9294a4969387cd882ef2ae3ee001aed9ecd13616 date: 2015-05-05 12:50:42 +0200 build-date: 2015-05-05 12:54:12 +0200 short: 9294a49 branch: mysql-5.6.25-release MySQL source 5.6.25 // Conf file used [mysqld_multi] mysqld = /export/umesh/server/binaries/mysql-5.6.25/bin/mysqld_safe mysqladmin = /export/umesh/server/binaries/mysql-5.6.25/bin/mysqladmin user = root #password = log = /export/umesh/server/binaries/mysql-5.6.25/run/multi.log [mysqld2] socket = /tmp/mysql_ushastry_mysqld2.sock port = 3307 pid-file = /export/umesh/server/binaries/mysql-5.6.25/run/mysqld2.pid log_error = /export/umesh/server/binaries/mysql-5.6.25/run/mysqld2.log basedir = /export/umesh/server/binaries/mysql-5.6.25 datadir = /export/umesh/server/binaries/mysql-5.6.25/data2 language = /export/umesh/server/binaries/mysql-5.6.25/share/english user = umshastr [mysqld3] socket = /tmp/mysql_ushastry_mysqld3.sock port = 3308 pid-file = /export/umesh/server/binaries/mysql-5.6.25/run/mysqld3.pid log_error = /export/umesh/server/binaries/mysql-5.6.25/run/mysqld3.log basedir = /export/umesh/server/binaries/mysql-5.6.25 datadir = /export/umesh/server/binaries/mysql-5.6.25/data3 language = /export/umesh/server/binaries/mysql-5.6.25/share/english user = umshastr [mysqld4] socket = /tmp/mysql_ushastry_mysqld4.sock port = 3309 pid-file = /export/umesh/server/binaries/mysql-5.6.25/run/mysqld4.pid log_error = /export/umesh/server/binaries/mysql-5.6.25/run/mysqld4.log basedir = /export/umesh/server/binaries/mysql-5.6.25 datadir = /export/umesh/server/binaries/mysql-5.6.25/data4 language = /export/umesh/server/binaries/mysql-5.6.25/share/english user = umshastr [mysqld5] socket = /tmp/mysql_ushastry_mysqld5.sock port = 3310 pid-file = /export/umesh/server/binaries/mysql-5.6.25/run/mysqld5.pid log_error = /export/umesh/server/binaries/mysql-5.6.25/run/mysqld5.log basedir = /export/umesh/server/binaries/mysql-5.6.25 datadir = /export/umesh/server/binaries/mysql-5.6.25/data5 language = /export/umesh/server/binaries/mysql-5.6.25/share/english user = umshastr ############ Startup each nodes (make sure my_print_defaults is available and in your path.) [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: scripts/mysql_install_db --datadir=/export/umesh/server/binaries/mysql-5.6.25/data2 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: scripts/mysql_install_db --datadir=/export/umesh/server/binaries/mysql-5.6.25/data3 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: scripts/mysql_install_db --datadir=/export/umesh/server/binaries/mysql-5.6.25/data4 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: scripts/mysql_install_db --datadir=/export/umesh/server/binaries/mysql-5.6.25/data5 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is not running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running // Start node 3 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is not running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysqld_multi --defaults-file=./my.cnf start 3 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysql -u root -p -S/tmp/mysql_ushastry_mysqld3.sock Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.25 MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show variables like 'port'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | port | 3308 | +---------------+-------+ 1 row in set (0.00 sec) mysql> \q Bye [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: ps aux|grep mysqld umshastr 23983 0.0 0.0 113240 1612 pts/0 S 10:02 0:00 /bin/sh /export/umesh/server/binaries/mysql-5.6.25/bin/mysqld_safe --socket=/tmp/mysql_ushastry_mysqld3.sock --port=3308 --pid-file=/export/umesh/server/binaries/mysql-5.6.25/run/mysqld3.pid --log_error=/export/umesh/server/binaries/mysql-5.6.25/run/mysqld3.log --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/export/umesh/server/binaries/mysql-5.6.25/data3 --language=/export/umesh/server/binaries/mysql-5.6.25/share/english --user=umshastr umshastr 24213 0.8 0.1 1076012 450184 pts/0 Sl 10:02 0:00 /export/umesh/server/binaries/mysql-5.6.25/bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/export/umesh/server/binaries/mysql-5.6.25/data3 --plugin-dir=/export/umesh/server/binaries/mysql-5.6.25/lib/plugin --language=/export/umesh/server/binaries/mysql-5.6.25/share/english --log-error=/export/umesh/server/binaries/mysql-5.6.25/run/mysqld3.log --pid-file=/export/umesh/server/binaries/mysql-5.6.25/run/mysqld3.pid --socket=/tmp/mysql_ushastry_mysqld3.sock --port=3308 umshastr 24258 0.0 0.0 112624 972 pts/0 S+ 10:02 0:00 grep --color=auto mysqld [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysqld_multi --defaults-file=./my.cnf stop 3 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is not running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: ps aux|grep mysqld umshastr 24284 0.0 0.0 112624 972 pts/0 S+ 10:03 0:00 grep --color=auto mysqld [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: ## Changed root password(earlier using blank password) [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is not running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysqld_multi --defaults-file=./my.cnf start 3 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysql -u root -p -S/tmp/mysql_ushastry_mysqld3.sock Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.25 MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> UPDATE mysql.user SET Password = PASSWORD('123456') WHERE User = 'root'; Query OK, 4 rows affected (0.00 sec) Rows matched: 4 Changed: 4 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> \q Bye [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: vi my.cnf [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: cat my.cnf|grep password password = 123456 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysqld_multi --defaults-file=./my.cnf stop 3 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysqld_multi --defaults-file=./my.cnf report Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: ps aux|grep mysqld umshastr 24309 0.0 0.0 113240 1612 pts/0 S 10:04 0:00 /bin/sh /export/umesh/server/binaries/mysql-5.6.25/bin/mysqld_safe --socket=/tmp/mysql_ushastry_mysqld3.sock --port=3308 --pid-file=/export/umesh/server/binaries/mysql-5.6.25/run/mysqld3.pid --log_error=/export/umesh/server/binaries/mysql-5.6.25/run/mysqld3.log --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/export/umesh/server/binaries/mysql-5.6.25/data3 --language=/export/umesh/server/binaries/mysql-5.6.25/share/english --user=umshastr umshastr 24535 0.3 0.1 1076012 450232 pts/0 Sl 10:04 0:00 /export/umesh/server/binaries/mysql-5.6.25/bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/export/umesh/server/binaries/mysql-5.6.25/data3 --plugin-dir=/export/umesh/server/binaries/mysql-5.6.25/lib/plugin --language=/export/umesh/server/binaries/mysql-5.6.25/share/english --log-error=/export/umesh/server/binaries/mysql-5.6.25/run/mysqld3.log --pid-file=/export/umesh/server/binaries/mysql-5.6.25/run/mysqld3.pid --socket=/tmp/mysql_ushastry_mysqld3.sock --port=3308 umshastr 24963 0.0 0.0 112624 972 pts/0 S+ 10:07 0:00 grep --color=auto mysqld // Warning: Using a password on the command line interface can be insecure. /export/umesh/server/binaries/mysql-5.6.25/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' mysqld_multi log file version 2.16; run: Tue Jun 9 10:08:47 2015 Reporting MySQL servers MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is running MySQL server from group: mysqld4 is not running MySQL server from group: mysqld5 is not running ## Able to shutdown with password using mysqladmin [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysqladmin -u root -p123456 -S/tmp/mysql_ushastry_mysqld3.sock shutdown Warning: Using a password on the command line interface can be insecure. [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: ps aux|grep mysqld umshastr 25064 0.0 0.0 112624 972 pts/0 S+ 10:11 0:00 grep --color=auto mysqld [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: