MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors
1PLs Company - #1Payday.Loans Agency - Loans online and near me $100-$2500 (Same Day)
Powered by MySQL
 
Home / General Questions / Question No: 4

How can I detect that MySQL is already installed?

I would like to create a setup program for my application that uses MySQL database. How can I detect that MySQL is already installed at the target computer because I don't want to ruin an existing database. Is there any way to detect it?

Answer No: 4

By the following ways, you can detect that MySQL is already installed or not.

Firstly, If there is no firewall in between, you may check to see if port 3306 is responding as the MySQL Server uses port 3306 by default.

Secondly, it is very possible to have multiple installs of the MySQL on a server without conflict, so done correctly, you won't trash any other MySQL installs. You can simply put all files at another location (your program's folder) and write the my.ini/my.cnf file on the fly, changing the datadir and other options for it to work wherever your program will be located.

Thirdly, you can also use sockets or named pipes instead of TCP/IP to ensure you won't block any port or mess with the network, starting your server without networking support.

Further, you have to figure out if you use PHP if so you must check to see if it is installed as well, and compiled with MySQL support.

Related MySQL FAQs to the Above FAQ

What-is-prepared-statement-in-MySQL What is prepared statement in MySQL?

Maximum-number-of-columns-in-a-table Maximum number of columns in a table

Can-I-use-FIELD-CONSTRAINTS-on-MySQL Can I use FIELD CONSTRAINTS on MySQL?

What-are-reserved-words-in-MySQL What are reserved words in MySQL?

How-to-manage-Time-Zone-in-MySQL How to manage Time Zone in MySQL?

What-is-History-of-MySQL What is History of MySQL?

Why-values-with-spaces-do-not-come-into-search-result Why values with spaces do not come into search result?

How-does-MySQL-manage-case-sensitivity-of-identifiers How does MySQL manage case sensitivity of identifiers?

What-are-MySQL-connectors-or-client-interfaces What are MySQL connectors or client interfaces?

About FAQs: Recently Added FAQs

About MySQL FAQs: Site Map | Bookmark Us | Recommend this Site to Your Friend | Contact Us

Useful Links: Wikipedia.org | Oracle.com | w3schools.com | www.php.net | Github.com

© 2023  www.mysqlfaqs.net
All rights reserved.