DebugAH

How to Solve Your Programmer Error

Skip to content
  • Home
  • Linux
  • JAVA
  • Python
  • Javasript
  • MYSQL
  • Windows
  • Error

[Solved] MYSQL Install and Login Error: Access denied for user ‘ODBC’@’localhost’ (using password: NO)

Refer to the original link: https://www.cnblogs.com/cx-code/p/9287274.html

Downloaded mysql5 After 7, run MySQL on the command line and access denied for user ‘ODBC’ @ ‘localhost’ (using password: no)

The solution is as follows:

Stop MySQL service

Find my. Under the MySQL installation directory Ini, find [mysqld] in it and add this sentence below: skip_grant_Tables (skip permission table authentication when starting MySQL service) remember to save.

Find the bin directory of MySQL in CMD, and then enter the command: MySQL – U root – P. enter

Enter: use MySQL

Enter the password to modify: update mysql user set authentication_ String = password (“newly set password”) where user = “root”; (my version of MySQL here is 5.7, in which the attribute of the password column is authentication_string; in 5.1, it is password)

Refresh permissions: flush privileges;

Exit: quit;

Put my Skip in ini_grant_Remove tables and restore the authority table authentication during login

Restart the MySQL service, and then log in with root and the modified password: MySQL – U root – P

Then enter the password for verification, and the successful entry indicates that it is successful

Similar Posts:

  • [Solved] Access denied for user ‘ODBC’@’localhost’ (using password: NO)
  • Solve the problem of unknown column ‘password’ in ‘field list’ in MySQL
  • MYSQL Login Error: mysqladmin: connect to server at ‘localhost’ failed
  • Linux Login MYSQL Error: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  • Mysqldump backup problems got error: 1045, error 1045 (28000), got error: 1449
  • mysql ERROR 1044 (42000): Access denied for user ‘
  • [Solved] MYSQL ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘mys…
  • MySQLAccess denied for user ‘root’@’localhost’ [How to Solve]
  • MySQL login prompt error 1524 (HY000): plugin ‘UNIX_ Socket ‘is not loaded
  • [Solved] Deploying Tomcat connection in Linux Navicat reports error 2059 – authentication plugin ‘caching_sha2_Password ‘cannot be loaded: + Xi input 9 g

This entry was posted in MYSQL and tagged Access denied for user 'ODBC'@'localhost' (using password: NO), MYSQL Install and Login Error on January 11, 2022 by Robins.

Post navigation

← [Solved] scss File Use the Depth Selector /deep/ Error: Expected selector [Solved] 1.4pip Install xgboost Error: Command errored out with exit status →

Recent Posts

  • [Solved] Win-KeX/wsl2/kali Startup Error: A fatal error has occurred and VcXsrv will now exit.
  • [Solved] samtools: error while loading shared libraries: libcrypto.so.1.0.0: cannot open shared object file
  • k8s Error: [ERROR FileAvailable–etc-kubernetes-kubelet.conf]: /etc/kubernetes/kubelet.conf already exists
  • [Solved] NoSuchMethodError: org.springframework.boot.web.servlet.error.ErrorController.getErrorPath
  • [Solved] flink web ui Submit Task Error: Server Respoonse Message-Internal server error
  • Mysql Error: 1140 – In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column ‘a.store’; this is incompatible with sql_mode=only_full_group_by
  • [Solved] Mybatis multi-table query error: Column ‘id’ in field list is ambiguous
  • [Solved] fluentd Log Error: read timeout reached
  • [Solved] xgboost Load Module File Error
  • [Solved] npm install Error: github requires permissions, Permission denied (publickey)

Tags

  • )
  • android
  • android studio
  • CentOS
  • centos7
  • chrome
  • DebugAH
  • django
  • docker
  • eclipse
  • git
  • github
  • go
  • hadoop
  • Hive
  • IDEA
  • ios
  • java
  • jenkins
  • Linux
  • Mac
  • maven
  • MyBatis
  • mysql
  • nginx
  • No module named XXX error
  • npm
  • Oracle
  • php
  • pip
  • pycharm
  • Python
  • Python TypeError
  • redis
  • shell
  • spring
  • springBoot
  • ssh
  • SVN
  • tensorflow
  • tomcat
  • ubuntu
  • vue
  • Windows
  • Yum
Proudly powered by WordPress