Need some help

[Vasu deva rao]

Hello Team,

I am getting error like this while connecting to DB by using VIP .

mysql -u maxscale-p -h 10.167.57.201 -P33306
ERROR 1045 (28000): Access denied for user 'maxscale-p'@'10.167.57.201' (using password: NO)

mysql -u maxscale -p -h 10.167.57.201 -P33306
Enter password:
ERROR 1815 (HY000): Internal error: Session creation failed

maxctrl list servers
┌─────────┬──────────────┬──────┬─────────────┬─────────┬───────────────┐
│ Server  │ Address      │ Port │ Connections │ State   │ GTID          │
├─────────┼──────────────┼──────┼─────────────┼─────────┼───────────────┤
│ server1 │ 10.167.57.48 │ 3306 │ 0           │ Running │ 11-1-33624168 │
├─────────┼──────────────┼──────┼─────────────┼─────────┼───────────────┤
│ server2 │ 10.167.57.91 │ 3306 │ 0           │ Running │ 11-1-33624168 │
└─────────┴──────────────┴──────┴─────────────┴─────────┴───────────────┘

Thanks,

Vasudeva Rao

07899917070

[Markus Mäkelä]

Hi,

There's probably something wrong with the grants for that particular user, the error log most likely has more information. I'd recommend following the MaxScale tutorial on how to correctly create the users.

Markus

--
You received this message because you are subscribed to the Google Groups "MaxScale" group.
To unsubscribe from this group and stop receiving emails from it, send an email to maxscale+u...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/maxscale/CAMZCHEbRP5H2OiOHenn2Ht4qYDbLB1h_FkVhJ-G%2BSerUgA8SPA%40mail.gmail.com.

-- 
Markus Mäkelä, Senior Software Engineer
MariaDB Corporation