尝试修改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
