4
MySQL操作笔记
source link: https://jiajunhuang.com/articles/2020_05_01-mysql_notes.md.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
MySQL操作笔记
MySQL是我最常用的关系型数据库,不过运维相关的一些命令,我不是很常用,但是偶尔又要用,每次都要去搜索太麻烦了,遂作笔记。
把默认编码设置为 utf8mb4
更改 /etc/mysql/my.cnf
,ubuntu的话,更改 /etc/mysql/conf.d/mysql.cnf
:
[client]
default-character-set = utf8mb4
[mysqld]
collation_server = utf8mb4_unicode_ci
character_set_server = utf8mb4
[mysql]
default-character-set = utf8mb4
创建用户,授权,删除用户,删除授权
> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
> GRANT ALL PRIVILEGES ON mydb.* TO 'monty'@'localhost';
> FLUSH PRIVILEGES;
> quit
@
后面接地址,可以是IP地址,也可以是 %
代表所有地址,也可以是 localhost
代表本地。
删除用户之后,授权会被一起删掉:
> DROP USER dbadmin@localhost;
查看授权:
> SHOW GRANTS FOR rfc@localhost;
如果只想删除授权的话:
> REVOKE INSERT, UPDATE ON classicmodels.* FROM rfc@localhost;
> ALTER USER 'user-name'@'localhost' IDENTIFIED BY 'NEW_USER_PASSWORD';
> FLUSH PRIVILEGES;
设置root密码
> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
否则会一直报错 ERROR 1698 (28000): Access denied for user 'root'@'localhost'
。这样修改之后,在本地连接才能使用密码。
我本地的MySQL有一个cronjob每天进行备份:
@daily /usr/bin/mysqldump --single-transaction --quick --lock-tables=true --all-databases | gzip -c > /backup/mysql-$(date +\%F).sql.gz
参考资料:
关注公众号,获得及时更新
一个Golang gRPC握手错误的坑
Golang(Go语言)爬虫框架colly简明教程及源码阅读与分析
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK