Solution to MySQL failure caused by VestaCP installation

Problem Description

The following error is reported when you use the official command (how to install) to install VestCP:

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/bin/mysqladmin-u root password 'new-password'
/Usr/bin/mysqladmin-u root-h 16 password 'new-password'

Alternatively you can run:
/Usr/bin/mysql_secure_installation

Which will also give you the option of removing the test
Databases and anonymous user created by default. This is
Stronugly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon:
Cd/usr;/usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
Mysql-test-run.pl for cd/usr/mysql-test; perl

Please report any problems at http://bugs.mysql.com/

Update-rc.d: using dependency based boot sequencing
[FAIL] Starting MySQL database server: mysqld ...... failed!
Error: mysql start failed

The following error was found when I restarted mysql using the service MySQL restart command,

[OK] Stopping MySQL database server: mysqld.
[...] Starting MySQL database server: mysqld/usr/sbin/mysqld: error while loading shared libraries: libcrypt. so.1: cannot map zero-fill pages: Cannot allocate memory
[. K
[Info] Checking for tables which need an upgrade, are both UPT or were
Not closed cleanly ..
Or

[OK] Stopping MySQL database server: mysqld.
[FAIL] Starting MySQL database server: mysqld ...... failed!

Solution process

Enter the MySQL error log (default directory/var/log/mysql/error. log or view/etc/MySQL/my. cnf in the mysql configuration file)

The following error records are found:

InnoDB: Error: pthread_create returned 11

Therefore, it was determined that it was caused by InnoDB. Use the following command to solve the problem:

Ulimit-s unlimited

To solve the problem, you can also disable innodb (if this function is not required.

If you encounter the same problem when installing VestaCP, the problem has been resolved and you can continue (force) to install VestaCP.

Bash vst-install-debian.sh -- force