mysql小记
文章平均质量分 58
Eight_Quit2022
这个作者很懒,什么都没留下…
展开
-
ur not allowed to create a user with grant
update user set host = ‘%’ where user = ‘root’;GRANT ALL ON . TO ‘root’@’%’ ;flush privileges;plugin caching_sha2_password could not be loaded#change ruleALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘xxxxxxxx’ PASSWORD EXPIRE NEVER;#update passwdA.原创 2022-01-25 17:41:06 · 76 阅读 · 0 评论 -
mysql_yum安装
1.下载yum源wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm2. ll /etc/yum.repos.d/ | grep mysqlrpm -ivh mysql80-community-release-el7-1.noarch.rpmll /etc/yum.repos.d/ | grep mysql3.grep keepcache /etc/yum.confsed -i s’#keepcac原创 2022-01-24 13:41:54 · 1686 阅读 · 0 评论 -
mysql散记
kill pkill killall优雅关闭数据库1.mysqladminmysqladmin -uroot -pxxx shutdown2.自带的脚步/etc/init.d/mysql stop3.KILL 信号的方法kill -USR cat path/pid登录mysql1.mysql2.mysql -uroot3.mysql -uroot -p 回车 敲密码she...原创 2020-03-04 00:33:39 · 303 阅读 · 0 评论