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 ...
    • TDS || SQL Server does not exist or access denied

      --------------------------- SQL Server --------------------------- Unable to connect: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the ...
    • 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 ...
    • Client does not support authentication protocol requested by server; consider upgrading MySQL client

      Root Cause of the Error: This issue mainly occurs when multiple versions of MySQL are installed on the machine, causing conflicts within the database. Additionally, there are conflicts with the SQL Connector based on the database available on the ...
    • 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 ...