mysql-(v)-Permissions

---MySQL database permissions issue: Root

Have all the privileges (can do anything)

--rights account, only partial permissions, only to operate a database, a table

How to modify MySQL permissions password

Password function MD5 cryptographic function (one-way encryption)SELECTPASSWORD ('Root'); UseMySQL;SELECT *  from USER;--Change PasswordUPDATE USER SETPASSWORD=PASSWORD ('New Password')WHERE USER='Root'Restart MySQL service

--Assigning a rights account (

Only

Selet

Day16.employee this watch

)

CREATE  on  to ' CX (Privileged user name) '@'localhost'by'123456 (Privileged user password)'

---mysql Backup and restore

--Backup

- - > Backup directory

--Restore

- -P  <  backup directory

mysql-(v)-Permissions