MYSQL几个常用命令使用
source link: https://blog.51cto.com/u_15723831/5868453
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 修改密码
1. mysql -u root -p root 输入原密码登录命令行
2. use mysql;
3. update user set password=password('root123') where 'user' = 'root'; 5.7版本 update user set authentication_string=password('root123') where 'user' = 'root';
4. flush privileges; 提交应用.
5. You must reset your password using ALTER USER statement before executing this statement必须修改临时密码,命令:alter user user() identified by '@Juaner521';
二. mysql 修改远程连接
1. mysql -u root -p root
2. use mysql;
3. select host,user,password from user;查看是否允许远程连接
4. grant all privileges on *.* to root@'%' identified by "password"; , 如果 报错,可换个方法
CREATE USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'xxxxxx';
#给这个账户所有权限
GRANT ALL PRIVILEGES ON *.* TO'username'@'%';
1. flush privileges;
三. win 添加mysql服务：
1. 进入mysql\bin文件夹：mtsqld --install；
2. 如果提示：install/remove of the service denide,以管理员身份运行cmd。
四. 报错Ignoring the redo log due to missing... :
删除 mysql/data/目录下ib_logfile0``ib_logfile1重启就好。
推荐PHP项目(完整)： 点此直接网盘下载
- 赞
- 收藏
- 评论
- 分享
- 举报
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK