scoop mysql_mysql

windows

scoop install mysql

配置my.ini

[mysqld]

datadir=C:\\Users\\ndzy\\scoop\\persist\\mysql\\data

删除C:\\Users\\ndzy\\scoop\\persist\\mysql\\datadata文件

在管理员cmd下

移除已错误安装的mysqld服务mysqld -remove MySQL

初始化mysqld --initialize-insecure

mysqld -install

net start mysql

mysql -uroot -p 一般密码为空或者在C:\Users\ndzy\scoop\persist\mysql\data\DESKTOP-UR6GHCB.err找密码

更改加密方式ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

更改密码ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';

刷新FLUSH PRIVILEGES;

net start mysql mysql -uroot -p

ubuntu

dpkg -l | grep mysql

sudo apt install mysql-server

netstat -tap | grep mysql

mysql -u root -p 此时没有密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';

FLUSH PRIVILEGES;

远程访问

use mysql;

update user set host = '%' where user = 'root';

select host, user from user;

FLUSH PRIVILEGES;

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

注释这一行bind-address

service mysql restart;

#允许所有用户远程访问 修改用户名和密码为你自己的

mysql> GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

#允许单个ip 修改用户名和密码为你自己的

mysql> GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'1.2.3.4' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

#最后

mysql> FLUSH PRIVILEGES;

mysql -h 198.13.60.35 -P3306 -u root -p

彻底删除mysql

首先在终端中查看MySQL的依赖项：

dpkg --list|grep mysql

卸载：

sudo apt remove mysql-common

卸载：

sudo apt autoremove --purge mysql-server-5.7

清除残留数据：

dpkg -l|grep ^rc|awk '{print$2}'|sudo xargs dpkg -P

再次查看MySQL的剩余依赖项：

dpkg --list|grep mysql

继续删除剩余依赖项，如：

sudo apt autoremove --purge mysql-apt-config

至此已经没有了MySQL的依赖项，彻底删除