JaoudeStudios.com • View topic - Create user & access to a specific database

View unanswered posts | View active topics

Board index » Private Area » .: Jaoude Studios :: Snippets :. » MySQL

All times are UTC

Create user & access to a specific database

Page 1 of 1

[ 1 post ]

Print view

Previous topic | Next topic

Author

Message

jaoudestudios

Post subject: Create user & access to a specific database

Posted: Sat May 22, 2010 12:00 pm

Site Admin

Joined: Wed Jul 02, 2008 7:54 pm
Posts: 596
Location: Surrey

Code:

CREATE USER 'user1'@'localhost' IDENTIFIED BY 'pass1';

Code:

GRANT ALL ON [db_name].* TO 'user1'@'localhost';

_________________
JaoudeStudios.com :: Eddie Jaoude :: Geek by nature, Linux by choice
Forum JaoudeStudios - php, mysql, xhtml, css, javascript, jquery, svn subversion, linux, lamp, W3C
Online Agile Task board
Open Source is the road ahead!!

Top

Page 1 of 1

[ 1 post ]

Board index » Private Area » .: Jaoude Studios :: Snippets :. » MySQL

All times are UTC

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to: