Thread: Client does not support authentication protocol requested by server; (MySQL)

Results 1 to 3 of 3
  1. #1 Client does not support authentication protocol requested by server; (MySQL) 
    Extreme Donator

    Join Date
    Jul 2014
    Posts
    414
    Thanks given
    46
    Thanks received
    8
    Rep Power
    15
    So recently I've decided to get back into RSPS's. Unfortunately I'm still learning. Going my own pace and learning simple guides eventually to lead into big guides.
    I'm trying to connect to MySQL in my server and it's throwing this:

    Code:
    Unable to create connection to database mysql!
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    Picture here:

    Attached image

    Here's my code for the Database line:

    Code:
    public MySQLController() {
    		/* DATABASES */
    		DATABASES = new MySQLDatabase[] {
    				new MySQLDatabase("localhost", 3306, "mysql", "mysql", "server"), };
    And this:

    Code:
    public void createConnection() {
    		try {
    			setConnection(DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, username,
    					password));
    			connectionAttempts = 0;
    		} catch (Exception e) {
    			System.out.println("Unable to create connection to database " + database + "!");
    			connectionAttempts++;
    			e.printStackTrace();
    		}
    	}
    I've been trying for hours now to understand this. Googled the error and can't find any suggestions.
    Reply With Quote  
     

  2. #2  
    Registered Member
    Optimum's Avatar
    Join Date
    Apr 2012
    Posts
    3,570
    Thanks given
    871
    Thanks received
    1,745
    Rep Power
    5000
    "consider upgrading MySQL client"

    try it

    Quote Originally Posted by DownGrade View Post
    Don't let these no life creeps get to you, its always the same on here. They'd rather spend hours upon hours in the rune-server spam section then getting laid! ha ha!Its honestly pathetic i haven't seen so many lowlifes in my life its actually insane i wish that this section would just vanish its probably the only way to get these people out of the community...
    PLEASE BE AWARE OF IMPOSTERS MY DISCORD ID: 362240000760348683
    Reply With Quote  
     

  3. Thankful user:


  4. #3  
    Extreme Donator

    Join Date
    Jul 2014
    Posts
    414
    Thanks given
    46
    Thanks received
    8
    Rep Power
    15
    Quote Originally Posted by Optimum View Post
    "consider upgrading MySQL client"

    try it
    I have the latest MySQL Server I'm pretty sure.

    Edit: Nevermind, I'm retarded. I fixed it. User I quoted was right. I updated the connector jar and it works now. Thanks!
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. Replies: 0
    Last Post: 10-25-2014, 08:28 PM
  2. Client does not load custom models
    By Shoutbox in forum Help
    Replies: 5
    Last Post: 10-12-2013, 08:25 AM
  3. Replies: 31
    Last Post: 07-19-2011, 07:41 PM
  4. Replies: 14
    Last Post: 10-31-2010, 07:18 PM
  5. Client.java size does not lagg your server.
    By Colby in forum RS2 Server
    Replies: 42
    Last Post: 06-10-2009, 08:30 AM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •