PHP & MySQL Settings in Webuzo

Switch PHP version

From the Webuzo Admin Panel (https://YOUR_IP:2004):

1. Go to PHP → PHP Configuration
2. Select the PHP version to activate
3. Click Save

To install additional PHP versions:

1. Admin Panel → PHP → PHP Versions
2. Click Install next to the version you want
3. Installation takes a few minutes

Customize php.ini

1. Admin Panel → PHP → PHP Configuration → php.ini Editor
2. Modify values directly
3. Save and restart the web server for changes to take effect

Key settings to review:

Setting	Recommended	Reason
memory_limit	512M	WordPress/WooCommerce
upload_max_filesize	64M	Media uploads
post_max_size	64M	Must be ≥ upload_max_filesize
max_execution_time	300	Long-running imports
display_errors	Off	Hide errors from visitors
error_log	/path/to/php-errors.log	Log errors to file

Per-directory PHP settings

Override specific php.ini values via .htaccess:

php_value memory_limit 512M
php_value upload_max_filesize 64M
php_flag display_errors off

Create a MySQL database

1. Log into Webuzo Enduser Panel (https://YOUR_IP:2002).
2. Go to Databases → MySQL Databases → Add Database.
3. Enter a database name.
4. Click Add Database.

Create a MySQL user

1. Go to Databases → MySQL Users → Add User.
2. Enter a username and strong password.
3. Click Add User.

Assign user to database

1. Go to Databases → MySQL Databases.
2. Find the database and click Add User to Database.
3. Select the user.
4. Select privileges: for most applications select All Privileges.
5. Click Add.

Access phpMyAdmin

1. Webuzo Enduser Panel → Databases → phpMyAdmin
2. Log in with your MySQL username and password
3. Manage tables, run queries, import/export databases

MySQL remote access

By default MySQL only accepts local connections. To allow remote access:

# Edit MySQL configuration
nano /etc/my.cnf

# Find and change:
bind-address = 0.0.0.0

# Restart MySQL
systemctl restart mysql

Then grant the user remote access in MySQL:

GRANT ALL ON database.* TO 'user'@'REMOTE_IP' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;