mysql grant all privileges to remote user

The MySQL permissions system revolves around two concepts:Authentication, determining whether a user is allowed to connect to a database serverAuthorization, determines whether the user has sufficient permissions to execute the query request, and so

I configured permissions to access the database in my virtual machine under WindowsSource: http://blog.csdn.net/louisliaoxh/article/details/52767209Login:Log in using the command line on this computer and switch to the MySQL library- - P use

Transferred from: http://chenling1018.blog.163.com/blog/static/14802542010320112355598/The MySQL permissions system revolves around two concepts:Authentication, determining whether a user is allowed to connect to a database serverAuthorization,

MySQLStudy-MySQL User and permission management MySQL server uses the MySQL permission table to control user access to the database. the MySQL permission table is stored in the mysql database and initialized by the mysql_install_db script. These

MYSQL adds remote users or allows remote access.Add the remote user admin password as password grant all privileges on *. * TO admin @ localhost identified by \ 'password \ 'with grant option grant all privileges on *. * TO admin @ \ "% \"

Install MySQL1. Download the MySQL Installation FileThe following two files are required to install MYSQL:MySQL-server-5.1.7-0.i386.rpm To download the above two RPM files, locate the "server" and "client programs" items and find the items

In the process of using MySQL, we often need to authorize the user (add, modify, delete), in MySQL there are three ways to implement the method of INSERT user table, CREATE user method, Grant method. Let's take a look at how the grant method is

1 syntaxGrant permission 1, permission 2,... Permission n on the database name. Table name to User name @ user address identified by ' connection password ';1.1 PermissionsIf you want to grant all permissions for the user to manipulate the database

Add the remote user admin password passwordGRANTALLPRIVILEGESON ** TOadmin @ localhostIDENTIFIEDBYpasswordWITHGRANTOPTIONGRANTALLPRIVILEGESON ** TOadmin @ % ID add the remote user admin password as password grant all privileges on *. * TO admin @

Set the user to show database permission firstGrant Select,insert,update,delete on redmine1.* to [e-mail protected]"%" identified by "Jira";Add super permissions and allow remote access:GRANT all privileges on * * to ' myuser ' @ ' 192.168.1.3 '