I'm trying to give access to client computer from my server and also tryin to revoke the granted access... the grant is successful but the revoking is not working please help. hms is the satabase that i want to give access to my clients.. my code try { Connection con = getDBConnection(); Statement stmt = con.createStatement(); if (sts == true) { String query = "GRANT INSERT,SELECT,UPDATE,DELETE ON hms.* TO '" + MainFrame.dbUser + "'@'" + ip + "' IDENTIFIED BY '" + MainFrame.dbPassword + "'"; stmt.execute(query); System.out.println(query); JOptionPane.showMessageDialog(null, "Permission granted to '" + ip + "' !"); } else{ String …

Member Avatar
Member Avatar
+0 forum 3

Hi, Guys i need a simple help from you guys. There's a scenerio that i m sure is very common in mysql and i know most of you can answer that but i m new to mysql so need some basic polish. so my scenerio is that for example i have 100 database. i create a new database (sample) now i create new user (user1) now i want to give grant access to user1 on all databases except SAMPLE.. what i should do ?? NOTE: What i did was give Grant all privileges on *.* to 'user1'@'localhost'; revoke all privileges …

Member Avatar
Member Avatar
+0 forum 2

The End.