mysql5.7升级到8.0.11

参考这篇blog:https://www.cnblogs.com/xyabk/p/8967990.html其中有些问题

创建文件my.ini

[mysqld] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin
# These are commonly set, remove the # and set as required. basedir = D:\Program\MySQL datadir = F:\mysqldb\adchudb port = 3306 # server_id = .....
# Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
character-set-server = utf8mb4
#default_authentication_plugin=mysql_native_password
performance_schema_max_table_instances = 600 table_definition_cache = 400 table_open_cache = 256
[mysql] default-character-set = utf8mb4
[client] default-character-set = utf8mb4

插件密码不能有用一下方式:
 ALTER USER 'root@localhost' IDENTIFIED WITH mysql_native_password BY '密码';

jdbc驱动:

     <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.11</version>
        </dependency>

jdbc.driverClassName=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=false
jdbc.username=root
jdbc.password=
jdbc.defaultAutoCommit=false
jdbc.defaultReadOnly=false
jdbc.maxActive=200
jdbc.maxIdle=20
jdbc.maxWait=9000



阅读更多
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/u010231625/article/details/80346760
个人分类: mysql
想对作者说点什么? 我来说一句

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

关闭
关闭
关闭