Or: # mysql -verbose -help|grep -A 1 'Default options' Use the following command to view the location of the configuration: # mysqld -verbose -help|grep -A 1 'Default options' To view the server startup log: # tail ġ90610 20:16:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysqlġ90610 20:16:57 You need to use -log-bin to make -binlog-format work.ġ90610 20:16:57 /usr/libexec/mysqld: Shutdown completeġ90610 20:16:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid endedĪs you can see, the two lines reported an error saying that the - binlog format option was turned on, but bin log was not turned on, so the MySQL process could not be started. Hhw_global ibdata1 ib_logfile0 ib_logfile1 mysql mysql.sock test On CentOS, start MySQL with the command: Service mysqld restart # service mysqld restartĮnter the MySQL related directory to view: # cd /var/lib/mysql/
0 Comments
Leave a Reply. |