Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.10
-
Windows 10 Professional 64 bit
Description
I am not able to run:
create table xpivot1
engine=connect table_type=PIVOT
option_list='PivotCol=FirstLetter,FncCol=cnt'
Srcdef='select table_type, left(table_name,1) as FirstLetter , count(table_type) as cnt from tables group by 1, 2';
The query returns an error:
SQL error (1105): (1045) Access denied for user 'root'@'localhost' (using password: NO) |
, while root is still connected.
If I run the query from the command line, the same error reveals.
I checked logfile to see what is going on.
While the connection is set as user root and
SELECT CURRENT_USER() ;
CURRENT_USER()
---------------------
root@%
I have found the following records in logfile:
...
Since I found a topic discussing "Connect ...@localhost as anonymous" at
https://dba.stackexchange.com/questions/81092/what-does-as-anonymous-on-means-in-mysqls-general-log,
I am more confused than at the beginning