Mysql常用笔记

常用语句
数据库连接
  本机：
    mysql -u root -p
  远程：
    mysql -h IP -u root -p
    mysql -h ip -P 3306 -u root -p 数据库名称
  启动服务：
    net start mysql
  关闭服务：
    net stop mysql
  修改密码：
    ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘密码’
  安装命令：
    mysqld -install

数据库安装问题
1.解决mysql找不到VCRUNTIME140_1.dll

    下载文件VCRUNTIME140_1.dll
    解压后将vcruntime140_1.dll复制到C:WindowsSystem32即可

2.Navicat 连接MySQL8.0，错误：Authentication plugin ‘caching_sha2_password’ cannot be loaded

    1.mysql -uroot -p  
    2.use mysql;
    3.ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; 
    4.ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
    5.ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
    6.FLUSH PRIVILEGES;