![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql linux
govoboxx
这个作者很懒,什么都没留下…
展开
-
mysql重设root密码
1. # vi /etc/my.cnf 在[mysqld]的段中加上一句:skip-grant-tables 如: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-name-resolve skip-grant-tables #加上这句 2. # /et...原创 2014-01-02 15:43:49 · 156 阅读 · 0 评论 -
mysql output备份数据库
1.导出:select * from user into outfile '/tmp/bb.dat' fields terminated by ',' lines terminated by '\n' 2.导入:load data infile '/tmp/bb.dat' into table user fields terminated by ',' lines terminated...原创 2014-01-06 17:54:53 · 329 阅读 · 0 评论