在原有3306端口mysqld服务的情况再搭建第二个3308端口的mysql实例(四)
relay-log-index = /data56m1/mysql-relay-bin.index
skip-external-locking
bind-address = 0.0.0.0
log_bin_trust_function_creators=1
binlog_format=mixed
log_slave_updates=1
innodb_flush_log_at_trx_commit = 0
log-error = /data56m1/error.err
# These are commonly set, remove the # and set as required.sedir = /usr/local/mysql56m1
basedir = /usr/local/mysql56m1
datadir = /data56m1
log_error = /data56m1/error.err
innodb_file_per_table
server_id = 11
innodb_data_home_dir = /data56m1
innodb_data_file_path = ibdata01:1G:autoextend
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
8 init db
[root@472322 mysql56m1]# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql56m1 --datadir=/data56m1 --defaults-file=/etc/my56m1.cnf
Installing MySQL system tables...2013-09-12 01:21:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
OK
Filling help tables...2013-09-12 01:21:12 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/mysql56m1/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql56m1/bin/mysqladmin -u root -h 472322.com password 'new-password'
Alternatively you can run:
/usr/local/mysql56m1/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; /usr/local/mysql56m1/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl
Please report any problems with the ./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
New default config file was created as /usr/local/mysql56m1/my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings
9 copy start command
cp support-files/mysql.server /etc/init.d/mysqld56m1
chmod 700 /etc/init.d/mysqld56m1
echo "export PATH=$PATH:/usr/local/mysqld56m1/bin">
>/etc/profile
source /etc/profile
10 add command to system parameter
cd /data56m1
chkconfig --add mysqld56m1
11 start service
service mysqld56m1 start
[root@472322 data56m1]# service mysqld56m1 start
Starting MySQL.. ERROR! The server quit without updating PID file (/data56m1/472322.com.pid).
11.1 check data directory
[root@472322 data56m1]# ll
total 1160456
-rw-r----- 1 mysql root 5037 Sep 12 03:07 472322.com.err
-rw-rw---- 1 mysql mysql 56 Sep 12 02:58 auto.cnf
-rw-rw---- 1 mysql mysql 1073741824 Sep 12 03:02 ibdata01
-rw-rw---- 1 mysql mysql 12582912 Sep 12 03:07 ibdata1
-rw-rw---- 1 mysql mysql 50331648 Sep 12 03:07 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 Sep 12 03