Why can’t I connect to remote MySQL from virtual private server? I use ocentOS 4 virtual server that was set up with plesk. I have been trying to connect to remote MySQL from VPS but the connection was not established. I allow remote MySQL from host and also allow outgoing transmission protocol (TCP) port in cof.conf. What other methods can I use in troubleshooting?

What is the major difference between Apache Cassandra, Apache HBase and MongoDB NoSQL Database environment? Which of them run on Hadoop Distributed Filesystem (HDFS)? Which provide for faster and easier integration of data in applications? What language are the three written? In term of performance, which can handle large amount of data most?

I am using VFP 9.0 service pack 2 and trying to call a web service. The website that is hosting the service I require is only available via HTTPS. While using this service with ASP.NET, i get no issues but when I use VFP to access, i get an error as, "Error: 1429 – OLE IDispatch exception code 0 from Connector: Connector:Bad certificate." Is that an issue with web services and VFP that require SSL?

How do I bind datetimepicker to Microsoft access 2013 database? the splash form, admin login form, main dashboard form has been created, Also, the Add new student form , DateTimePicker, combo box on the form and all the text boxes was successfully made. The problem now lies in How to bind the DateTimePicker and Combo box to the Access database. Also, How do I create the report form with all its features intact?

Regards

Recently, I installed MYSQL server on my machine which runs on Windows operating system. I started having problems with MYSQL so I decided to uninstall all programs relating to MYSQL. So far, I have been able to uninstall everything except one stubborn program called MYSQL Connector Net 6.8.3. For some unknown reason this particular program has refused to uninstall when I use the normal procedure for uninstalling programs in Windows OS. What is the most likely cause of this issue? What alternative way can I use to uninstall this program?

What is meant by scalability of a database? What is the difference between a read heavy system and a write heavy system? What is vertical scaling? How is it different from horizontal scaling .If you have a ready heavy system, which one is the preferred mode of scaling: vertical or horizontal?

What is a stateless system? What is as stateful system? What is the impact of state on scaling? What is parallelism? What is the impact of state on parallelism? Name some stateless protocols .The Server Message Block is a stateful protocol. Can you explain how? In terms of security which one is a better protocol: stateful or stateless?

What is a primary key? What is a secondary key? What is a foreign key? What is the difference between each of them? Where are they used? What is a join? What are the different kinds of joins? Explain how they work? Can you differentiate between GROUP BY and ORDER BY?

Is it possible for a database admin to steal your customer’s passwords? How can you prevent this from happening? What are the things that you can do to speed up the processing of your database and remove performance issues? Explain the different ways in which performance tuning can be achieved with respect to a database.