Krydos Posted December 5, 2017 Posted December 5, 2017 All mysql username and mysql databases have to have your cpanel username and an underscore before them. If not then no one else would be able to use the mysql username Henry.
Bailey Posted December 5, 2017 Posted December 5, 2017 Your MySQL username will always be "HH_username_choosenuser" for example: "myskillz_henry" in your case. Oh sorry, didnt see your reply @Krydos.
myskillz Posted December 5, 2017 Author Posted December 5, 2017 that's what i didbut im gonna need you to show me the log file to view error that are making it not workinghttp://isoko.tk/E_Book_Prop_Extent/
myskillz Posted December 6, 2017 Author Posted December 6, 2017 i have tried testing the access of the database but i still can't, the DriverManager has a problem could u unable it? im using these following codes <%@page import="java.sql.*" %><%String mysql_database = "myskill_mmmmm";String mysql_username = "myskill_lllll";String mysql_password = "bbbbb"; Class.forName("com.mysql.jdbc.Driver"); Connection connection = DriverManager.getConnection( "jdbc:mysqli://127.0.0.1/" + mysql_database, mysql_username, mysql_password);Statement statement = connection.createStatement();ResultSet result = statement.executeQuery("SELECT * FROM users");while (result.next()) { %><%= result.getString("up_name") %>: <%= result.getString("up_category") %><br/><% } %> the problem is the driver when i tried to remove this--------------------------------Class.forName("com.mysql.jdbc.Driver");-------------------------the problem re appear , plz help
myskillz Posted December 6, 2017 Author Posted December 6, 2017 Db= myskill_bargainingzUserName= myskill_HENRYpassword= passWORD11 That's the real credentials But it ain't working.
Recommended Posts