Syntax Errors: Unable to logon with DB Admin account created MySQL Installer

[Ian Coates]

Hi MySQL Forum,

I've installed MySQL Server 5.7.11 on Windows 10 and during the installation via the MySQL Installer, I entered the details for the root user via localhost and at the same time created another 'DB Admin' account: adminian again via localhost with all permissions. On opening the MySQL Command Line Client to create a database was presented with the prompt for a password. I entered the password for the root user and was then able to create a simple database and query this All OK.

I then wanted to checkout how to logon as the other user - e.g. adminian created during the installation - shown below

mysql> select user, host, authentication_string from mysql.user;
+-----------+-----------+-------------------------------------------+
| user | host | authentication_string |
+-----------+-----------+-------------------------------------------+
| root | localhost | *F12ABE0D91DCDBBE77A3022CF0DF44F5EC3F34F1 |
| mysql.sys | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| adminian | localhost | *CCF0CE7A00DF4F86DEA468B6BC90F64C4524F0EB |
+-----------+-----------+-------------------------------------------+
3 rows in set (0.01 sec)

I have to date only been unable to logon via the Command Line Client using the root user password.

I have not been able to logon as e.g. adminian as keep getting syntax errors for each of the many permutations I've observed in posts online

using e.g. MySQL> MySQL -h localhost -u adminian -p

or MySQL 'adminian'@'localhost' -p

hoping to be prompted for the password for this user

Permissions were granted during installation?

Can anyone please provide the correct syntax for this?

Many thanks

Ian