Problem with SQL authentication

[gugagom 0]

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?

[AnnieRuru 957]

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

 

[gugagom 0]

Holy thanks, it was a little more below and I didn't see it, sorry to bother but thanks again.