Add sudo to a command to execute the command with the permissions of the Super User. But not any user can use sudo. this command can be used only when the user belongs to the sudo group. If you want to add a user to the sudo group
Tags: need to use different access date Auth sample Add service--Create a simple login with: newlogin; login password: 123456; default database: Master, default database can also not be specified. EXEC sp_addlogin ' newlogin ', ' 123456 ', ' master ' --Create User --Create a simple user that, if you do not specify a user
Label:Transferred from: http://www.cnblogs.com/fly1988happy/archive/2011/12/15/2288554.html MySQL add user, new database, user authorization, delete user, change password (note that each line followed by A; indicates that a command statement ends): 1. Create a new user 1.1 L
of the CREATE user, DROP user, RENAME user, and REVOKE all privileges. CREATE VIEW Allows use of CREATE VIEW. DELETE Allows use of DELETE. DROP Allows use of DROP TABLE. EXECUTE Allows the user to run stored routines. FILE Allows use of SELECT ... Into OUTFILE and LOAD DATA INFILE. INDEX Allows use of CREATE ind
Add a user to a user group in Linux. do not directly use usermod-GgroupA to leave other user groups, it is only a member of the groupA user group. -A option should be added: usermod... add a u
Net user username and password/Add create user
Other:Net use \ IP \ IPC $ ""/User: "" Create an empty IPC LinkNet use \ IP \ IPC $ "password"/User: "User Name" Create an IPC non-empty LinkNet use H: \ IP \ C $ "password"/
password to 123.Mysql>grant all on vtdc.* to [e-mail protected] identified by ' 123′;The user Jee from 10.163.225.87 is assigned permission to perform all operations on the database VTDC all tables, and the password is set to 123.Mysql>grant all on * * to [E- Mail protected] identified by ' 123′;The user Jee from 10.163.225.87 is assigned permission to perform all operations on all tables in all databases,
1. Grant statement
Format: Grant Select on database. * To User name @ login host identified by "password"
Description
(1) Grant all grants all permissions
(2) All tables in the Demo.* database demo
(3) NewUser user name
(4) @localhost MySQL server servers on the local computer
(5) Identfified by ' Password ' Set password
Add a
1. Add a user groupTo add a user group using the Groupadd command:Groupadd group_nameThis operation needs to be done by the system administrator.2. Delete a user groupTo delete a user group using the Groupdel command:Groupdel grou
;drop user username @ '% ';Drop user username @ localhost;
4. Modify the specified user password
@>mysql-u root-pbr/>@> PasswordMysql>flush privileges;
5. List all databases
Mysql>show database;
6. Switching the database
Mysql>use ' database name ';
7. List all Tables
Mysql>show tables;
8. Display the d
VI to edit the/etc/sudoers effect is the same without this command;Sudoedit Note: Same as sudo function;2) tools or commands for managing user groups (group);groupadd 注:添加用户组;groupdel 注:删除用户组;groupmod 注:修改用户组信息groups 注:显示用户所属的用户组grpckgrpconv 注:通过/etc/group和/etc/gshadow 的文件内容来同步或创建/etc/gshadow ,如果/etc/gshadow 不存在则创建;grpunconv 注:通过/etc/group 和/etc/gshadow 文件内容来同步或创建/etc/group ,然后删除gshadow文件; 3,/etc/skel d
' dog ' @ 'localhost''The time of authorization is this (or the like): Grant SELECT on Test.user to' dog ' @ 'localhost', use revoke SELECT on the *.' dog ' @ 'localhost'The command does not revoke the user's SELECT operation on the Users table in the test database. Conversely, if authorization is using Grant SELECT on the *.' dog ' @ 'localhost'; The revoke SELECT on Test.user from' dog ' @ 'localhost'The command cannot revoke the user's SELECT permission to the Users table in the test database
1, Build Users:
AddUser PHPQ//New PHPQ Userpasswd PHPQ//Set Password to PHPQ user
2, the establishment of the Working GroupGroupadd test//New test Workgroup
3, new users to increase the team at the same timeUSERADD-G test PHPQ//new PHPQ user and add to test workgroup
Note:: The shell used by the group-D home Directory-S for-G
4, to the existing
In Linux, how does one add a user to a user group? How does one add a user to a user group in Linux? When using a common method to create a user, such as the Shell code # useradd testus
MySQL
Method Two:
Open the admin tools service and find the MySQL service.Start the service by right-clicking on the startup or clicking on the left side of the boot directly.
6 when the installation is complete, the root account default password is blank, the password can be modified to the specified password. such as: 123456
C:>mysql–uroot
mysql>show databases;
Mysql>use MySQL;
Mysql>update user SET Password=password ("123456") WHERE
3. Add Users:(Note: Unlike the above, the following is because it is a command in a MySQL environment, so it is followed by a semicolon as a command terminator)Format: Grant Select on database. * To User name @ login host identified by "password"The first type:Add a user test1 password to ABC so that he can log on on any host and have access to queries, insertion
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.