Add a user : User : Privilege MySQL TUTORIALS

Navioo.com

MySQL TUTORIALS » Privilege » User »

Add a user


mysql>
INSERT INTO user VALUES('localhost','TestUser',PASSWORD('pass123'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
mysql>
mysql>

Related Scripts with Example Source Code in same category :

Add your database and users to the mysql database.
In the default setting of MySQL access privileges, every user is permitted to create databases on a local computer that begin with the word 'test.'
SELECT host, user, select_priv, update_priv FROM user
select convert(SUBSTR(USER(),1,INSTR(USER(),'@')-1) using latin1)

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
» User

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