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.

    • Related Articles

    • Can't connect to MySQL server on 'LOCALHOST' (10061)

      MySQL is a relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. KDK Software uses MySQL as its back-end ...
    • Income Tax || You have an error in your SQL syntax

      [MySQL][ODBC 3.51 Driver][mysqld-4.0.13]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 'BAD"',0)' at line 1 Error in cmdOK_Click Solution: Please note that this ...
    • SQL SERVER || Consistency Validation For SQL Server Registry Keys

      You are attempting to install the SQL Server 2008 R2 when you receive the following error message: "Consistency validation for SQL Server registry keys failed." NOTE: This issue can occur if an existing key for Microsoft® Business Contact Manager in ...
    • Server Error in '/eXBace' Application.

      Server Error in '/eXBace' Application. Access to the registry key 'HKEY_LOCAL_MACHINE\SOFTWARE\Classes\.LKey.lic.k' is denied. Solution : Regarding this issue you are requested to please open Registry Editor (Open Run > regedit). Expand ...
    • ERROR Of SQL Server OLEDB Provider support

      Problem: Encountering a SQL Server OLEDB provider support error while accessing a Windows application, with the error message: "Unable to load SQL Server OLEDB provider resource DLL. The application cannot continue". Solution: Open File Explorer: ...