[MXS-44] Can not connect to mysql over MaxScale Created: 2015-03-15  Updated: 2015-06-17  Resolved: 2015-06-17

Status: Closed
Project: MariaDB MaxScale
Component/s: Documentation
Affects Version/s: None
Fix Version/s: 1.1.1

Type: Bug Priority: Major
Reporter: zhifeng hu Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

I success set up the MaxScale, and the MaxScale up and running, i can see the stats via maxadmin command.

But i have problem connect to mysql over MaxScale

MaxScale> show dbusers "RW Split Router"
 
Users table data
 
Hashtable: 0x7ff000000c20, size 52
 
        No. of entries:         2
 
        Average chain length:   0.0
 
        Longest chain length:   1
 
User names: root@%, maxscale@%
 
MaxScale> exit
 
[ root@6c8f320f412d:~ ]$ mysql -u maxscale -h 127.0.0.1 --port 4006 -p 
Enter password: 
ERROR 1045 (28000): Access denied for user 'maxscale'@'127.0.0.1' (using password: YES)
 
 

I have no idea how to deal with this problem . I set up maxscale with the manual told me.

Every password were set up right and check carefuly.

 Comments   
Comment by zhifeng hu [ 2015-03-15 ]

I found the log file and then i resolve it 

 
 
[ root@6c8f320f412d:/usr/local/skysql/maxscale/log ]$ tail skygw_err1.log 
2015-03-15 03:31:07   Error : user root@127.0.0.1 not found, try set 'localhost_match_wildcard_host=1' in service definition of the configuration file.
 
2015-03-15 03:31:07   Error : user root@127.0.0.1 not found, try set 'localhost_match_wildcard_host=1' in service definition of the configuration file.
 
 

Generated at Thu Feb 08 03:56:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.