【mysql】解决报错：SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client 错误信息提示SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client原因由于MySQL 8默认使用了新的密码验证插件：caching_sha2_password，而低版本的PHP版本中所带的mysqlnd无法支持这种验证。故报“请求客户端未知的身份验证方法”。解决方案一可以通过phpinfo()函数了解当前安装的PHP是否支持caching_sha2_password方案二更改加密方式 alter user 'root'@'localhost' identified with mysql_native_password by '123456'; flush privileges;

【mysql】让数据库支持emoji表情 此处我们以typecho的文章表为例依次执行下列sqlALTER DATABASE typecho_blog CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE typecho_blog.typecho_contents CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;查看结果SHOW VARIABLES WHERE Variable_name LIKE 'character%' OR Variable_name LIKE 'collation%';显示如下,即为成功！Variable_name Value character_set_client utf8mb4 character_set_connection utf8mb4 character_set_database utf8mb4 character_set_filesystem binary character_set_results utf8mb4 character_set_server utf8mb4 character_set_system utf8 character_sets_dir /www/server/mysql/share/charsets/ collation_connection utf8mb4_general_ci collation_database utf8mb4_unicode_ci collation_server utf8mb4_general_ci

【Sql】mysql whereIn根据查询id排序 mysql in根据查询id排序mysql in根据查询时，返回结果是自行排序的，如果要按照我们查询的ID进行排序， 要用到order by field,下面用几个例子来说明一下mysql in查询排序SQL:select * from laofan_table where id IN (3,6,9,1,2,5,8,7);这样的情况取出来后，其实，id还是按1,2,3,4,5,6,7,8,9,排序的， 但如果我们真要按IN里面的顺序排序怎么办？我们可以用order by fieldSQL: select * from laofan_table where id IN (3,6,9,1,2,5,8,7) order by field(id,3,6,9,1,2,5,8,7);查询出来的结果就是按自定义的ID进行排序了.orm 用法$ret = Db::table('laofan') ->field('*') ->whereIn('id',$ids) ->order('id',$ids) ->select() ->toArray();