mysql怎么设置root密码

54次阅读

共计 5809 个字符，预计需要花费 15 分钟才能阅读完成。

本篇内容介绍了“mysql 怎么设置 root 密码”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让丸趣 TV 小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

[root@centos bin]# service mysqld stop
Shutting down MySQL.[ OK ]
[root@centos bin]# ./mysqld_safe –skip-grant-tables
[1] 21267
[root@centos bin]# 2016-05-16T18:14:00.092388Z mysqld_safe Logging to /soft/data//centos.err .
2016-05-16T18:14:00.120089Z mysqld_safe Starting mysqld daemon with databases from /soft/data/

[root@centos bin]#
[root@centos bin]# mysql -u root mysql
-bash: mysql: command not found
[root@centos bin]# ./mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.12 Source distribution

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 update user set password=PASSWORD(root) where user= root
ERROR 1054 (42S22): Unknown column password in field list
mysql
mysql
mysql
mysql use mysql
Database changed
mysql update user set password=PASSWORD(root) where user= root
ERROR 1054 (42S22): Unknown column password in field list
mysql
mysql
mysql
mysql
mysql select user from user;
+———–+
| user |
+———–+
| mysql.sys |
| root |
+———–+
2 rows in set (0.00 sec)

mysql desc user
–
+————————+———————————–+——+—–+———————–+——-+
| Field | Type | Null | Key | Default | Extra |
+————————+———————————–+——+—–+———————–+——-+
| Host | char(60) | NO | PRI | | |
| User | char(32) | NO | PRI | | |
| Select_priv | enum(N , Y) | NO | | N | |
| Insert_priv | enum(N , Y) | NO | | N | |
| Update_priv | enum(N , Y) | NO | | N | |
| Delete_priv | enum(N , Y) | NO | | N | |
| Create_priv | enum(N , Y) | NO | | N | |
| Drop_priv | enum(N , Y) | NO | | N | |
| Reload_priv | enum(N , Y) | NO | | N | |
| Shutdown_priv | enum(N , Y) | NO | | N | |
| Process_priv | enum(N , Y) | NO | | N | |
| File_priv | enum(N , Y) | NO | | N | |
| Grant_priv | enum(N , Y) | NO | | N | |
| References_priv | enum(N , Y) | NO | | N | |
| Index_priv | enum(N , Y) | NO | | N | |
| Alter_priv | enum(N , Y) | NO | | N | |
| Show_db_priv | enum(N , Y) | NO | | N | |
| Super_priv | enum(N , Y) | NO | | N | |
| Create_tmp_table_priv | enum(N , Y) | NO | | N | |
| Lock_tables_priv | enum(N , Y) | NO | | N | |
| Execute_priv | enum(N , Y) | NO | | N | |
| Repl_slave_priv | enum(N , Y) | NO | | N | |
| Repl_client_priv | enum(N , Y) | NO | | N | |
| Create_view_priv | enum(N , Y) | NO | | N | |
| Show_view_priv | enum(N , Y) | NO | | N | |
| Create_routine_priv | enum(N , Y) | NO | | N | |
| Alter_routine_priv | enum(N , Y) | NO | | N | |
| Create_user_priv | enum(N , Y) | NO | | N | |
| Event_priv | enum(N , Y) | NO | | N | |
| Trigger_priv | enum(N , Y) | NO | | N | |
| Create_tablespace_priv | enum(N , Y) | NO | | N | |
| ssl_type | enum(, ANY , X509 , SPECIFIED) | NO | | | |
| ssl_cipher | blob | NO | | NULL | |
| x509_issuer | blob | NO | | NULL | |
| x509_subject | blob | NO | | NULL | |
| max_questions | int(11) unsigned | NO | | 0 | |
| max_updates | int(11) unsigned | NO | | 0 | |
| max_connections | int(11) unsigned | NO | | 0 | |
| max_user_connections | int(11) unsigned | NO | | 0 | |
| plugin | char(64) | NO | | mysql_native_password | |
| authentication_string | text | YES | | NULL | |
| password_expired | enum(N , Y) | NO | | N | |
| password_last_changed | timestamp | YES | | NULL | |
| password_lifetime | smallint(5) unsigned | YES | | NULL | |
| account_locked | enum(N , Y) | NO | | N | |
+————————+———————————–+——+—–+———————–+——-+
45 rows in set (0.00 sec)

mysql update user set authentication_string=PASSWORD(root) where user= root
Query OK, 1 row affected, 1 warning (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 1

mysql flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql exit
Bye
[root@centos bin]# service mysqld restart
Shutting down MySQL.2016-05-16T18:16:32.859231Z mysqld_safe mysqld from pid file /soft/data/mysql.pid ended
[ OK ]
Starting MySQL.[ OK ]
[1]+ Done ./mysqld_safe –skip-grant-tables
[root@centos bin]#
[root@centos bin]#
[root@centos bin]#
[root@centos bin]# mysql -u root -p root
-bash: mysql: command not found
[root@centos bin]# ./mysql -u root -p root
Enter password:
ERROR 1049 (42000): Unknown database root
[root@centos bin]# ./mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.12