B 1. 问题 - MySQL数据库和Front安装时的问题（7.8）

悠悠 2022-05-19 23:29 120阅读 0赞

1.  打开 front 出现 `1251- Client does not support authentication protocol` 的错误
    
    > 原因：密码机制改变  
    > 参考：[navicat 连接 mysql 出现Client does not support authentication protocol requested by server][navicat _ mysql _Client does not support authentication protocol requested by server]
2.  net start mysql 启动无效的解决办法
    
    > 参考：[net start mysql启动无效的解决办法][net start mysql]  
    > 办法：以管理员身份运行  
    > ①启动：在运行框内输入:net start mysql80  
    > ②关闭：在运行内输入：net stop mysql80
3.  win10服务打开方式
    
    > 参考：[win10服务在哪里打开 怎么样打开系统服务窗口][win10_]

# 安装和卸载mysql for windows #

安装：[在win10上安装mysql数据库][win10_mysql]  
卸载：控制面板

# 创建本地用户 #

报错42000

create user 'psh'@'localhost' identified by '1234';
    grant select privileges on *.* to 'psh'@'localhost';

> 参考：[MySQL版本8.0.11在创建账户并授予select权限遇到错误ERROR 1064 (42000)][MySQL_8.0.11_select_ERROR 1064 _42000]

# 数据库远程连接 #

1.  创建用户 `CREATE USER 'test'@'%' IDENTIFIED BY '123';`
2.  为用户指定数据库 `GRANT SELECT, INSERT, UPDATE, DELETE ON test1.* TO 'test11'@'%';`

# 数据库常用指令 #

*  查询记录总条数  
    `select count(*) from dd_comment;`
 *  删除所有记录  
    `truncate table dd_list;`
 *  查询ID在第几行  
    `select count(*)+1 from dd_list where id < 23524155;`

[navicat _ mysql _Client does not support authentication protocol requested by server]: https://www.cnblogs.com/xiaojian1/p/mysql.html
[net start mysql]: https://blog.csdn.net/Java_Web_Android/article/details/72819341
[win10_]: https://jingyan.baidu.com/article/636f38bb96b4d2d6b8461084.html
[win10_mysql]: https://jingyan.baidu.com/article/642c9d343557e9644b46f743.html
[MySQL_8.0.11_select_ERROR 1064 _42000]: https://blog.csdn.net/yanpenggong/article/details/80964081