authentication method 'caching_sha2_password' not supported by any of the available plugins可能的解决方法之一

mysql版本高(8.0及以上),但你的.net 的mysql 程序集不是对应的新版本

解决方法:安装低版本mysql, 高低版本两者可以共存,但端口号要设不一样

连接字符串中加一条 port=3307 (假如你的端口号设置的为3307)

发布了11 篇原创文章 · 获赞 0 · 访问量 1万+
展开阅读全文

unity用photonserver连接Mysql不成功

06-06

尝试修改caching_sha2_password 命令行似乎无效,直接改my.ini里的 default_authentication_plugin=mysql_native_password 会直接导致该数据库再也无法启动,已经重装两次mysql8.0.16了,彻底删除又重装 2019-06-06 01:36:02,496 [11] INFO MyGameServer.MyGameServer - 一个客户端连接过来了 2019-06-06 01:36:07,178 [16] INFO NHibernate.Cfg.Environment - NHibernate 4.1.1.GA (assembly 4.1.0.4000) 2019-06-06 01:36:07,178 [16] INFO NHibernate.Cfg.Environment - hibernate-configuration section not found in application configuration file 2019-06-06 01:36:07,178 [16] INFO NHibernate.Cfg.Environment - Bytecode provider name : lcg 2019-06-06 01:36:07,179 [16] INFO NHibernate.Cfg.Environment - Using reflection optimizer 2019-06-06 01:36:07,204 [16] INFO NHibernate.Cfg.Configuration - Searching for mapped documents in assembly: MyGameServer 2019-06-06 01:36:07,206 [16] INFO NHibernate.Cfg.Configuration - Mapping resource: MyGameServer.Mappings.User.hbm.xml 2019-06-06 01:36:07,459 [16] INFO NHibernate.Dialect.Dialect - Using dialect: NHibernate.Dialect.MySQL5Dialect 2019-06-06 01:36:07,492 [16] INFO NHibernate.Cfg.XmlHbmBinding.Binder - Mapping class: MyGameServer.Model.User -> users 2019-06-06 01:36:07,529 [16] INFO NHibernate.Cfg.Configuration - checking mappings queue 2019-06-06 01:36:07,529 [16] INFO NHibernate.Cfg.Configuration - processing one-to-many association mappings 2019-06-06 01:36:07,529 [16] INFO NHibernate.Cfg.Configuration - processing one-to-one association property references 2019-06-06 01:36:07,529 [16] INFO NHibernate.Cfg.Configuration - processing foreign key constraints 2019-06-06 01:36:07,530 [16] INFO NHibernate.Cfg.Configuration - processing filters (second pass) 2019-06-06 01:36:07,541 [16] INFO NHibernate.Dialect.Dialect - Using dialect: NHibernate.Dialect.MySQL5Dialect 2019-06-06 01:36:07,547 [16] INFO NHibernate.Dialect.Dialect - Using dialect: NHibernate.Dialect.MySQL5Dialect 2019-06-06 01:36:07,590 [16] INFO NHibernate.Exceptions.SQLExceptionConverterFactory - Using dialect defined converter 2019-06-06 01:36:07,590 [16] INFO NHibernate.Cfg.SettingsFactory - Generate SQL with comments: disabled 2019-06-06 01:36:07,591 [16] INFO NHibernate.Connection.ConnectionProviderFactory - Initializing connection provider: NHibernate.Connection.DriverConnectionProvider 2019-06-06 01:36:07,591 [16] INFO NHibernate.Connection.ConnectionProvider - Configuring ConnectionProvider 2019-06-06 01:36:07,607 [16] INFO NHibernate.Cfg.SettingsFactory - Transaction factory: NHibernate.Transaction.AdoNetWithDistributedTransactionFactory 2019-06-06 01:36:07,607 [16] INFO NHibernate.Cfg.SettingsFactory - Optimize cache for minimal puts: False 2019-06-06 01:36:07,607 [16] INFO NHibernate.Cfg.SettingsFactory - Connection release mode: auto 2019-06-06 01:36:07,607 [16] INFO NHibernate.Cfg.SettingsFactory - Default batch fetch size: 1 2019-06-06 01:36:07,607 [16] INFO NHibernate.Cfg.SettingsFactory - echoing all SQL to stdout 2019-06-06 01:36:07,607 [16] INFO NHibernate.Cfg.SettingsFactory - Statistics: disabled 2019-06-06 01:36:07,607 [16] INFO NHibernate.Cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled 2019-06-06 01:36:07,607 [16] INFO NHibernate.Cfg.SettingsFactory - Query translator: NHibernate.Hql.Ast.ANTLR.ASTQueryTranslatorFactory 2019-06-06 01:36:07,608 [16] INFO NHibernate.Cfg.SettingsFactory - Query provider: NHibernate.Linq.DefaultQueryProvider 2019-06-06 01:36:07,608 [16] INFO NHibernate.Cfg.SettingsFactory - Query language substitutions: {} 2019-06-06 01:36:07,609 [16] INFO NHibernate.Cfg.SettingsFactory - cache provider: NHibernate.Cache.NoCacheProvider, NHibernate, Version=4.1.0.4000, Culture=neutral, PublicKeyToken=aa95f207798dfdb4 2019-06-06 01:36:07,609 [16] INFO NHibernate.Cfg.SettingsFactory - Order SQL inserts for batching: disabled 2019-06-06 01:36:07,609 [16] INFO NHibernate.Cfg.SettingsFactory - Order SQL updates for batching: disabled 2019-06-06 01:36:07,609 [16] INFO NHibernate.Cfg.SettingsFactory - Batcher factory: NHibernate.AdoNet.NonBatchingBatcherFactory, NHibernate, Version=4.1.0.4000, Culture=neutral, PublicKeyToken=aa95f207798dfdb4 2019-06-06 01:36:07,609 [16] INFO NHibernate.Cfg.SettingsFactory - Default flush mode: Auto 2019-06-06 01:36:07,609 [16] INFO NHibernate.Cfg.SettingsFactory - Default entity-mode: Poco 2019-06-06 01:36:07,609 [16] INFO NHibernate.Cfg.SettingsFactory - Named query checking : enabled 2019-06-06 01:36:07,609 [16] INFO NHibernate.Cfg.SettingsFactory - Ignoring exceptions in BeforeTransactionCompletion : disabled 2019-06-06 01:36:07,620 [16] INFO NHibernate.Impl.SessionFactoryImpl - building session factory 2019-06-06 01:36:07,705 [16] _ERROR Photon.SocketServer.PeerBase - exception during handling of data.Peer:T:ClientPeer,ConnId:0,ip:127.0.0.1:54222, Data: F3-02-00-00-02-00-73-00-06-31-32-33-31-32-33-01-73-00-06-31-32-33-31-32-33, Exception:MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication method 'caching_sha2_password' not supported by any of the available plugins._ 在 MySql.Data.MySqlClient.Authentication.AuthenticationPluginManager.GetPlugin(String method) 在 MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.GetPlugin(String method, NativeDriver driver, Byte[] authData) 在 MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset) 在 MySql.Data.MySqlClient.NativeDriver.Open() 在 MySql.Data.MySqlClient.Driver.Open() 在 MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) 在 MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() 在 MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() 在 MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() 在 MySql.Data.MySqlClient.MySqlPool.GetConnection() 在 MySql.Data.MySqlClient.MySqlConnection.Open() 在 NHibernate.Connection.DriverConnectionProvider.GetConnection() 在 NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare() 在 NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords(Dialect dialect, IConnectionHelper connectionHelper) 在 NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update(ISessionFactory sessionFactory) 在 NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapping, Settings settings, EventListeners listeners) 在 NHibernate.Cfg.Configuration.BuildSessionFactory() 在 MyGameServer.NHibernateHelper.get_SessionFactory() 位置 C:\Users\52718\Desktop\PhotonServer教程\MyGameServer\NHibernateHelper.cs:行号 26 在 MyGameServer.NHibernateHelper.OpenSession() 位置 C:\Users\52718\Desktop\PhotonServer教程\MyGameServer\NHibernateHelper.cs:行号 33 在 MyGameServer.Manager.UserManager.VerifyUser(String username, String password) 位置 C:\Users\52718\Desktop\PhotonServer教程\MyGameServer\Manager\UserManager.cs:行号 96 在 MyGameServer.Handler.LoginHandler.OnOperationRequest(OperationRequest operationRequest, SendParameters sendParameters, ClientPeer peer) 位置 C:\Users\52718\Desktop\PhotonServer教程\MyGameServer\Handler\LoginHandler.cs:行号 24 在 MyGameServer.ClientPeer.OnOperationRequest(OperationRequest operationRequest, SendParameters sendParameters) 位置 C:\Users\52718\Desktop\PhotonServer教程\MyGameServer\ClientPeer.cs:行号 35 在 Photon.SocketServer.PeerBase.OnReceive(Byte[] data, SendParameters sendParameters) 位置 h:\svncontent\photon-socketserver-sdk_cloud\src\Photon.SocketServer\PeerBase.cs:行号 1243 在 Photon.SocketServer.PeerBase.OnReceiveInternal(Byte[] data, SendParameters sendParameters, Int32 rtt, Int32 rttVariance, Int32 numFailures) 位置 h:\svncontent\photon-socketserver-sdk_cloud\src\Photon.SocketServer\PeerBase.cs:行号 988 问答

没有更多推荐了,返回首页

©️2019 CSDN 皮肤主题: 书香水墨 设计师: CSDN官方博客

分享到微信朋友圈

×

扫一扫,手机浏览