MySQL Start error resolution-3

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.