Setting up a Local MySQL on a Linux Server

Step

Instruction

Command

1

Install MySQL.

- sudo apt-get update

- sudo apt-get install mysql-server

2

Allow external connections.

- sudo ufw allow mysql

3

Start the MySQL service.

- sudo systemctl start mysql

4

Enable the MySQL server at startup.

- sudo systemctl enable mysql

5

Start the MySQL shell.

- sudo /usr/bin/mysql -u root -p

6

Create an Sonitrol CORE user.

- INSERT INTO mysql.user ((User,Host,authentication_string,
ssl_cipher,x509_issuer,x509_subject )
VALUES('<username>','localhost',
PASSWORD('<password>'),'','','');

Replace <username> and <password> with the actual username and password of the user.

7

Flush privileges.

- FLUSH PRIVILEGES;

8

Grant access vis IP.

- GRANT ALL PRIVILEGES ON *.* TO 'spgarco' @'%' IDENTIFIED BY 'SpgControls01!' with grant option;

9

Flush privileges.

- FLUSH PRIVILEGES;

10

Open /etc/mysql/my.cnf and find the [mysqld] section.

 

11

If it does not exist, open /etc/mysql/mysql.conf/mysqld.cnf using sudo.

 

12

Enter the bind address to the server's IP address.

 

13

Restart the MySQL service.

- service mysql restart

 

See Also  

Setting up a Microsoft SQL Server

"Transferring Files Between Linux and Windows Servers" on page 1

"Transferring Files Between Linux and Windows Servers" on page 1

Troubleshooting

Running Sonitrol CORE

Installing Sonitrol CORE Web