connecting MySQL server to NetBeans

by

Follow these 2 steps:

STEP 1 :

Follow these steps using the Services Tab:

  1. Right click on Database
  2. Create new Connection

Customize the New COnnection as follows:

  1. Connector Name: MYSQL (Connector/J Driver)
  2. Host: localhost
  3. Port: 3306
  4. Database: mysql ( mysql is the default or enter your database name)
  5. Username: enter your database username
  6. Password: enter your database password
  7. JDBC URL: jdbc:mysql://localhost:3306/mysql
  8. CLick Finish button

NB: DELETE the ?zeroDateTimeBehaviour=convertToNull part in the URL.
Instead of mysql in the URL, you should see your database name)

STEP 2 :

  1. Right click on MySQL Server at localhost:3306:[username](...)
  2. Select Properties… from the shortcut menu

In the “MySQL Server Properties” dialog select the “Admin Properties” tab
Enter the following in the textboxes specified:

For Linux users :

  1. Path to start command: /usr/bin/mysql
  2. Arguments: /etc/init.d/mysql start
  3. Path to Stop command: /usr/bin/mysql
  4. Arguments: /etc/init.d/mysql stop

For MS Windows users :

NOTE: Optional:

In the Path/URL to admin tool field, type or browse to the location of your MySQL Administration application such as the MySQL Admin Tool, PhpMyAdmin, or other web-based administration tools.

Note: mysqladmin is the MySQL admin tool found in the bin folder of the MySQL installation directory. It is a command-line tool and not ideal for use with the IDE.

Citations:
https://netbeans.org/kb/docs/ide/mysql.html?print=yes
http://javawebaction.blogspot.com/2013/04/how-to-register-mysql-database-server.html

We will use MySQL Workbench in this example. Please use the path of your installation if you have MySQL workbench and the path to MySQL.

  1. Path/URL to admin tool: C:\Program Files\MySQL\MySQL Workbench CE 5.2.47\MySQLWorkbench.exe
  2. Arguments: (Leave blank)
  3. Path to start command: C:\mysql\bin\mysqld (OR C:\mysql\bin\mysqld.exe)
  4. Arguments: (Leave blank)
  5. Path to Stop command: C:\mysql\bin\mysqladmin (OR C:\mysql\bin\mysqladmin.exe )
  6. Arguments: -u root shutdown (Try -u root stop)

Possible exampes of MySQL bin folder locations for Windows Users:

  • C:\mysql\bin
  • C:\Program Files\MySQL\MySQL Server 5.1\bin\
  • Installation Folder: ~\xampp\mysql\bin

More Related Contents:

  1. How to declare a variable in MySQL?
  2. How do I escape special characters in MySQL?
  3. Enable remote MySQL connection: ERROR 1045 (28000): Access denied for user
  4. SQL counting all rows instead of counting individual rows
  5. MySQL – ERROR 1045 – Access denied
  6. Remote Connections Mysql Ubuntu
  7. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  8. MySQL InnoDB not releasing disk space after deleting data rows from table
  9. In MySQL, should I quote numbers or not?
  10. Dump all tables in CSV format using ‘mysqldump’
  11. MySQL add days to a date
  12. How can I loop through all rows of a table? (MySQL)
  13. Select columns across different databases
  14. LOAD DATA INFILE Error Code : 13
  15. MySql update two tables at once
  16. Returning query results in predefined order
  17. Table is ‘read only’
  18. Django MySQL full text search
  19. Proper database model for a user feedback system (an interesting case)
  20. MySQL Errno 150
  21. How to force MySQL to take 0 as a valid auto-increment value
  22. MySQL – Replace Character in Columns
  23. How do you manage databases in development, test, and production?
  24. MySQL LIKE vs LOCATE
  25. List of Constraints from MySQL Database
  26. The web application [] appears to have started a thread named [Abandoned connection cleanup thread] com.mysql.jdbc.AbandonedConnectionCleanupThread
  27. MySQL: Querying for unicode entities
  28. undefined method `eq’ for nil:NilClass with rails 3 and ruby enterprise on ubuntu hardy
  29. How do I extract Month and Year in a MySQL date and compare them?
  30. INSERT INTO fails with node-mysql

Leave a Comment