apt-get install mysql-server
The above command installs MySQL server and its related components. you will be asked to setup a password for the root account.
Exposing MYSQL to External Applications:
Edit /etc/mysql/my.cnf and comment the line
bind-address = 127.0.0.1
you can change the port to some no standard ports by changing
port = 3306 ----> any port you like
Restart Mysql server with
service mysql restart
This will expose your database, but there are no users that can connect to it. create a database and assign a user to it.
create database test; grant all privileges on test.l* to test-user@"%" identified by "<some-secret-password>";
This way test-user can connect to database test from any PC.
Few Security tips:
Micropyramid is a software development and cloud consulting partner for enterprise businesses across the world. We work on python, Django, Salesforce, Angular, Reactjs, React Native, MySQL, PostgreSQL, Docker, Linux, Ansible, git, amazon web services. We are Amazon and salesforce consulting partner with 5 years of cloud architect experience. We develop e-commerce, retail, banking, machine learning, CMS, CRM web and mobile applications.
Django-CRM :Customer relationship management based on Django
Django-blog-it : django blog with complete customization and ready to use with one click installer Edit
Django-webpacker : A django compressor tool
Django-MFA : Multi Factor Authentication
Docker-box : Web Interface to manage full blown docker containers and imagesMore...