首页 > 代码库 > mysql 学习笔记(一)

mysql 学习笔记(一)

查询:
show databases;

show status;

show tables;

desc  table-name;



更改root密码:
方法一:mysqladmin -uroot -poldpassword  password newpassword
方法二:
mysql -uroot -p
use mysql
update user set password=password("newpasswd") where user="root";

select host,user,password from user;

+-----------+------------------+-------------------------------------------+
| host      | user             | password                                  |
+-----------+------------------+-------------------------------------------+
| localhost | root             | *FAE22ED156CC483651E55164E12EE8597A798849 |
| c600      | root             | *FAE22ED156CC483651E55164E12EE8597A798849 |
| 127.0.0.1 | root             | *FAE22ED156CC483651E55164E12EE8597A798849 |
| ::1       | root             | *FAE22ED156CC483651E55164E12EE8597A798849 |
| localhost | debian-sys-maint | *BF673A86346B2E5CFFEFA24D36E2C520F0B82A49 |
| localhost | test             | *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 |
+-----------+------------------+-------------------------------------------+

创建/授权用户:
grant select ,delete,update,insert,drop on db_name.* to user_name identified by "passwd" ;

grant all on db_name to user_name ;