Knowledge Hunt

Hi Guys, Error Description : Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead. shutdown unexpectedly This may be due to a blocked port, missing dependencies improper privileges, a crash, or a shutdown by another method Solution : Do not afraid, it's a pretty simple solution. Go to mysql/data/ or (xampp\mysql\data\)  Delete all random files (except the actual database folders) ( in xampp/mysq/bin/ib_logfile1,ib_logfile0,ibdata1,aria_log_control,mysql.pid) Restart Apache and MySQL .       hope you will get better solution. Cheers!

Dear friends, First of all, you must Install Xampp Server >=3.2.2 in your local machine and you should start Apache, Mysql and Tomcat as shown above the screen. Our Goal: Display a simple list of data from myself, using  PHPMyAdmin(Xampp server)  and JSP ODBC Connection jar file. Tomcat: Tomcat nomenclature have the same structure in Xampp server also but few things you must keep in mind java.policy and valid connector jar file in lib folder according to xampp version. Location : xampp\tomcat\webapps\user\WEB-INF\lib\connection.jar files xampp\tomcat\webapps\foldername\ list.jsp file Challenges: If you are facing the port or permission issue while connecting PHPMyAdmin with odbc.  You must look into the policy. java file in your java 's lib folder.This is a very prominent file. anything would you like to change, Please take the backup first. Path :install_root/java/jre/lib/security/java.policy  Updated Policy File