connecting MySQL server to NetBeans

Question

I am trying to connect MySQL database in Netbeans and stuck at the very first step- connecting the database  My Database is working fine on the console - tried command mysqladmin -u root -p ping and it says mysql id is alive  I have even created database from console  Now when i register it in Netbeans   Server Host Name localhost  Server Port 3306  Admin user   root  Admin password   lt the password which works on console gt     and Admin Properties    Path to admin tool  C  Program Files MySQL MySQL Server 5 6 bin mysqladmin exe  Argument    lt blank gt   Path to start command C  Program Files MySQL MySQL Server 5 6 bin mysqld exe  Argument   --console  lt as suggested in http   forums netbeans org topic12767 html gt  Path to stop command C  Program Files MySQL MySQL Server 5 6 bin mysqladmin exe Argument   -u root shutdown     but i still get message -       MySQL Server at localhost 3306  root   disconnected    if i right click and select  start  or  connect  i get the message in taskbar -      Waiting for MYSQL Server to start    for an infinite time   Any help what am i doing wrong here

User · Answer

Follow these 2 steps  STEP 1   Follow these steps using the Services Tab   Right click on Database Create new Connection  Customize the New COnnection as follows   Connector Name    MYSQL  Connector J Driver  Host   localhost Port   3306 Database  mysql   mysql is the default or enter your database name  Username  enter your database username Password  enter your database password JDBC URL  jdbc mysql   localhost 3306 mysql 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    Right click on MySQL Server at localhost 3306  username       Select Properties    from the shortcut menu  In the  quot MySQL Server Properties quot  dialog select the  quot Admin Properties quot  tab Enter the following in the textboxes specified  For Linux users    Path to start command   usr bin mysql Arguments   etc init d mysql start Path to Stop command   usr bin mysql 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 yeshttp   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   Path URL to admin tool   C  Program Files MySQL MySQL Workbench CE 5 2 47 MySQLWorkbench exe Arguments   Leave blank  Path to start command   C  mysql bin mysqld   OR C  mysql bin mysqld exe  Arguments   Leave blank  Path to Stop command  C  mysql bin mysqladmin   OR C  mysql bin mysqladmin exe   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

User · Answer

Fist of all make sure your SQL server is running  Actually I m working on windows and I have installed a nice tool which is called MySQL workbench  you can find it here for almost any platform       Thus I just create a new database to test the connection  let s call it stackoverflow  with one table called user   SET  OLD UNIQUE CHECKS   UNIQUE CHECKS  UNIQUE CHECKS 0  SET  OLD FOREIGN KEY CHECKS   FOREIGN KEY CHECKS  FOREIGN KEY CHECKS 0  SET  OLD SQL MODE   SQL MODE  SQL MODE  TRADITIONAL ALLOW INVALID DATES    DROP SCHEMA IF EXISTS  stackoverflow    CREATE SCHEMA IF NOT EXISTS  stackoverflow  DEFAULT CHARACTER SET utf8 COLLATE utf8 general ci   USE  stackoverflow     -- ----------------------------------------------------- -- Table  stackoverflow   user  -- ----------------------------------------------------- DROP TABLE IF EXISTS  stackoverflow   user     CREATE TABLE IF NOT EXISTS  stackoverflow   user       iduser  INT NOT NULL AUTO INCREMENT     name  VARCHAR 75  NOT NULL     email  VARCHAR 150  NOT NULL    PRIMARY KEY   iduser      UNIQUE INDEX  iduser UNIQUE    iduser  ASC     UNIQUE INDEX  email UNIQUE    email  ASC   ENGINE   InnoDB    SET SQL MODE  OLD SQL MODE  SET FOREIGN KEY CHECKS  OLD FOREIGN KEY CHECKS  SET UNIQUE CHECKS  OLD UNIQUE CHECKS    You can reduce important part to    CREATE SCHEMA IF NOT EXISTS  stackoverflow    CREATE TABLE IF NOT EXISTS  stackoverflow   user           iduser  INT NOT NULL AUTO INCREMENT         name  VARCHAR 75  NOT NULL         email  VARCHAR 150  NOT NULL        PRIMARY KEY   iduser          UNIQUE INDEX  iduser UNIQUE    iduser  ASC         UNIQUE INDEX  email UNIQUE    email  ASC     So now I have my brand new stackoverflow database  Let s connect to it throught Netbeans  Launch netbeans and go to the services panel  Now right click on databases  new connection   Choose MySql connector  they already come packed with netbeans   Then fill in the gaps the data you need  As shown in the picture add the database name and remove from the connection url the optional parameters as l zeroDateTimeBehaviour convertToNull   Use the right user name and password and test the connection    As you can see connection is successful   Click FINISH   You will have your connection successfully working and available under the services

User · Answer

Close NetBeans   Stop MySQL Server   Update MySQL  if available   Start MySQL Server   Open NetBeans    If still doesn t connect  download MySQL Connector J and add mysql-connector-java- version  jar to your classpath and also to your Webserver s lib directory  For instance  Tomcat lib path in XAMPP is C  xampp tomcat lib  Then repeat the steps again

User · Answer

I just had the same issue with Netbeans 8 2 and trying to connect to mySQL server on a Mac OS machine  The only thing that worked for me was to add the following to the url of the connection string   amp serverTimezone UTC  or if you are connecting via Hibernate cfg xml then escape the  amp  as  amp    Not surprisingly I found the solution on this stack overflow post also     MySQL JDBC Driver 5 1 33 - Time Zone Issue  Best Regards  Claudio

User · Answer

Download XAMPP Run XAMPP server  Click on Start button in front of MY SQL  Now you can see that color is changed to green  Now  Click on Admin The new browser window will be open  Copy the link from browser and paste to the Admin properties as shown in below  Set path in the admin properties of database connection  Click on OK  Now your database is connected   enter image description here

User · Answer

check the context xml file in Web Pages -  META-INF  the username  user  must be the same as the database user  in my case was root  that solved the connection error  Hope helps

User · Answer

in my cases  i found my password in glassfish-recources xml under WEB-INF

[mysql] connecting MySQL server to NetBeans

STEP 1 :

STEP 2 :

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

Examples related to mysql

Examples related to netbeans