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
- Installing Mysql on AWS with Lucee
- Configure MySQL database for WordPress
Requirements
- An active AWS account.
- Provisioned EC2 instance for hosting Lucee server.
- MySQL database configured on AWS RDS.
- Security group configuration to allow necessary ports.
- Lucee installation and integration with MySQL database.
Command 1 | sudo 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 1 | sudo ./lucee-5.3.8.189-linux-x64-installer.run |
Command 1 | sudo service lucee_ctl start |
Command 1 | sudo ufw allow 8888/tcp |
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 1 | sudo apt update |
Command 2 | sudo apt install mysql-server |
Command 1 | sudo systemctl start mysql |
Command 1 | sudo systemctl enable mysql |
Command 1 | sudo systemctl status mysql |
If you want to create a new user for MySQL follow steps below.
Command 1 | sudo mysql -u root -p |
Command 1 | CREATE USER ‘newuser’@’localhost’ IDENTIFIED BY ‘password’; |
Command 1 | GRANT ALL PRIVILEGES ON *.* TO ‘newuser’@’localhost’; |
Command 1 | FLUSH PRIVILEGES; |
Command 1 | EXIT; |
Command 1 | sudo apt-get install libmysql-java |
cd /usr/share/java/ |
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 1 | sudo apt install libapache2-mod-php |
Command 1 | sudo systemctl restart apache2 |
Command 1 | sudo a2enmod php (use php with version like php8.x or php7.x) |
Command 1 | sudo apt install phpmyadmin |
Command 1 | sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin |
Command 1 | sudo 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’.