Setting up access to the database MySQL
The MySQL database is by default set to access only from webhostingových servers and from the provided interface for managing database (phpMyAdmin). If you need to set up additional approaches from other IP addresses, it is possible to is set directly in the administration of your customer account. The Establishment Of A Another approach is recommended in particular for short-term administrative intervention, with the fact that after the end of the intervention it again, click Cancel. For reasons of safety is not appropriate to allow access from computers where you are not sure their security (foreign computers, Internet café, ...).
Procedure for setting up remote access to MySQL database:
1. log in to your customer account at http://admin.slovaknet.sk2. in the section of the list of services, click detail
3. in the section service elements, click detail for SQL database
4. use the bookmark available operation -Edit access to the database
Types of permissions
"MySql 5.x default": enables the rights SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, THE CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE
"MySql 5.x default + LOCK TABLES": enables the rights of SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, the CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE, LOCK TABLES
"SELECT, INSERT, UPDATE": enables the rights of SELECT, INSERT, UPDATE
"MySql 4.x default": enables the rights SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES
"MySql 4.x default + LOCK TABLES": enables the rights of SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
Important notice:
Set the external IP address is allowed for security reasons only for Administration (Administration) database, and is not intended for automated queries from other servers. In violation of this rule, the Administrator without notice cancel the set access.