2 years ago
Hello, good morning, my name is yael and I have a problem. When creating a database instance in railway, I connect it with mysql, load the tables, and when I connect it with vercel I get an error. I've done it before and the error was solved with this command 'ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';', but now when I put that command I get this error Plugin 'mysql_native_password' is not loaded . Could you help me? Thank you so much.
4 Replies
2 years ago
Append " --mysql-native-password=ON" to the start command of the MySQL database.
2 years ago
Add as you indicated the command like this docker-entrypoint.sh mysqld --innodb-use-native-aio=0 --disable-log-bin --performance_schema=0 --mysql-native-password=ON , but now It returns the following error:
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', what can I do?
2 years ago
Append "
--mysql-native-password=ON" to the start command of the MySQL database.
This casts an "unknown variable" error.
2 years ago
mysql_native_password has been fully depreciated as of mysql 9, your client would need to support the new auth method.