INSTALLATION DOCUMENTS BY RAVI

Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

Sunday, March 11, 2018

How to automatically start mysql after server reboot linux machine


If we want mysql server to start automatically on reboot

Issue the below command:


chkconfig --level 345 mysqld on






Reboot the machine and check now.


Monday, November 27, 2017

MySQL Daemon failed to start

When try to start the mysql database getting the below error:

"MySQL Daemon failed to start"





Try with the command mysql as below and check for the error





Here we get the error " Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' "

To resolve this error check the my.conf file under /etc folder















Here in my case bind address is different from my host ip address so I changed it to my host ip address and tried to start mysql again






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
























  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...