Get the App
SLTechnology News&Howtos  ›  Database  › 

Create user, library and permission assignments

Shulou Source: shulou.com Published: 2022-06-01 05:47:51 11月17日 Update

-- 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

Tags: Users data databases permissions assignments details information can be passed passwords tools restrictions Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Microsoft OPPO Reno Huawei Xiaomi MySQL