ubantu18.10安装mysql

• 安装
  
  sudo apt-get update
  
  sudo apt-get install mysql-server
• 配置
  
  sudo mysql_secure_installation
• 检查mysql服务状态
  
  systemctl status mysql.service
• 配置远程访问
  
  sudo mysql -uroot -p
• 给root配置密码
  GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY "123456";
• 新建数据和用户
  
  ##1 创建数据库weixx
  CREATE DATABASE weixx;
  ##2 创建用户wxx(密码654321) 并赋予其weixx数据库的所有权限
  GRANT ALL PRIVILEGES ON weixx.* TO wxx@localhost IDENTIFIED BY "654321";
  
   

• 设置连接mysql不使用sudo
  查看当前用户
  select user,host from mysql.user;
   

  删除root账号
  drop user root@localhost;

  重新创建root
  create user root@localhost identified by 'mysql';

  授权：
  grant all privileges on *.* to root@localhost with grant option;

  刷新权限：
  flush privileges;

  退出mysql，重新连接：
  mysql -uroot -pmysql

  不用加sudo了，搞定
  关于重置密码

  host为%时允许远程登录

  重置密码：
  方法1
  SET PASSWORD FOR root@'localhost' = PASSWORD('password');

  方法2
  UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';

  方法3
  USE mysql;
  UPDATE user SET Password = PASSWORD('newpwd') WHERE Host = 'localhost' AND User = 'root';

• 转自https://blog.csdn.net/weixin_42844490/article/details/83064378

 

 

•