i have migrated mysql database file aws mysql instance using mysql workbench.
i want test migrated properly. when connect db using mysql workbench , run sql query such
select * users
i error saying no database has been selected. i'm thinking i'm connected server , not actual database. there method connect actual db , view tables on server using mysql workbench or possibly tool.
you never connect database. database (aka schema) organizational constuct within database server (aka rdbms). so, first connect server, establish communication. select schema work with. either run use command or, in mysql workbench, double click on schema node in schema tree on left hand side make current default. can set initial default schema in connection settings. current (default) schema shown in bold in tree:
Comments
Post a Comment