MySQL command-line error

MySQL Console error message

C:\users\haihai187>mysql
ERROR 1045 (28000): Access denied for user ' ODBC ' @ ' localhost ' (using password:n
O)

Solutions

First: C:\users\haihai187>mysql-u root-p

Enter

Enter Password: *********

Enter

Welcome to the MySQL Monitor. Commands End With; or \g. Your MySQL connection ID is a server version:5.6.25-log mysql Community server (GPL)

Copyright (c), Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of the Oracle Corporation and/or its affiliates. Other names trademarks of their respective owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

Then:mysql> status

Mysql> status--------------mysql  Ver 14.14 distrib 5.6.25, for Win64 (x86_64)

Connection id:          database:current user:            [email protected] ssl:                     not on use Using delimiter:        ; Server version:         5.6.25-log MySQL Community Server (GPL) Protocol version:       connection:              localhost via TCP/IP Server characterset:    UTF8 db     characterset:    UTF8 Client characterset:    gbk conn.  characterset:     GBK TCP port:               3306 UPTIME:        &NBsp;        min 7 sec

Threads:5 questions:6919 Slow queries:0 opens:95 Flush tables:1 Open t ables:82 queries per second avg:3.828 --------------

Mysql>

Problem solving

MySQL command-line error