<!DOCTYPE html> <html> <head> </head> <body> <div> <div style="color: #000000; font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium;"><span style="font-size: small;">mysql –password=xxxxxxxxxxxxx</span></div> <div style="color: #000000; font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium;"><span style="font-size: small;">GRANT ALL PRIVILEGES ON *.* TO root@192.168.221.5 IDENTIFIED BY 'xxxxxxx';</span><br /><span style="font-size: small;"><br />or</span><br /><span style="font-size: small;"><code><br />GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'xxxxxxxx';</code></span></div> <div style="color: #000000; font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium;"><span style="font-size: small;"> </span></div> <div style="color: #000000; font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium;"> <p><span style="font-size: small;">Bind to all addresses:</span></p> <p><span style="font-size: small;"><br />The easiest way is to comment out the line in your /etc/mysql/<code>my.cnf</code> file:</span></p> <pre><span style="font-size: small;"><code>#bind-address = 127.0.0.1 or 185.54.81.20</code></span></pre> <p><span style="font-size: small;">and restart mysql</span></p> <pre><span style="font-size: small;"><code>service mysql restart</code></span></pre> <p><span style="font-size: small;">To check where mysql service has binded execute as root:</span></p> <pre><span style="font-size: small;"><code>netstat -tupan | grep mysql</code></span></pre> </div> </div> </body> </html>
Subscribe
0 Comments
Oldest