Enter Password: ****welcome to the MySQL Monitor. Commands End With; or \g.your MySQL connection ID is 5Server version:5.7.15-log mysql Community Server (GPL) Copyright (c), Oracl e and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names trademarks of their respectiveowners. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement. mysql> use mysqldatabase changedmysql> GRANT all privileges on * * to ' root ' @ '% ' identified by ' 1234 ' with GRANT OPT ION; Query OK, 0 rows affected, 1 warning (0.07 sec) mysql> flush privileges; Query OK, 0 rows affected (0.07 sec) mysql> Select Host,user from user;+-----------+-----------+| Host | User |+-----------+-----------+| % | Root | | % | YK | | localhost | Mysql.sys | | localhost | Root |+-----------+-----------+4 rows in Set (0.00 sec) mysql>
My SQL settings allow remote connections locally