How To Create New Users In Mysql With PRIVILEGES

By -
Adding New User In MySQL

We can create users in MySQL in two ways:
1) By using statements intended for creating accounts, such as CREATE USER or GRANT
2) By manipulating the MySQL grant tables directly with statements such as INSERT,
UPDATE, or DELETE

I will show you how, can we add user using the first method, that is using MySQL grant command.

First, use the mysql program to connect to the server as the MySQL root user. Here root user is representing the Main Super Admin kind of user. If we have password for this Super user root then perform the following command,

First, use the mysql program to connect to the server as the MySQL root user:
shell> mysql --u=root –p

The system will ask you for password, then enter the password
Shell>*******

If you don’t have any password set for the Super User root, u can connect to the MySQL server as follows,

shell> mysql --user=root




Then select the mysql database (Note:: here the name of the database is it self mysql)

Shell> use mysql





After connecting to the server as root, you can add new accounts. The following
A) To add an user with username “sidd” and password “mypassword” who can connect only from “localhost” and with all privileges and grant option.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'sidd'@'localhost'
-> IDENTIFIED BY 'mypassword' WITH GRANT OPTION;


B) To add an user with username “siddharth” and password “mypassword” who can connect only from any host and with all privileges and grant option.


mysql> GRANT ALL PRIVILEGES ON *.* TO 'siddharth'@'%'
-> IDENTIFIED BY ' mypassword' WITH GRANT OPTION;


C) To add and user “junioruser” with no password, and without any privileges

mysql> GRANT USAGE ON *.* TO ' junioruser'@'localhost';

in this example the user "junioruser" can connect only from localhost to the database server. In the same example if you want the same user to be able to connect from any computer
fire the following ,

mysql> GRANT USAGE ON *.* TO ' junioruser'@'%';

The USAGE privilege in the GRANT statement enables you to create an account without giving it any privileges. It has the effect of setting all the global privileges to 'N'. It is assumed that you will grant specific privileges to the account later.


D) To Add and user maintenanceacc who will not access the database, but will perform database related maintenances work like
mysqladmin reload, mysqladmin refresh etc.

mysql> GRANT RELOAD,PROCESS ON *.* TO ' maintenanceacc admin'@'localhost';

Comments

Post a Comment

Popular posts from this blog

Converting Java Map to String

By -
Java Collections framework, String manipulation etc is something that we often encounter in Development process. For processing collections (like checking null/empty, Intersection, Disjunction) We do have some of the very use full libraries. Some of the Collection related libraries are Apche Commons Collections and Google  Collections(Guava). Problem Use Case This article explains how to convert a Java Map to String(and vice versa) using different libraries and technique. One way is to use StringBuilder(Or String) and loop though the Map and build the String by applying some sort of separator ( for key:value and entry). Here we have to take care of the null value etc. Without Any Library If we want to convert the map to a String with key value separator and also individual entry seperator in the resulting String, we have to write code for that. For a simple Map, we have to iterate though the map, take care of the null values etc. Following is a sample to get String built
Read more

Difference between volatile and synchronized

By -
volatile is a field modifier, while synchronized modifies code blocks and methods. So we can specify three variations of a simple accessor using those two keywords: int i1; int geti1() {return i1;} volatile int i2; int geti2() {return i2;} int i3; synchronized int geti3() {return i3;} geti1() accesses the value currently stored in i1 in the current thread . Threads can have local copies of variables, and the data does not have to be the same as the data held in other threads. In particular, another thread may have updated i1 in it's thread, but the value in the current thread could be different from that updated value. In fact Java has the idea of a "main" memory, and this is the memory that holds the current "correct" value for variables. Threads can have their own copy of data for variables, and the thread copy can be different from the "main" memory. So in fact, it is possible for the "main"
Read more

Invoking EJB deployed on a remote machine

By -
Invoking EJB deployed on a remote machine In case we are calling remote ejb( ejb deployed on remote machines), The JNDI lookup might lookup like, Properties env = new Properties(); env.put(Context.INITIAL_CONTEXT_FACTORY, "org.jnp.interfaces.NamingContextFactory"); env.put(Context.PROVIDER_URL, "XX.XXX.XX.XX:1099"); env.put("java.naming.factory.url.pkgs", "org.jboss.naming:org.jnp.interfaces"); Context ctx = new InitialContext(env); If we are calling local ejb then we can simply create InitialContext without any parameters. Like, Context ctx = new InitialContext();
Read more