mysql: error 1524

心已赠人 2022-07-15 07:30 87阅读 0赞

1、安装mysql 5.7.16  
2、修改my.ini为

Python code

[?][Link 1]

<table> 
 <tbody> 
 <tr> 
 <td> 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 </td> 
 <td> #&nbsp;For&nbsp;advice&nbsp;on&nbsp;how&nbsp;to&nbsp;change&nbsp;settings&nbsp;please&nbsp;see #&nbsp;http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html #&nbsp;***&nbsp;DO&nbsp;NOT&nbsp;EDIT&nbsp;THIS&nbsp;FILE.&nbsp;It's&nbsp;a&nbsp;template&nbsp;which&nbsp;will&nbsp;be&nbsp;copied&nbsp;to&nbsp;the #&nbsp;***&nbsp;default&nbsp;location&nbsp;during&nbsp;install,&nbsp;and&nbsp;will&nbsp;be&nbsp;replaced&nbsp;if&nbsp;you #&nbsp;***&nbsp;upgrade&nbsp;to&nbsp;a&nbsp;newer&nbsp;version&nbsp;of&nbsp;MySQL. [client] &nbsp; default-character-set=utf8 port&nbsp;=&nbsp;3306 &nbsp; [mysqld] #&nbsp;Remove&nbsp;leading&nbsp;#&nbsp;and&nbsp;set&nbsp;to&nbsp;the&nbsp;amount&nbsp;of&nbsp;RAM&nbsp;for&nbsp;the&nbsp;most&nbsp;important&nbsp;data #&nbsp;cache&nbsp;in&nbsp;MySQL.&nbsp;Start&nbsp;at&nbsp;70%&nbsp;of&nbsp;total&nbsp;RAM&nbsp;for&nbsp;dedicated&nbsp;server,&nbsp;else&nbsp;10%. #&nbsp;innodb_buffer_pool_size&nbsp;=&nbsp;128M &nbsp; #&nbsp;Remove&nbsp;leading&nbsp;#&nbsp;to&nbsp;turn&nbsp;on&nbsp;a&nbsp;very&nbsp;important&nbsp;data&nbsp;integrity&nbsp;option:&nbsp;logging #&nbsp;changes&nbsp;to&nbsp;the&nbsp;binary&nbsp;log&nbsp;between&nbsp;backups. #&nbsp;log_bin &nbsp; #&nbsp;These&nbsp;are&nbsp;commonly&nbsp;set,&nbsp;remove&nbsp;the&nbsp;#&nbsp;and&nbsp;set&nbsp;as&nbsp;required. basedir&nbsp;=&nbsp;"D:\Program&nbsp;Files\MySQL\MySQL&nbsp;Server&nbsp;5.7" datadir&nbsp;=&nbsp;"D:\Program&nbsp;Files\MySQL\MySQL&nbsp;Server&nbsp;5.7\data" tmpdir&nbsp;=&nbsp;"D:\Program&nbsp;Files\MySQL\MySQL&nbsp;Server&nbsp;5.7\data" socket&nbsp;=&nbsp;"D:\Program&nbsp;Files\MySQL\MySQL&nbsp;Server&nbsp;5.7\data\mysql.sock" port&nbsp;=&nbsp;3306 &nbsp; log-error&nbsp;=&nbsp;"D:\Program&nbsp;Files\MySQL\MySQL&nbsp;Server&nbsp;5.7\data\mysql_error.log" &nbsp; #&nbsp;server_id&nbsp;=&nbsp;..... &nbsp; max_connections&nbsp;=&nbsp;100 table_open_cache&nbsp;=&nbsp;256 query_cache_size&nbsp;=&nbsp;1M &nbsp; tmp_table_size&nbsp;=&nbsp;32M thread_cache_size&nbsp;=&nbsp;8 &nbsp; innodb_data_home_dir&nbsp;=&nbsp;"D:\Program&nbsp;Files\MySQL\MySQL&nbsp;Server&nbsp;5.7\data\" innodb_flush_log_at_trx_commit&nbsp;=&nbsp;1 innodb_log_buffer_size&nbsp;=&nbsp;128M innodb_buffer_pool_size&nbsp;=&nbsp;128M innodb_log_file_size&nbsp;=&nbsp;10M innodb_thread_concurrency&nbsp;=&nbsp;16 innodb-autoextend-increment&nbsp;=&nbsp;1000 &nbsp; #&nbsp;Remove&nbsp;leading&nbsp;#&nbsp;to&nbsp;set&nbsp;options&nbsp;mainly&nbsp;useful&nbsp;for&nbsp;reporting&nbsp;servers. #&nbsp;The&nbsp;server&nbsp;defaults&nbsp;are&nbsp;faster&nbsp;for&nbsp;transactions&nbsp;and&nbsp;fast&nbsp;SELECTs. #&nbsp;Adjust&nbsp;sizes&nbsp;as&nbsp;needed,&nbsp;experiment&nbsp;to&nbsp;find&nbsp;the&nbsp;optimal&nbsp;values. join_buffer_size&nbsp;=&nbsp;128M sort_buffer_size&nbsp;=&nbsp;32M read_rnd_buffer_size&nbsp;=&nbsp;32M &nbsp; max_allowed_packet&nbsp;=&nbsp;32M explicit_defaults_for_timestamp&nbsp;=&nbsp;true &nbsp; sql_mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" </td> 
 </tr> 
 </tbody> 
</table>

3、下载mysql 5.6.27，并解压  
4、拷贝其中的data文件夹中的mysql文件夹至5.7.16版本的对应位置  
  
5、安装mysql-connector-odbc-noinstall-5.3.6-winx64  
  
6、用root登陆mysql一切正常；添加root密码，再次用root加密码登陆，失败，显示“”error 1524: plugin ... in not loaded"  
  
  
7、在my.ini中添加了skip-grant-tables，然后不用密码登陆root  
8、mysql>use mysql;  
9、mysql>update user set password=PASSWORD("123456") where user='root';

10、修改成功，再次root加密码登陆，失败，还是同样的问题

11、在my.ini中添加了skip-grant-tables，然后不用密码登陆root。mysql> SELECT Host,User,Password,plugin from user;发现plugin参数不是“mysql\_native\_password”

**12、update user set plugin='mysql\_native\_password';搞定。**

[Link 1]: http://bbs.csdn.net/topics/392044706#clipboardWindow