Tags: style blog color using SP data on div logIt is obviously unsafe to use the superuser sa everywhere, so there is a need to create a user and make it accessible to only one database. Of course, you can use the SQL Server's own graphical Interface wizard, but it's too hard to use! Sometimes the code is more straightforward, like this:--using a database that has already been created UseMyDBGO--Create a login user and passwordEXECSp_addlogin N'Mydb_user','123456'--make Mydb_user a legitimate us
installation is complete, start MySQL:Set Password:Authorized Remote access: Login:Using the MySQL database (the real database, not the database software), all permissions for all tables (*. *) for all databases (all privileges) are granted to the root user accessed through any IP (%), the password is 123456, and the last flush privileges).Open firewall port: Use Vim to modify/etc/sysconfig/iptables, add a line (here is to simply add a row, more firewall knowledge please learn by yourself):To r
VARCHAR2 (+) NOT NULL,Age int Check (AGEGT;18 and age)CREATE TABLE Orders (OID VARCHAR2 (TEN) is not NULL,UserID Number (9),Primary KEY (OID),FOREIGN KEY (userid) references users (ID))Delete tables: drop table OrdersModify table name: ALTER TABLE ordersRename to OrderssAdd column: ALTER TABLE ordersAdd price number (9)To modify the data type of a column: ALTER TABLE ordersModify price Number (10)Delete column: ALTER TABLE ordersDrop Column PriceModify column name: ALTER TABLE ordersRename colu
1. Create a database user using PL/SQL developerCREATE USER LISI identified by LISI;Explanation: Create User: Is the SQL keyword that creates the database user, followed by the user name;Identified by: is the SQL keyword that sets the database password,2, the permissions of the linked database to Lisi usersGRANT CONNECT to LISI;Explanation: Grant:oracle Database authorization keyword, indicating the meaning of authorizationA default role for the Connect:oracle database, only the permissions on t
How to authorize mysq Enterprise edition? Registration code? Or what? How to authorize mysq Enterprise edition? Registration code? Or what? Share: How to authorize mysq Enterprise edition? Registration code? Or what?
How to authorize mysq Enterprise edition? Registration code? Or what? Share:
------ Solution --------
Tags: creating regular users and authorizing common SQL statements MySQL database backup and recoveryFirst, create a regular user and authorize 1, create a user and authorize[Email protected] ~]# mysql-uroot-pEnter Password:Welcome to the MySQL Monitor. Commands End With; or \g.Your MySQL Connection ID is 1Server version:5.6.36 MySQL Community Server (GPL) Copyright (c), Oracle and/or its affiliates. All ri
Oracle11g allows you to create tablespaces, create users, authorize roles, Import and Export tables, and garbled Chinese characters.Premise: the Oracle11g database has been installed on the local machine. Requirement: Use the PL/sqldatabase Connection Tool to operate Oracle database 1. To create a tablespace and operate a database, you must first create a user and grant permissions to the user; when creating a user, you must specify the tablespace and
Add a user to MySql, create a database, authorize the user, delete the user, and change the password bitsCN.com
1. create a user.
// Log on to MYSQL
@> Mysql-u root-p
@> Password
// Create a user
Mysql> insert into mysql. user (Host, User, Password, ssl_cipher, x509_issuer, x509_sub
Ject) values ("localhost", "pppadmin", password ("passwd "),'','','');
In this way, a user named: phplamp password: 1234 is created.
Then log on.
Mysql> exit;
@> Mysql-u
user 'pig' @ '% ';
When logging in, first exit the current exit, and then enter the following
Mysql-h 127.0.0.1-u linlin-p password
Mysql-h 127.0.0.1-u pig-p password
3. authorization:Command: GRANT privileges ON databasename. tablename TO 'username' @ 'host'Note:
Privileges-Operation permissions of a user, such as SELECT, INSERT, and UPDATE (for a detailed list, see the end of this article ). use ALL .; databasename-database name, tablename-table name. if you want to grant the user the corres
]
// Authorize the user to send emails to the group
# By default (create only groups and add users without zmprov authorization), all users can send emails to all groups created under the domain name, after explicitly authorizing some users to send emails, other users cannot send emails to this group.
# To Use Authorization commands, you must enable the milter Server
How to enable: Console ----> global settings -----> MTA ------> enable milter Server
Share new users and authorization methods in Mysql, and authorize mysql
In the project development process, you may need to open your own database to others, but to ensure security, you cannot open other databases on your server at the same time. You can create a new user and grant the user specific database permissions.
Test environment: Centos 6.3 and Mysql 5.3
1. Create a user
Copy codeThe Code is as follows:// Log on to MYSQL@> Mysql-u root-p@> Pa
"));
Second: User authorization
You must first log in to the root account (or have an account that can be authorized)
Full Authority Authority:
Mysql> GRANT all privileges in databasename.tablename to ' username ' @ ' host ';
Partial Permission Authorization
Mysql> GRANT SELECT, INSERT on Databasename.tablename to ' username ' @ ' host ';
Parameter analysis:DatabaseName: The name of the database to authorize, if it is a full database, you can u
Common commands for mysql to authorize, start, and start servicesOne or four startup methods:
1. mysqld
Start the mysql server :. /mysqld -- defaults-file =/etc/my. cnf -- user = root client connection: mysql -- defaults-file =/etc/my. cnf or mysql-S/tmp/mysql. sock
2. mysqld_safe
Start the mysql server :. /mysqld_safe -- defaults-file =/etc/my. cnf -- user = root client connection: mysql -- defaults-file =/etc/my. cnf or mysql-S/tm/mysql. sock
3. my
Test environment: WIN32 mysql5.0.45First, declare that, in general, you need to have the root permission in MySQL to modify the mysql password and grant permissions.Note: This operation is performed at the WIN command prompt, and phpMyAdmin is also applicable.User: phplamp user database: phplampDB1. Create a user.// Log on to MYSQL@> Mysql-u root-p@> Password// Create a userMysql> insert into mysql. user (Host, User, Password, ssl_cipher, x509_issuer, x509_subject) values ("localhost", "pppadmin
1. Create a user.
// Log on to MYSQL
@> Mysql-u root-p
@> Password
// Create a user
Mysql> insert into mysql. user (Host, User, Password, ssl_cipher, x509_issuer, x509_sub
Ject) values ("localhost", "pppadmin", password ("passwd "),'','','');
In this way, a user named: phplamp password: 1234 is created.
Then log on.
Mysql> exit;
@> Mysql-u phplamp-p
@> Enter the password
Mysql> logon successful
2. Authorize the user.
// Log on to MYSQL (with ROOT perm
Why do I want to talk about mysql 5? In previous versions, we can directly use INSERT to INSERT mysql users to mysql tables. After mysql5 is complete, we won't be able to do this, next I will introduce MySql 5. x. For details about how to create and authorize users, refer.
Add a connection user account in the mysql user table:
Here, do not directly use the INSERT statement to add user records. INSERT may occur:
ERROR 1364 (HY000): Field 'ssl _ cipher
How to authorize query of views starting with v $ in non-sys and system User stored procedures, such as v $ mystat and v $ statname. These View queries can be used in stored procedures only after authorization is displayed under sys. However, if we use grant on v $ view to username, we will receive a ORA-02030 error. SQL> grant select on v $ mystat to scott; grant select on v $ mystat to scott www.2cto.com ORA-02030: you can only query from a fixed ta
Use mydb
Go
-- 1. Create a test user
-- 1.1 add login user and password
Exec sp_addlogin n 'Tony ', '123'
-- 1.2 make it a legal user of the current database
Exec sp_grantdbaccess n 'Tony'
-- 2. Set operation authorization
-- 2.1 Grant all permissions on your own database
Exec sp_addrolemember n 'db _ owner', N 'Tony'
-- 2.2: Set specific operation Permissions
-- Grant Tony the operation permission on all user tables.
Grant select, insert, update, delete to Tony
-
[Mysql] Common commands-user operations (create, authorize, modify, delete) and mysql user operations
Each user in Mysql corresponds to different user addresses and permissions.
There are three ways to create a Mysql user: 1. create user 2. grant 3. Operate the mysql. user table.
1. create user 'username' @ 'host' identified by 'Password ';Example: create user 'A' aa '@ 'localhost' identified by '123 ';Create user 'A' @ '192. 168.1.101 _ 'idendified
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.