Jump to content
  • 0
Sign in to follow this  
gugagom

Problem with SQL authentication

Question

I was using the offline guide from AnnieRuRu to set up a server. I am actually trying to make it LAN in order to play in hamachi with some colleagues. I know that tuto wasn't made for that but I figured if I edited a little I could pull it through. My mistake. Still I would want to do it, but I need some help. The computer i'm using is in a domain (it's from my work) and the edits I made that are different from the tuto are only the IP (my hamachi one) for the (char and map)-server and the sql connection i left in localhost IP.

char-server.conf (cut)

// Server Communication username and password.
		userid: "server"
		passwd: "server"
		
		// Login Server IP
		// The character server connects to the login server using this IP address.
		// NOTE: This is useful when you are running behind a firewall or are on
		// a machine with multiple interfaces.
		login_ip: "25.25.148.64"

		// Character Server IP
		// The IP address which clients will use to connect.
		// Set this to what your server's public IP address is.
		char_ip: "25.25.148.64"

map-server.conf (cut)

// Information related to inter-server behavior
	inter: {

		// Interserver communication passwords, set in the login server database
		userid: "server"
		passwd: "server"

		// Map Server IP
		// The IP address which clients will use to connect.
		// Set this to what your server's public IP address is.
		map_ip: "25.25.148.64"

		// Character Server IP
		// The map server connects to the character server using this IP address.
		// NOTE: This is useful when you are running behind a firewall or are on
		// a machine with multiple interfaces.
		char_ip: "25.25.148.64"

	}

sql-connection (cut)

sql_connection: {
	// [INTER] You can specify the codepage to use in your mySQL tables here.
	// (Note that this feature requires MySQL 4.1+)
	//default_codepage: ""

	// [LOGIN] Is `userid` in account_db case sensitive?
	//case_sensitive: false

	// For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1.
	// Under windows, you want to use 127.0.0.1.  If you see a message like
	// "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
	// and you have localhost, switch it to 127.0.0.1
	db_hostname: "127.0.0.1"
	db_port: 3306
	db_username: "root"
	db_password: "1234"
	db_database: "hercules"
	//codepage:""
}

Any one that could help me?

screenshot.png

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0
On 1/17/2019 at 5:14 PM, AnnieRuru said:

problem might encounter during this step


[SQL]: Client does not support authentication protocol requested by server; consider upgrading MySQL client

This happens if you have previous version of MySQL installed on your computer, and upgrade into MySQL 8.0
to fix this issue, run MySQL command line Client from start menu
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 4.5a.png
then run these 2 commands seperately


ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1234';
FLUSH PRIVILEGES;

https://github.com/AnnieRuru/customs/blob/master/server setup/Step 4.5b.png

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.