Access MySql with HeidiSql
I do project and I use MySql. I like HeidiSql interface and generally this, so I would like to connect to my local database. But I really feel and maybe I am dumb because whatever host name I put I have errors. Anyway when I type @@hostname in cmd I see my windows authentication username, which also does not work for me.
Mysql Workbench work properly...
Default authentication plugin for MySQL has been changed in recent versions. Not all client programs out there have added support for it yet. You can check if HeidiSQL has released any latest version which adds this support. If it is not, then only solution is to change default authentication plugin on MySQL server and recreate the user. It is described in below links.
https://www.heidisql.com/forum.php?t=24939
https://github.com/HeidiSQL/HeidiSQL/issues/163
- Setting the ft_min_word_len to 2 via console
- MySQL Workbench auto increment disabled
- Get a list of dates between two dates
- Installing mysql2 gem for Ruby on Rails with Mac OSX 10.6
- MySQL slow query when combining two very fast queries
- mySQL full text index slows query
- FULL OUTER JOIN on TWO MYSQL TABLES WITH 3 RELATING COLUMNS
- MYSQL- python pip install error
- How to connect to a database inside Vagrant
- Common_Model.php exists, but doesn't declare class Common_Model
- How can I solve "Error: MySQL shutdown unexpectedly"?
- Insert a SET element into mysql db table with PHP
- ERROR 1071 (42000) : Specified key was too long; max key length is 3072 bytes
- How to get the last second word from String
- How it works a mysql query with alias?
- Efficient to do math in a MySql "order by" clause?
- AttributeError: 'Engine' object has no attribute 'execute' when trying to run sqlalchemy in python to manage my SQL database
- MySQL combine two columns and add into a new column
- how to get lib_mysqludf_sys.dll file on windows
- Qt5 MYSQL driver not loaded error
- How can I add machines to data already been sharded in SQL database?
- Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)
- how to save marital relationship in a database
- store posts + comments in mysql dbs
- How to make a REGEX pattern in mysql for 3 or more digits that are in sequence?
- Does using ASCII/Latin Charset speed up the database?
- utf-8 vs latin1
- Looking to build myself a tiny, free VMWare image for PHP+MySQL Development
- What difference does WITH GRANT OPTION make?
- In MySQL, which is more efficient: IFNULL or NULLIF?