mysql
windows
-
scoop install mysql
-
配置my.ini
[mysqld] datadir=C:\\Users\\ndzy\\scoop\\persist\\mysql\\data
-
删除
C:\\Users\\ndzy\\scoop\\persist\\mysql\\data
data文件 -
在管理员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;
- 移除已错误安装的mysqld服务
-
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的依赖项,彻底删除