Database Server Setup to allow connection from the instruments¶

You need to do is even if you have used autoinstaller so that computers controlling the instruments (microscope/camera) can connect to the database

Bind mysqld to its IP address to allow tcp connection to it.¶

Edit /etc/my.cnf search for skip-networking and make sure it is commented out like this:¶

#skip-networking

Add the address the database is bound to after that line

#skip-networking
bind-address=your.ip.address.number

for example, 192.168.0.1 in a local network

Restart mysqld¶

For CentOS, Fedora

sudo /etc/init.d/mysqld restart

or

sudo /sbin/service mysqld restart

Create remote user¶

Create and grant privileges to the usr_object for the databases on the hosts involved. See MySQL Reference Manual for details.

You can set hosts on a particular subnet by only specify the network number portion such as '192.168' and use wild card for the host number portion to give '192.168.%.%' as the global host allowing connection.
If appropriate, you can also use domaian name with wild care i.e., '%.mydomain.edu'

At the mysql prompt execute the following commands:

CREATE USER usr_object@'192.168.%.%' IDENTIFIED BY 'YOUR PASSWORD';
GRANT ALTER, CREATE, INSERT, SELECT, UPDATE ON leginondb.* TO usr_object@'192.168.%.%';
GRANT ALTER, CREATE, INSERT, SELECT, UPDATE ON projectdb.* TO usr_object@'192.168.%.%';

Change localhost database user to usr_object if autoinstaller was used.¶

Autoinstaller does not create usr_object user on the localhost but use root user for database connection. You may want to make change at this time.

At the mysql prompt execute the following commands:

CREATE USER usr_object@'localhost' IDENTIFIED BY 'YOUR PASSWORD';
GRANT ALTER, CREATE, INSERT, SELECT, UPDATE ON leginondb.* TO usr_object@'localhost';
GRANT ALTER, CREATE, INSERT, SELECT, UPDATE ON projectdb.* TO usr_object@'localhost';

---

< Web Server Installation | Additional Database Server Setup >

---