Mysql Setup

Revision as of 12:29, 27 July 2018 by 183.82.123.128 (talk) (Created page with "* TO login as root: '''1.mysql -uroot -p''' '''enter root password''' * to creating user with password, giving privilages: '''newrelic-install purge''' '''GRANT ALL PRIVIL...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
  • TO login as root:

1.mysql -uroot -p

enter root password

  • to creating user with password, giving privilages:

newrelic-install purge

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';

dpkg -l | grep newrelic

(nothing should show when you run the above, if anything, proceed to manually removing the remaining services)

service nginx restart

service php7.0-fpm restart

  • For MySQL agent:

cd /root/newrelic-npi

./npi stop com.newrelic.plugins.mysql.instance

./npi remove-service com.newrelic.plugins.mysql.instance

./npi remove com.newrelic.plugins.mysql.instance