
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 MoreTags: Setting your own hosted Java website/application

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
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
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 MoreTags: MySQL Workbench
- Apache (13)
- Build Tools (2)
- Gradle (2)
- Caching (1)
- cpanel (1)
- cURL (1)
- Database (7)
- Hibernate (5)
- Java Core (38)
- Java Script (15)
- Bootstrap (1)
- File Upload (7)
- jQuery (3)
- React (3)
- JEE (13)
- JSON (41)
- GSON (13)
- Jackson 1X (1)
- Jackson 2X (12)
- jsoniter (1)
- Logging (2)
- Apache Commons Logging (1)
- Apache Log4J (1)
- Logback (1)
- SLF4J (1)
- MongoDB (1)
- OS (1)
- Linux (1)
- Security (5)
- Server (4)
- Tomcat (4)
- Service (2)
- Micro (2)
- Spring (46)
- Pattern (2)
- Spring Boot (20)
- Spring Data (4)
- Spring MVC (8)
- Spring REST (13)
- Spring Security (7)
- Testing (11)
- XML (5)
- JDOM XML Parser (1)