Differences
This shows you the differences between the selected revision and the current version of the page.
| accelerators:kb:config-internal-mysql 2009/11/05 15:56 | accelerators:kb:config-internal-mysql 2009/11/05 16:05 current | ||
|---|---|---|---|
| Line 32: | Line 32: | ||
| # svcadm restart mysql | # svcadm restart mysql | ||
| </code> | </code> | ||
| - | + | ===== Configure MySQL user ===== | |
| - | ===== Configure MySQL User ===== | + | |
| You may need to configure a MySQL user for your application to use. Login to MySQL and then do: | You may need to configure a MySQL user for your application to use. Login to MySQL and then do: | ||
| Line 40: | Line 39: | ||
| mysql> grant all on *.* to 'user'@'%' identified by 'password123'; | mysql> grant all on *.* to 'user'@'%' identified by 'password123'; | ||
| mysql> flush privileges; | mysql> flush privileges; | ||
| + | </code> | ||
| + | |||
| + | This will create a user to be able to connect from any IP. If you want to lock it down you can replace the '%' with the application server's IP, such as: | ||
| + | |||
| + | <code> | ||
| + | mysql> grant all on *.* to 'user'@'ip.of.app.accelerator' identified by 'password123'; | ||
| </code> | </code> | ||
| Line 51: | Line 56: | ||
| pass: password123 | pass: password123 | ||
| </code> | </code> | ||
| - | |||
| - | |||
