Create user, library and permission assignments
-- 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