重置Linux MySQL 随机码
来源:互联网 发布:金融数据分析软件 编辑:程序博客网 时间:2024/05/23 17:54
MySQL5.6 安装后,root会生成一个随机密码,无法用root登陆,可用以下方法重置root密码:
1、 /etc/init.d/mysql start --skip-grant-tables ----启动MySQL服务
2、登入数据库用updatetable的方式修改root密码
[root@ha02 mysql]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.24 MySQL Community Server (GPL)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set password=PASSWORD('root') where user="root";
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0
mysql> exit
3、重启MySQL服务,用重置后的密码即可登陆
[root@ha02 mysql]# service mysql restart
Shutting down MySQL.. SUCCESS!
Starting MySQL. SUCCESS!
[root@ha02 mysql]# mysql -uroot -proot
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.24
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
4、登陆后还需要设置root密码
mysql> show variables like '%buffer%'
-> ;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
mysql> set password=PASSWORD('root');
Query OK, 0 rows affected (0.07 sec)
mysql> show variables like '%buffer%';
+-------------------------------------+----------------+
| Variable_name | Value |
+-------------------------------------+----------------+
| bulk_insert_buffer_size | 8388608 |
| innodb_buffer_pool_dump_at_shutdown | OFF |
| innodb_buffer_pool_dump_now | OFF |
| innodb_buffer_pool_filename | ib_buffer_pool |
阅读全文
0 0
- 重置Linux MySQL 随机码
- linux MySQL重置密码
- [Linux]重置MySQL密码
- Linux重置MySQL密码
- linux重置mysql密码
- linux 重置mysql root密码
- Linux中重置mysql密码
- linux 重置mysql 已丢失密码
- linux/win重置mysql的root密码
- Linux下重置MySQL root密码
- linux/ubuntu 下重置mysql root 密码
- Linux下重置MySQL root密码
- Linux下重置MySQL的Root帐号密码
- win&Linux系统下重置MySQL密码
- Linux下mysql root密码重置方法
- linux环境下重置mysql密码
- linux/win重置mysql的root密码
- Linux mysql数据库密码忘记重置
- 实验2
- fstream学习中的输入问题
- 通过nova.utils.execute 执行shell命令
- Android Dialog 中的EditText自动获取焦点弹出软键盘
- VX中解决在绑定数据后没有及时更新的问题
- 重置Linux MySQL 随机码
- JavaScript学习笔记之共享onload事件
- mysql时间戳增减
- 新的个人站(采用GitHub pages)
- css相关
- 文章标题
- python的快速教程
- mysql查询in排序(备忘)
- shell循环语句