1
votes

i have installed MySql workbench. i want to create a database in MySql. when i click New connection, it open a dialog, there are following default values: - in connection method: there are combo box having three values:
Standard (TCP/IP)
Local Socket/Pipe
Standard TCP/IP over SSH

  • Hostname: 127.0.0.1
  • Port: 3306
  • Username: root
  • Password:
  • Default Schema:

what values i fill to creating a new connection. i want to use database at local and want to use this with a java hibernate program.

please suggest.

1

1 Answers

1
votes

You have to select Standard (TCP/IP)

  • Hostname: 127.0.0.1
  • Port: 3306
  • Username: root
  • Password : root_password
  • Default Schema : database_you_want_to_connect_to


See this image for example image
(source: mysql.com)