Shulou(Shulou.com)06/01 Report--

-- Building a database

Create database zxlh default character set utf8

-- create users who only access zxlh database.% means no restrictions on ip.

Grant all PRIVILEGES on zxlh.* to 'zxlh'@'%' identified by' zxlh'

-- create users and access all databases

Grant all PRIVILEGES on *. * to 'root'@'%' identified by' 123456 'WITH GRANT OPTION

-- Refresh

Flush privileges

More detailed permissions can be assigned through tools such as navicte

User information can be seen in mysql.user

Use mysql

Select host,user,passsword from user

Forget your password:

Service mysql55-mysqld stop

Mysqld_safe-user=root-skip-grant-tables

Mysql-u root

Use mysql

Update user set password=password ("new_pass") where user= "root"

Flush privileges

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.