We’re here to help and answer any question you might have. We look forward to hearing from you.

Setting up MySQL on AWS with Lucee involves deploying a MySQL database integrating it with the Lucee server. By doing so, you can create a robust and scalable environment for hosting dynamic web applications. With AWS handling the database management and Lucee providing the server-side scripting capabilities, you can enjoy the benefits of a reliable and efficient setup for your web development needs.

MySQL Setup on AWS with Lucee

What will you do

    1. Installing  Mysql on AWS with Lucee
    2. Configure MySQL database for WordPress

Requirements

  1. An active AWS account.
  2. Provisioned EC2 instance for hosting Lucee server.
  3. MySQL database configured on AWS RDS.
  4. Security group configuration to allow necessary ports.
  5. Lucee installation and integration with MySQL database.
Command 1sudo apt-get update
Command 2
sudo apt-get install openjdk-“version”-jdk (openjdk-8-jdk)*
Choose any version and replace with “version” in above command.
Command 1

wget https://cdn.lucee.org/lucee-5.3.10.120-linux-x64-installer.run

 * you can go to https://download.lucee.org/ and check version accordingily.*
 chmod +x lucee-5.3.8.189-linux-x64-installer.run
Command 1sudo ./lucee-5.3.8.189-linux-x64-installer.run
Command 1sudo service lucee_ctl start
opt/lucee/tomcat/webapps/ROOT/ directory
You see your page by visiting http://localhost:8888/page_name.cfm (replace localhost by you ip/domain)

To install My SQL, follow these steps:

Command 1sudo apt update
Command 2sudo apt install mysql-server

 

Command 1sudo systemctl start mysql
Command 1sudo systemctl status mysql

If you want to create a new user for MySQL follow steps below.

Command 1sudo mysql -u root -p
Command 1CREATE USER ‘newuser’@’localhost’ IDENTIFIED BY ‘password’;



Command 1GRANT ALL PRIVILEGES ON *.* TO ‘newuser’@’localhost’;
Command 1

sudo ln -s mysql-connector-java-8.0.26.jar mysql-connector-java.jar/

Connect Lucee with database as following :

To install PHP and PHPMyAdmin, follow these steps:

Command 1sudo apt install libapache2-mod-php
Command 1sudo systemctl restart apache2
 
Command 1sudo a2enmod php (use php with version like php8.x or php7.x)
Command 1sudo apt install phpmyadmin
Command 1sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin
Command 1sudo systemctl restart apache2

Trust and Worth

Our Customers

We are having a diversified portfolio and serving customers in the domains namely Sports Management, Online Laundry System, Matrimonial, US Mortgage, EdTech and so on.

Would you like to start a project with us?

DAStek team would be happy to hear from you and would love to turn your ‘Imaginations to Reality’.