search

ag35 / SEBC_NYC

Coudera Service Enablement BootCamp
0 stars 0 forks source link

Install MySQL #14

Closed ag35 closed 8 years ago

ag35 commented 8 years ago

added to my.cnf for HUE so that I do not have to adjust it in the future ... sql_mode=STRICT_ALL_TABLES;

ag35 commented 8 years ago

Got STUCK ... with mysql will not start. trying the following

Uninstall mysql using yum remove mysql* Recursively delete /usr/bin/mysql and /var/lib/mysql Delete the file /etc/my.cnf.rmp Use ps -e to check the processes to make sure mysql isn't still running. Reboot server with reboot Run yum install mysql-server. This also seems to install the mysql client as a dependency. Give mysql ownership and group priveleges with:

chown -R mysql /var/lib/mysql

chgrp -R mysql /var/lib/mysql Use service mysqld start to start MySQL Daemon.

Then ---- REMOVE AND REINSTALL THE CLIENT!!! --- Otherwise it will not find mysql executable!

ag35 commented 8 years ago

And that worked!!!

mikeridley commented 8 years ago

Looks good.