import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

/**
 * A sample program that demonstrates how to execute SQL INSERT statement
 * using JDBC. 
 * 
 */
public class CrudInsert {

	public static void main(String[] args) {
		String dbURL = "jdbc:mysql://example.com/my_db_name";
		String username = "my_db_username";
		String password = "my_db_password";
		
		try (Connection conn = DriverManager.getConnection(dbURL, username, password)) {
			
			String sql = "INSERT INTO Users (username, password, fullname, email) VALUES (?, ?, ?, ?)";
			
			PreparedStatement statement = conn.prepareStatement(sql);
			statement.setString(1, "bill";
			statement.setString(2, "secretpass";
			statement.setString(3, "Bill Gates";
			statement.setString(4, "bill.gates@microsoft.com";
			
			int rowsInserted = statement.executeUpdate();
			if (rowsInserted > 0) {
				System.out.println("A new user was inserted successfully!";
			}

			
		} catch (SQLException ex) {
			ex.printStackTrace();
		}		
	}
}

The above code is not working, but fully functional when I do it in my "localhost".

The error it is showing me is thus:

java.sql.SQLException: Access denied for user 'my_db_username'@'XX.XX.XX.XX' (using password: YES)

Thanks and God bless.

Java programmers in the house please comment.

This is not a java problem, you need to connect to ur db before u can make transactions, seems to me to u hvnt granted ur host permission to insert records to d database, Google up mysql grants on a user. Best regards.

Well to be honest, I'm not too sure of what kind of error you're encountering here. The first issue that came to my mind was the fact that you hard coded the link to the database, which in some cases, may prove problematic by not properly connecting to the mysql db.
Secondly, your Title states "How to insert data......" and your code seems quite alright except for the part where it's meant to connect to the db, which could explain why the error says access denied.
In all, there's some sort of disconnection between the code and the db. You may wanna post more of the code here if you need more help.

I guess

1)

 String dbURL = "jdbc:mysql://example.com :3306 /my_db_name"; 

2)
Enable Your Computer as an Access Host

By default, all IPs are blocked and must be added to an access list in order to access the server. So, before connecting to MySQL from another computer, the connecting computer must be enabled as an Access Host. Google that

GetAvenue:

The above code is not working, but fully functional when I do it in my "localhost".

The error it is showing me is thus:




Thanks and God bless.

You are using a wrong password/username for your mysql server.

review the values for those to ensure they conform with your online database settings.