Scene Restore:
Initialization
#/usr/local/webserver/mysql/bin/mysql_install_db--user=mysql--basedir=/usr/local/webserver/mysql/--datadir=/ Home/mysqldata
Installing MySQL system tables ...
150205 11:48:00 [Note] Flashcache bypass:disabled
150205 11:48:00 [Note] Flashcache Setup Error Is:ioctl failed
Ok
Filling Help Tables ...
150205 11:48:00 [Note] Flashcache bypass:disabled
150205 11:48:00 [Note] Flashcache Setup Error Is:ioctl failed
Ok
To start mysqld at boot time with to copy
Support-files/mysql.server to the right place for your system
REMEMBER to SET A PASSWORD for the MySQL root USER!
To does so, start the server, then issue the following commands:
/usr/local/webserver/mysql//bin/mysqladmin-u root password ' new-password '
/usr/local/webserver/mysql//bin/mysqladmin-u root-h kooxoo17.ktep3.kuxun.cn password ' new-password '
Alternatively you can run:
/usr/local/webserver/mysql//bin/mysql_secure_installation
Which would 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/webserver/mysql/; /usr/local/webserver/mysql//bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
Cd/usr/local/webserver/mysql//mysql-test; Perl mysql-test-run.pl
Problems with The/usr/local/webserver/mysql//scripts/mysqlbug script!
Percona recommends, all production deployments is protected with a support
Contract (http://www.percona.com/mysql-suppport/) to ensure the highest uptime,
be eligible for hot fixes, and boost your team ' s productivity.
Start
/usr/local/webserver/mysql/bin/mysqld_safe--defaults-file=/home/mysql_config/my.cnf--user=mysql--basedir=/usr/ local/webserver/mysql/--datadir=/home/mysqldata &
Not started successfully:
Look at the log error as follows:
150205 16:17:03 Mysqld_safe starting mysqld daemon with databases From/home/mysqldata
150205 16:17:03 [Warning] '--default-character-set ' is deprecated and'll be removed in a future release. Please use '--character-set-server ' instead.
150205 16:17:03 [Warning] '--log-long-format ' is deprecated and'll be removed in a future release. Please use '--log-short-format ' instead.
150205 16:17:03 [Warning] '--log_slow_queries ' is deprecated and'll be removed in a future release. Please use '--slow_query_log '/'--slow_query_log_file ' instead.
150205 16:17:03 [Warning]--myisam_max_extra_sort_file_size is deprecated and does nothing in this version. It'll be removed in a future release.
150205 16:17:03 [Note] Flashcache bypass:disabled
150205 16:17:03 [Note] Flashcache Setup Error Is:ioctl failed
150205 16:17:03 [Note] Flashcache Setup Error Is:ioctl failed
/usr/local/webserver/mysql/libexec/mysqld:file '/home/mysql_config/log/mysql-bin.index ' not Found (errcode:13)
File '/home/mysql_config/log/mysql-bin.index ' not Found (errcode:13)
150205 16:17:03 [ERROR] Aborting
150205 16:17:03 [Note]/usr/local/webserver/mysql/libexec/mysqld:shutdown complete
150205 16:17:03 mysqld_safe mysqld from PID File/home/mysql_config/run/mysql.pid ended
Reason:
Mkdir-p/home/mysql_config/log
Manually created this directory, then the default is root permission, MySQL cannot write, so will not generate mysql-bin.index this file.
Workaround:
Chown-r mysql.mysql /home/mysql_config/
MySQL Start error resolution-3