This VM is a LAMP Web Server with phpMyAdmin installed on Rokcy Linux 9.
This VM supports following versions.
- PHP 8.5
- Apache 2.4
- MariaDB 10.5
- phpMyAdmin 5.2
- WordPress 7
Security considerations
- Host firewall: Disabled. External access is restricted by Google Cloud firewall rules (http-server, https-server).
- SELinux: Permissive to avoid blocking Apache/PHP modules.
Web Server
We prepared SSL/TLS so you can access to top page using http:// or https://.
DB Server Password
You can also SSH into your instance and find the login credential using the following command.
$ cat /home/rocky/credentials ////////////////////credentials info////////////////////--- WordPress----- Setting : Success--- phpMyAdmin----- Setting : Success--- MariaDB----- User : root----- Password : ****************----- User : wordpress----- Password : ****************////////////////////////////////////////////////////////
phpMyAdmin
You can access to phpMyAdmin after creating ssh tunnel.
How to Set up SSH Tunneling (Port Forwarding)
ex.) create ssh tunnel
$ gcloud compute ssh --zone "us-west1-a" rocky@vm-instance-name --project "projectname" -- -N -L 8080:localhost:80
http://localhost:8080/phpMyAdmin/
For phpMyAdmin please refer to phpMyAdmin User Guide
Changing URL
You can change the WordPress URL by using wp-cli. You can change it by executing the following command after logging into the instance over SSH.
$ wp search-replace 'old_site_url' 'new_site_url' --path=/var/www/html/wordpress --skip-columns=guid
For example, when your instance IP was changed from xxx.xxx.xxx.xxx to yyy.yyy.yyy.yyy you can check URL as shown below: To update the URL, execute the following command:
$ wp search-replace xxx.xxx.xxx.xxx yyy.yyy.yyy.yyy --path=/var/www/html/wordpress --skip-columns=guid+------------------+-----------------------+--------------+------+| Table | Column | Replacements | Type |+------------------+-----------------------+--------------+------+| wp_commentmeta | meta_key | 0 | SQL || wp_commentmeta | meta_value | 0 | SQL || wp_comments | comment_author | 0 | SQL |<...>| wp_options | option_value | 2 | PHP || wp_options | autoload | 0 | SQL || wp_postmeta | meta_key | 0 | SQL |<...>| wp_users | user_url | 1 | SQL || wp_users | user_activation_key | 0 | SQL || wp_users | display_name | 0 | SQL |+------------------+-----------------------+--------------+------+Success: Made 8 replacements.