mysql 数据库的简单操作

安装mysql数据库

sudo apt-get install mysql-server mysql-client
#pip install 包名 -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com

登录

mysql -u root -p

删除

sudo apt-get autoremove --purge mysql-server-5.7
 
sudo apt remove mysql-common
 
sudo rm -rf /etc/mysql/  /var/lib/mysql                                #清楚相关配置
 
dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P        #清楚残留数据
 
sudo apt autoremove
 
sudo apt autoclean

远程连接

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf 
bind-address = 127.0.0.1 #找到该行并注释

测试连接出现报错

添加远程连接权限

1: mysql> create user 'root'@'%' identified by '你自己的mysql密码';
2: mysql> grant all privileges on *.* to 'root'@'%';
3: mysql> flush privileges;

注意检查

bind-address = 127.0.0.1#该行是否被注释

若还出现错误可尝试将连接ip地址一栏localhost改为自己的ip

参考https://blog.csdn.net/t544846450/article/details/93510065
https://blog.csdn.net/time_future/article/details/82194325