mysqld_multi — Manage Multiple MySQL Servers The password of the MySQL account to use when invoking  mysqladmin . Note that the password value is not optional for this option, unlike for other MySQL programs. Connect to each MySQL server through the TCP/IP port instead of the Unix socket file. (If a socket file is missing, the server might still be running, but accessible only through the TCP/IP port.) By default, connections are made using the Unix socket file. This option affects  stop  and  report  operations. Silent mode; disable warnings. The user name of the MySQL account to use when invoking  mysqladmin . Be more verbose. Display version information and exit. Some notes about  mysqld_multi : Make sure that the data directory for each server is fully accessible to the Unix account that the specific  mysqld  process is started as.  Do not  use the Unix  root account for this, unless you  know  what you are doing. See Section 6.1.5, “How to Run MySQL as a Normal User” . See Section 6.2, “Access Control and Account Management” . You have to do this for each  mysqld server. Change the connection parameters appropriately when connecting to each one. Note that the host name part of the account name must permit you to connect as  multi_admin  from the host where you want to run  mysqld_multi . 393 • --silent • --tcp-ip • --user= user_name • --verbose • --version • Most important : Before using  mysqld_multi  be sure that you understand the meanings of the options that are passed to the  mysqld  servers and  why  you would want to have separate  mysqld  processes. Beware of the dangers of using multiple  mysqld  servers with the same data directory. Use separate data directories, unless you  know  what you are doing. Starting multiple servers with the same data directory does  not  give you extra performance in a threaded system. See Section 5.8, “Running Multiple MySQL Instances on One Machine” . •Make sure that the MySQL account used for stopping the  mysqld  servers (with the  mysqladmin program) has the same user name and password for each server. Also, make sure that the account has the  SHUTDOWN  privilege. If the servers that you want to manage have different user names or passwords for the administrative accounts, you might want to create an account on each server that has the same user name and password. For example, you might set up a common  multi_admin  account by executing the following commands for each server: shell>  mysql -u root -S /tmp/mysql.sock -p Enter password: mysql>  CREATE USER ’multi_admin’@’localhost’ IDENTIFIED BY ’multipass’; mysql>  GRANT SHUTDOWN ON *.* TO ’multi_admin’@’localhost’; Important