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

Perfect order of ODI export and import

  Smart Export / Import is the recommended way to achieve such a migration. This is the easiest way to make sure all the dependencies are ta...