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

Loading xml file data to oracle table using python

Sample xml file (test.xml): <?xml version="1.0"?> <data>     <customer name="Ravi" >     ...