Posted In: cpanel, Database, MySQL

cpanel – Host xxx is not allowed to connect to this MySQL server

When connecting to hosted DB server from local MySQL client you may get “Host xxx is not allowed to connect to this MySQL server”. To resolve you need to add the IP to MySQL remote access hosts settings Error Open cpanel and go to Remote MySQL Add host IP

Read More

Tags:

by , on September 20th, 2017

Posted In: Database, MySQL

MySQL AUTO_INCREMENT column

In case you worked most of life on Oracle DB you must be wondering where is the SEQUENCE. AUTO_INCREMENT column in MySQL is used for primary key column. For each insert MySQL will automatically update the column to next max value. For each new row, MySQL increments the value automatically and persist it to table. […]

Read More

by , on August 24th, 2017

Posted In: Database, MySQL

MySQL table names are case sensitive

I have own product called www.labworkflows.com. After moving application from my Windows local environment to Linux CentOS server I observed lot of my queries stopped working. e.g. select * from LABTESTS works on Windows default MySQL installation but dis not work on CentOS. After digging more into it observed that scripts that I generated through […]

Read More

by , on August 21st, 2017

Posted In: Database, MySQL, Testing

How to import test data into MySQL table using csv file

Tools Used 1. MySQL Workbench 2. http://www.generatedata.com/ Let us first create test data CSV file Now import using MySQL Workbench

Read More

Tags:

by , on March 28th, 2017

  • Categories