Thursday, July 27, 2017

mysql server on linux

1. Checking the status of mysql server

Open the terminal and run the below command to check the status of the mysql server

2. Starting mysql server

Run the below command to start the mysql server

3. Setting a password for mysql root user

To set the password for linux root user run the below command

4. Connecting to the mysql server as a root user

5. Granting privileges to mysql server to connect remotely

6. Binding ip address and port no for mysql server

Under /etc modify my.cnf file as below

No comments:

Post a Comment

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...