修改密码
alter user root@localhost identified by '123456' ;
创建用户并授权
create user test@localhost identified by '123456' ;
grant all privileges on test.* to test@localhost ;
###无法启动修理过程
mysqld -remove mysql //移除服务
mysql --install mysql --defaults-file=my.ini //安装服务
mysqld --initialize-insecure --user=mysql //初始化
mysqldump -h localhost -u root -p123456 database > dump.sql
mysqldump -h localhost -u root -p123456 database table > dump.sql
mysqldump -h localhost -u root -p123456 -d database > dump.sql
mysqldump -h localhost -u root -p123456 -d database table > dump.sql //-d代表不包含数据,只导出结构
注意不是登录了mysql执行命令,而是在命令窗口执行,无需登陆
- 到处查询结果和记录日志
tee path 开启记录输出
select * from table into outfile path 将查询结果导入文件
- navicat 连接报加密方式错误
alter user kelan@localhost identified with mysql_native_password by '123456';