mysql

windows

1. scoop install mysql

2. 配置my.ini

   [mysqld]
   datadir=C:\\Users\\ndzy\\scoop\\persist\\mysql\\data

3. 删除C:\\Users\\ndzy\\scoop\\persist\\mysql\\datadata文件
4. 在管理员cmd下
   1. 移除已错误安装的mysqld服务mysqld -remove MySQL
   2. 初始化mysqld --initialize-insecure
   3. mysqld -install
   4. net start mysql
   5. mysql -uroot -p 一般密码为空或者在C:\Users\ndzy\scoop\persist\mysql\data\DESKTOP-UR6GHCB.err找密码
   6. 更改加密方式ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
   7. 更改密码ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
   8. 刷新FLUSH PRIVILEGES;

5. net start mysql mysql -uroot -p

ubuntu

1. dpkg -l | grep mysql
2. sudo apt install mysql-server
3. netstat -tap | grep mysql
4. mysql -u root -p 此时没有密码
5. ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
6. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
7. 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