[MYSQL][odbc 3.51 Driver]Access denied for user 'root'@'localhost' (using password: NO)

[MYSQL][odbc 3.51 Driver]Access denied for user 'root'@'localhost' (using password: NO)

[MYSQL][odbc 3.51 Driver]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

    • [MYSQL][ODBC 3.51 Driver] 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 ...

    • You have an error in your SQL syntax.

      --------------------------- ZenIT --------------------------- [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 ...

    • Error 127 Table Handler - [MYSQL][ODBC 3.51 Driver ]mysqld -4.0.13

      If there is any sort of malfunctioning in executing the software and due to any reason if the software gets automatically closed /shutdown, the user would encounter the error 127.              Solution: Please follow the below troubleshoot (on server ...

    • SQL SERVER Installation error > 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). ...