LINUX How to using sql command line

Open a terminal window.
Connect to the MySQL server using your root MySQL password and go to the mysql database within it:
1. Create local sql username
mysql -u root -p mysql
At the mysql> prompt, type:
GRANT ALL PRIVILEGES ON *.* TO mary@localhost IDENTIFIED BY 'ship3marker';
then press ENTER.
This command string creates a new account on the MySQL server for the user mary. Her password is ship3marker.
2. Create remote sql username
GRANT ALL PRIVILEGES ON *.* TO remote@'%' IDENTIFIED BY 'nopass' WITH GRANT OPTION;
then press ENTER.
This command string is slightly different than the previous one:
TO marty@'%'
GRANT ALL PRIVILEGES ON *.* TO marty@'%' IDENTIFIED BY 'watch4keys' WITH GRANT OPTION;
The % wildcard allows connections on this account from any domain, not just localhost.
If you only wanted connections from the visibooks.com domain, you'd use this instead:
GRANT ALL PRIVILEGES ON *.* TO marty@visibooks.com IDENTIFIED BY 'watch4keys' WITH GRANT OPTION;
The GRANT OPTION sets the ability to GRANT privileges to other users. In other words, marty can create accounts for new users.
flush privileges;

Comments

Post a Comment

Popular posts from this blog

Java : Variables Declaring

[1]. Java Variables Variables are containers for storing data values. In Java, there are different types of variables, for example: String - stores text, such as "Hello". String values are surrounded by double quotes int - stores integers (whole numbers), without decimals, such as 123 or -123 float - stores floating point numbers, with decimals, such as 19.99 or -19.99 char - stores single characters, such as 'a' or 'B'. Char values are surrounded by single quotes boolean - stores values with two states: true or false [2]. Declaring (Creating) Variables To create a variable, you must specify the type and assign it a value: Syntax type variable = value ; Where type is one of Java's types (such as int or String), and variable is the name of the variable (such as x or name). The equal sign is used to assign values to the variable. To create a variable that should store text, look at the following example: Example Create a variable called  name  of type  Stri...
Read more

SQL Self JOIN

SQL Self JOIN A self JOIN is a regular join, but the table is joined with itself. Self JOIN Syntax SELECT column_name(s) FROM table1 T1, table1 T2 WHERE condition; T1 and T2 are different table aliases for the same table.
Read more