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-insecuremysqld -installnet start mysqlmysql -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 mysqlsudo apt install mysql-servernetstat -tap | grep mysqlmysql -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的依赖项，彻底删除

转载于:https://www.cnblogs.com/ndzy01/p/11533655.html