A user doesn't need a password if connecting from a certain machine : Grant : Privilege MySQL TUTORIALS

Navioo.com

MySQL TUTORIALS » Privilege » Grant »

A user doesn't need a password if connecting from a certain machine


GRANT ALL PRIVILEGES
ON myDatabase.*
TO newuser@192.168.0.2

Related Scripts with Example Source Code in same category :

Granting Privileges on the new database
WITH GRANT OPTION condition allows the user to give others privileges to that database
GRANT ALL
Add localhost to mysql table for accessing sample_db
Grant Select and Update privilege to a user
Grant select, update privilege for a remote user
GRANT OPTION MAX_QUERIES_PER_HOUR 50 MAX_UPDATES_PER_HOUR 50
GRANT SELECT, UPDATE ON databaseName.*

Leave a Comment / Note

Name (required)

email (will not be published) (required)

Website

V�rification Refresh

Enter code

Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

MySQL TUTORIALS

Navioo

Privilege
» Grant

Aggregate Functions

Aggregate Functions

Cast Functions Operators

Cast Functions Operators

Comparison Functions Operators

Comparison Functions Operators

Control Flow Functions

Control Flow Functions

Cursor

Data Dictionary

Data Dictionary

Data Types

Database

Date Time Functions

Date Time Functions

Encryption Compression Functions

Encryption Compression Functions

Information Functions

Information Functions

Insert Update Delete

Insert Update Delete

Introduction

Logic Operator

Math Numeric Functions

Math Numeric Functions

Miscellaneous Functions

Miscellaneous Functions

MySQL Utilities

MySQL Utilities

Privilege

Procedure Function

Procedure Function

Regular Expressions

Regular Expressions

Select Query

String Functions

String Functions

Subquery

Table

Table Join

Trigger

View

hits counter