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

Lambda Function with Amazon SNS

Amazon SNS is a service used for push notification. In this chapter, we will explain working of AWS Lambda and Amazon SNS with the help of an example where will perform the following actions − Create Topic in SNS Service and use AWS Lambda Add Topics to CloudWatch Send SNS text message on phone number given. Requisites To create Topic in SNS Service and use AWS Lambda Add Topics to CloudWatch, we need not follow the steps given below − Create Topic in SNS Create Role for permission in IAM Create AWS Lambda Function Publish to topic to activate trigger Check the message details in CloudWatch service. To send SNS text message on phone number given, we need to do the following − Add code in AWS Lambda to send message to your phone. Example In this example, we will create a topic in SNS. When details are entered in the topic to publish, AWS Lambda is triggered. The topic details are logged in CloudWatch and a message is sent on phone by AWS Lambda. Here is a basic block diagram which exp

Unix / Linux - Shell Input/Output Redirections

W e will discuss in detail about the Shell input/output redirections. Most Unix system commands take input from your terminal and send the resulting output back to your terminal. A command normally reads its input from the standard input, which happens to be your terminal by default. Similarly, a command normally writes its output to standard output, which is again your terminal by default. Output Redirection The output from a command normally intended for standard output can be easily diverted to a file instead. This capability is known as output redirection. If the notation > file is appended to any command that normally writes its output to standard output, the output of that command will be written to file instead of your terminal. Check the following who command which redirects the complete output of the command in the users file. $ who > users Notice that no output appears at the terminal. This is because the output has been redirected from the default standard output dev

Unix / Linux - Shell Functions

W e will discuss in detail about the shell functions. Functions enable you to break down the overall functionality of a script into smaller, logical subsections, which can then be called upon to perform their individual tasks when needed. Using functions to perform repetitive tasks is an excellent way to create code reuse . This is an important part of modern object-oriented programming principles. Shell functions are similar to subroutines, procedures, and functions in other programming languages. Creating Functions To declare a function, simply use the following syntax − function_name () { list of commands } The name of your function is function_name , and that's what you will use to call it from elsewhere in your scripts. The function name must be followed by parentheses, followed by a list of commands enclosed within braces. Example Following example shows the use of function − #!/bin/sh # Define your function here Hello () { echo "Hello World" } # Invoke yo

M&P Technology - Issue - Solution

Search This Blog