For low memeory VPS (Free memeory less than 512MB ), our script use MyISAM instead of InnoDB by default
If you want enable InnoDB, please make sure your VPS memeory is enough to get mysql work.
Then, vi /etc/my.cnf, delete below 2 lines and restart mysql:
innodb=OFFdefault-storage-engine=MyISAM
If you see below error when restart mysql,
“InnoDB: Fatal error: cannot allocate the memory for the buffer pool”
You will need change some parameter eg. innodb_buffer_pool_size to use less memeory, restarted the MySQL and it was done , error gone .
Here are some useful tutorials of ComfortVPS Nginx+PHP+MySql Installation Service
How to find your password of SFTP and MySql root?
How to connect to SFTP? How to upload files?
How to create a Nginx website(how to add domain)?
How to access phpMyAdmin(how to control MySql database)?
How to stop Nginx server? How to start and restart Nginx via command line?
How to custom config a Nginx domain? Nginx configuration file location
How to stop/restart PHP-fpm?
How to custom config and optimize PHP-fpm?
How to enable InnoDB for MySql?
Note, We wrote these tutorials to save your time, but we do not...
If you are not good at SSH command and you want install Nginx PHP(php-fpm) MySql phpMyAdmin for your small website, you can use our Automatically install script of Nginx PHP(php-fpm) MySql in CentOS.
What's you need to do is: Copy and post/run below single command line via SSH root login. wait 5-15 minutes(depending on the software download speed from your server), Everything is Done!
wget --no-check-certificat -O /tmp/install-nginx-php-mysql.sh https://raw.github.com/ComfortVPS/Nginx-PHP-MySql-phpMyAdmin/master/install-nginx-php-mysql.sh; sh /tmp/install-nginx-php-mysql.sh;
The Auto installer of Nginx PHP(php-fpm) MySql only works on CentOS 5.x/6.x 32bit or 64bit now, work perfectly for Xen VPS ram >= 128MB. Recommand RAM(memory) is >= 256MB for CentOS 32bit and...