Data Adapter error

[valkis98]

I installed the Jaspersoft Studio community edition and then created the Data Adapter, JDBC Driver --> com.mysql.jdbc.Driver, JDBC url -->   jdbc:mysql://nofrg.eu/gsf650s_nofrG, and username and password. The Data Adapter does not work and the message is “Access denied for user gsf650s_vlks@212.22.33.9. Τhis address (212.22.33.9)  belongs to my router and of course there is no such user in the database gsf650s_nofrG. I would appreciate your help

 

[yama818]

It is assumed that you need to create a user on the MySQL side.

* Example of the user to be created
'gsf650s_vlks'@'212.22.33.9'
'gsf650s_vlks'@'212.22.33.%'
'gsf650s_vlks'@'%'

* Example of SQL for confirming a registered user
select user,host from mysql.user;

 

[valkis98]

I can not. When I type the character @ to create the user, the message  "The name of a database user in this system can only contain the following characters: A-Z a-z 0-9 _ - "  is displayed.

 

[valkis98]

 

 

[yama818]

This is puzzling.

Can you transcribe the create user statement that you executed?

[valkis98]

the previous action was done from phpmyadmin.

Now the statement is  CREATE USER 'gsf650s_vlks'@'212.22.33.9' IDENTIFIED BY '1234'

and the message is '#1227 - Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation'

 

[yama818]

I understood that the error of not being able to include '@' in the user name has been resolved.

The following error '#1227' is also thought to be caused by a setting on the MySQL side.

It seems that the connection user used by phpmyadmin is not granted CREATEUSER permissions.

Please try granting permissions to the connection user using the GRANT statement.

 

[valkis98]

The problem is that I can not specify the name of the user I want. I make all the statements correctly.

“JDBC Driver --> com.mysql.jdbc.Driver, JDBC url -->   jdbc:mysql://nofrg.eu/gsf650s_nofrG, and username and password’.

Username I wrote ‘dsf640s_aaa’ . Which finds the user   'gsf650s_vlks@212.22.33.9'?

Note that address  212.22.33.9 is my router.

The problem with the character @ is not solved. It does not allow me to include the character @ in the username and the length of the name should not exceed 16 characters.

[yama818]

//
//About the connection settings for the data source
//

I think the JDBC URL has the following syntax
jdbc:mysql://(hosyname or IPadress):(port)/(databasename)

*For example, my connection information
URL : jdbc:mysql://192.168.1.44:3306/test
USER : myuser

*Your connection information
URL : jdbc:mysql://nofrg.eu/gsf650s_nofrG
USER : gsf650s_vlks

The part that concerns me is the following.
*There is no port number listed.

//
//About the registered user information of MySQL
//

select user,host from mysql.user;

*For example, my connection information.
# user, host
'myuser', 'localhost'
'myuser', '%'

What are the registered users in your environment?
Are there any users that look like the following?
# user, host
'gsf650s_vlks','212.22.33.9'
'gsf650s_vlks','%'

 

[valkis98]

Finally i found a solution. Ιnstalled the Jasper Report Server and through it connected to my remote database. I do not know if  is it the best solution, but now, I see my tables db and run SQL.