Here how to connect java FX and Myqsl sever.
you can download netbeans project folder below.
special thanks to , M.A.H.M.Akram.
download and change the database name and , user name , password any other you want , and don't forget to add jdbc driver to the project in the netbeans.
enjoy the FX :)