2.1 KiB
Install MySQL on Ubuntu
$ sudo apt install mysql-server
Enable MySQL on Ubuntu
This step will add MySQL to the system startup so that MySQL will start every time that the computer starts.
$ sudo systemctl enable mysql
Secure MySQL (For Production)
It is imperative to "button up" your installation of MySQL. This prevents hackers from getting into your databases.
$ sudo mysql_secure_installation
$ Press y|Y for Yes, any other key for No: y
$ Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 1
$ Remove anonymous users? Y
$ Disallow root login remotely? Y
$ Remove test database? Y
Log in to MySQL
$sudo mysql -u root -p
Create a new MySQL user because using root is BAD!
CREATE USER 'sqladmin'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'sqladmin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit;
Install MySQL Workbench on Ubuntu Desktop
Enter the following commands in the terminal:
$ sudo apt install mysql-workbench
Enable local_infile for OpenEMR
OpenEMR requires the use of local files for uploading content to database tables
Enter the following commands in the terminal:
$ sudo mysql -u root mysql> SET GLOBAL local_infile = 'ON'; mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile';
Allow Remote Connections
https://linuxize.com/post/mysql-remote-access/
How to Allow Remote MySQL Connections (phoenixnap.com)
References
https://www.rosehosting.com/blog/how-to-install-mysql-on-ubuntu-18-04/
https://phoensudo mysql -u root -pixnap.com/kb/install-get-started-mysql-workbench-on-ubuntu
https://mi-squared.com/2019/11/05/openemr-external-data-load-query-error/