Access denied for user 'root'@'localhost'

Access denied for user 'root'@'localhost' (using password: NO)

[MYSQL][odbc 3.51 Driver]{mysqld-5.5.5-10.4.10-mariaDB}you have an error in your sql syntax; check the manual that corresponds to your MariaDB server version for the right syntax to user near 'TYPE-MyISAM' at line 1
​
      


Cause :
This error mainly occurs while Higher version or any other version of MySQL is already installed in this system.

Solution :
Regarding this you are requested to please change the PORT for MYSQL.
Default Port is 3306, you need to change the Port 3306 to 3307.

For this please follow the steps below.

STEP 1 :

  1. Go to the Root Location of the Software -
  2. Default Location is - C:\Program Files (x86)\K.D.K. Software            OR            C:\Program Files\K.D.K. Software        
  1. Open config.lan in Notepad - Change the Port 3306 to 3307.

            

STEP 2 : 
  1. Go to Location - C:\Windows 
  1. Open my.ini file in Notepad - Remove # from Starting and Change the Port 3306 to 3307.

            

STEP 3 :
After that Right click on the 'KDK mysql.bat' file and click on Run as Administrator.

            


This file is running the services of KDKMySQL in 3307 port.

            

This will help to resolve the issue.