Bumped by Community user
    Bumped by Community user
    Bumped by Community user
    Bumped by Community user
    Bumped by Community user
    Bumped by Community user
    Bumped by Community user
    Bumped by Community user
5 The question is not related to MySQL Workbench.
| link
4 improve formating
source | link

I'm new to MySQL and installed MySQLinMySQL in Ubuntu 16.04. at At the time of installation iI have given password for root.

In the terminal iI can access only root user and created user only.

bharath@bharath-desktop:~$ mysql -uroot -pbharath

mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.7.16-0ubuntu0.16.04.1 (Ubuntu)

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

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

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

mysql>

butBut I am not able to access the default mysqlMySQL user in the terminal, its. It shows like this:

bharath@bharath-desktop:~$ mysql

ERROR 1045 (28000): Access denied for user 'bharath'@'localhost' (using password: NO)**

if iIf I hit enter after MySQL, itsit's not authenticated. howHow to access this?

I'm new to MySQL and installed MySQLin Ubuntu 16.04. at the time of installation i have given password for root.

In the terminal i can access only root user and created user only.

bharath@bharath-desktop:~$ mysql -uroot -pbharath

mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.7.16-0ubuntu0.16.04.1 (Ubuntu)

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

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

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

mysql>

but not able to access default mysql user in the terminal, its shows like this

bharath@bharath-desktop:~$ mysql

ERROR 1045 (28000): Access denied for user 'bharath'@'localhost' (using password: NO)**

if i hit enter after MySQL, its not authenticated. how to access this

I'm new to MySQL and installed MySQL in Ubuntu 16.04. At the time of installation I have given password for root.

In the terminal I can access only root user and created user only.

bharath@bharath-desktop:~$ mysql -uroot -pbharath

mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.7.16-0ubuntu0.16.04.1 (Ubuntu)

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

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

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

mysql>

But I am not able to access the default MySQL user in the terminal. It shows like this:

bharath@bharath-desktop:~$ mysql

ERROR 1045 (28000): Access denied for user 'bharath'@'localhost' (using password: NO)**

If I hit enter after MySQL, it's not authenticated. How to access this?

3 improve formating
source | link

I'm new to mysqlMySQL and installed mysql in ubuntuMySQLin Ubuntu 16.04. at the time of installation i have given password for root.

In the terminal i can access only root user and created user only.

bharath@bharath-desktop:~$ mysql -uroot -pbharath

bharath@bharath-desktop:~$ mysql -uroot -pbharath

mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.7.16-0ubuntu0.16.04.1 (Ubuntu)

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

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

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

mysql>

mysql: [Warning] Using a password on the command line interface can be insecure. Welcomebut not able to access default mysql user in the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.7.16-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2016terminal, Oracle and/or its affiliates. All rights reserved.shows like this

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.bharath@bharath-desktop:~$ mysql

ERROR 1045 (28000): Access denied for user 'bharath'@'localhost' (using password: NO)**

Type 'help;' or '\h' for helpif i hit enter after MySQL, its not authenticated. Type '\c'how to clear the current input statement.

mysql>

but not able to access default mysql user in the terminal, its shows like this

**bharath@bharath-desktop:~$ mysql

ERROR 1045 (28000): Access denied for user 'bharath'@'localhost' (using password: NO)**

if i hit enter after mysql, its not authenticated. how to access thisaccess this

I'm new to mysql and installed mysql in ubuntu 16.04. at the time of installation i have given password for root.

In the terminal i can access only root user and created user only.

bharath@bharath-desktop:~$ mysql -uroot -pbharath

mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.7.16-0ubuntu0.16.04.1 (Ubuntu)

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

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

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

mysql>

but not able to access default mysql user in the terminal, its shows like this

**bharath@bharath-desktop:~$ mysql

ERROR 1045 (28000): Access denied for user 'bharath'@'localhost' (using password: NO)**

if i hit enter after mysql, its not authenticated. how to access this

I'm new to MySQL and installed MySQLin Ubuntu 16.04. at the time of installation i have given password for root.

In the terminal i can access only root user and created user only.

bharath@bharath-desktop:~$ mysql -uroot -pbharath

mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.7.16-0ubuntu0.16.04.1 (Ubuntu)

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

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

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

mysql>

but not able to access default mysql user in the terminal, its shows like this

bharath@bharath-desktop:~$ mysql

ERROR 1045 (28000): Access denied for user 'bharath'@'localhost' (using password: NO)**

if i hit enter after MySQL, its not authenticated. how to access this

2 edited title
| link
1
source | link