How to create database in MySQL

Steps:-

  • Open MySQL Command line client
  • Key-in the password
  • To create the database..use this command: create database 'databasename'_myswldb;
  • Enter - done !

To see the database created, we can open the MySql Workbench - choose Schemas. All database created showed in Schemas


How to Add database to ODBC data source Administrator

odbc-run as administrator

  • Open ODBC as above and run as administrator
  • Under User DNS > click Add
  • Under Create Data Source > Choose MySQL ODBC ANSI Driver > Click Finish
  • Under as below

odbc