What is the port does MySQL use?

We have never change the MySQL port and the port is still uses back the default port. Our MySQL uses Port 3306 where you could connect through MySQL Administration Tools, Navicat, etc.

MySQL syntax error when installing older application.

If you receive below error when you install older application, Example: “Failed to create faq table: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near “Type=MyISAM” at line 9″   Kindly open the file, example: install.php and change the […]

How to change all MySQL database table collation

After change the collation of a database, only the new tables will be created with the new collation. To change all the database collation, you can use the php script as below as it can change all the collation for all the existing table. <?php $db = mysql_connect(‘localhost’,’database_user‘,’Password‘); if(!$db) echo “Cannot connect to the database – […]

Does your server support MySQL Front?

The answer is “Yes”, our Windows and Linux server do support MySQL Front through Port 3306. However external IP has to be register in our server in order to connect using MySQL Front. The steps outlined as below. 1) Contact our technical team via Help Desk ticketing system 2) Provide us your external IP and database name […]

Connection Strings for MySQL

Cold Fusion (DNSless): connectstring=”Driver={MySQL ODBC 3.51 Driver};SERVER=serverIP;UID=user;PWD=pass;DATABASE=mydb;network=dbmssocn” Cold Fusion (DNS): datasource=”DSN” username=”user” password=”pass” Perl (DSNless): $dbh = DBI->connect(‘dbi:mysql:mydatabase:serverIP’,’user’,’pass’); PHP (DSNless): $db = mysql_connect(“serverIP”, “user”, “pass”) ASP (DSN): MyConn.Open “dsn” ASP (DSNless): “Driver={MySQL ODBC 3.51 Driver};” & _ “Server=serverIP;” & _ “Port=3306;” & _ “Option=131072;” & _ “Stmt=;” & _ “Database=mydatabase;” & _ “Uid=user;” & _ […]

Can't find the answer? Don't worry, contact our professional customer service team.
Send us your questions