今天安裝的mysql5.7.18，
[root@localhost ~]# mysql -u root -proot
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.18
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
ERROR 1820 (HY000): Unknown error 1820
mysql> use mysql
ERROR 1820 (HY000): Unknown error 1820
網上說是密碼策略的問題 需要修改密碼 但是我修改了還是報錯啊
mysql> SET PASSWORD = PASSWORD('root!1234');
ERROR 1819 (HY000): Unknown error 1819
求大神指導，急急急！！！！！！！！！！！！！！！！！1
[root@localhost log]# tail -10 /var/log/mysqld.log
2018-04-10T20:13:38.990628Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-04-10T20:13:38.990698Z 0 [Note] IPv6 is available.
2018-04-10T20:13:38.990706Z 0 [Note] - '::' resolves to '::';
2018-04-10T20:13:38.990721Z 0 [Note] Server socket created on IP: '::'.
2018-04-10T20:13:39.000815Z 0 [Note] Event Scheduler: Loaded 0 events
2018-04-10T20:13:39.001024Z 0 [Note]
2018-04-10T20:13:39.001039Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2018-04-10T20:13:39.001043Z 0 [Note] Beginning of list of non-natively partitioned tables
2018-04-10T20:13:39.017737Z 0 [Note] End of list of non-natively partitioned tables
2018-04-10T20:13:39.336236Z 3 [Note]
查看日志 還沒有今天4月20的日志報錯資訊。。。。。。
uj5u.com熱心網友回復：
密碼不行。換個更復雜的，比如 !Pxyz4321轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/90930.html
標籤：MySQL
上一篇：XML大檔案匯入sql等資料庫