MySQL Default has a root user, but this user rights are too large, generally only in the management of the database when used. If you are connecting to a MySQL database in your project, it is recommended that you create a new user with a smaller
MySQL database installation and basic configurationThe CentOS6 and RHEL6 system yum contains the MySQL installation package, which is version MySQL5. The name of the RPM package is mysql-server.Use the following command to install the MySQL database:
1 Brief introduction1.1 Overview1.2 Permissions Classification2 adding usersThe 2.1 syntax is for example the following:CREATE user user_specification [, user_specification] ... user_specification: user [ | Identified with Auth_plugin [as
The concept of Rights management:MySQL Rights management is mainly to login MySQL users to verify, reasonable authority planning will improve the security of MySQL server.
1, verify the host, username, password (from where)
2, verify
When connecting MySQL data remotely using the Navicat for MySQL client software, the connection appears 2003-can ' t connect to the MySQL on ' 192.168.1.2 ' (10061) error, because MySQL does not allow remote connections.Here's how to modify it:1:
This article describes some of the commands commonly used in MySQL, including the use of creating and modifying databases, tables in databases, MySQL Rights management commands Grant, REVOKE, and so on.Common commands for creating and managing MySQL
1: Use the show statement to find out what database currently exists on the server:mysql> SHOW DATABASES;2:2. Create a database Mysqldatamysql> CREATE DATABASE mysqldata;3: Select the database you createdmysql> use Mysqldata; (press ENTER to appear
MySQL creates a new user:CREATE USER username identified by ' password ';Assign all permissions to the new user:GRANT all privileges on * * to ' username ' @ ' localhost ' identified by ' password ';To modify a user's permissions, first cut back to
The database migration (A-> B) requires that the user be migrated, while the user table (Mysql.user) has hundreds of users. There are 2 ways to migrate quickly:1, in the same version of the condition, directly back up a server MySQL database,
Chapter 08:creating Your Web DatabaseDestination:set UO a MySQL database for use on a Web siteContents:[1] Creating a database (creating databases)[2] Users and privileges (users and permissions)[3] Introduction to the privilege system (Introduction
9.8 creating MySQL users and giving them permissions9.8.1 Help view the grant command1. Obtain the following help information by entering "assist Grant" in MySQL.mysql> help grant;……省略部分…….CREATE USER ‘jeffrey‘@‘localhost‘ IDENTIFIED BY
Rights Management:User:System level: The user is a user name ===> user name: passwordWhat can I do?1. Login System2. Management System objectsMysql:is no longer a simple user name and passwordUser name @ ' host range ' host range is called
One account Management1 Create an account:Example 1:Set up account ZWJ with all permissions on all databasesMysql> Grant All on * * to ' zwj ' @ ' 192.168.154.180 ';Query OK, 0 rows affected (0.01 sec)Set a password for ZWJMysql> Grant All on * * to
Permissions
Revoke permissionsRevoke all on * * from ' root ' @ ' 192.168.0.197 ';
Revoke permissionsRevoke all on * * from ' xx_db ' @ '% ';
Give the specified user permissions to the specified database selectGrant SELECT on
User ManagementAuthentication: AuthenticationAaa:Authentication: AuthenticationAuthorization: Rights ManagementAudition: AuditGrant: Authorizationunset: Undo (Eliminate)Sql>echo $ORACLE _sid ORCL query database is named ORCLSql>vnset ORACLE_SID
1. Account Management 1.1 login and exit MySQL server mysql–hhostname|hostip–p port–u username–p[password] databasename–e "SQL statement"-h-h host name or Ip-p-pport[3306]-u-u[username]-p-p[password]Note: betweenAllno spaces!-e Execute SQL statement
Www.eygle.comdigest200801mysql_create_user.html 1. CREATEUSERCREATEUSERuser [IDENTIFIEDBY [PASSWORD] password] [, user [IDENTIFIEDBY [PASSWORD] password]... CREATEUSER is used to create a new MySQL account. To use CREATEUSER,
MySql database is the first choice for Small and Medium-sized website back-end databases because it is free for non-commercial applications. website developers can build a "Linux + Apache + PHP + MySql" platform, which is the most cost-effective and
MySQL experience 9-USER and data security 1. You can use the create user syntax to add one or more users and set the corresponding password. Syntax format: create user user [identified BY [PASSWORD] 'Password'] [, user [identified by [password]
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.