Krydos Posted December 5, 2017 Share 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. Link to comment Share on other sites More sharing options...
Bailey Posted December 5, 2017 Share 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. Link to comment Share on other sites More sharing options...
myskillz Posted December 5, 2017 Author Share 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/ Link to comment Share on other sites More sharing options...
myskillz Posted December 6, 2017 Author Share 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 Link to comment Share on other sites More sharing options...
Krydos Posted December 6, 2017 Share Posted December 6, 2017 There is no database named myskill_mmmmm. Link to comment Share on other sites More sharing options...
myskillz Posted December 6, 2017 Author Share Posted December 6, 2017 Db= myskill_bargainingzUserName= myskill_HENRYpassword= passWORD11 That's the real credentials But it ain't working. Link to comment Share on other sites More sharing options...
Recommended Posts