MySQL is the company's SQL now...
Let’s face it; MySQL is a fabulous database engine. Not only is it free, it’s small, powerful and easy to drive. It also runs happily on free operating systems and so it can be used to create incredibly cost-effective database servers.
Of course, like all database engines, it polarizes those in the computing world. Some people love it, others regards it as the spawn of the devil.
Happily, deciding into which camp you fall is easy. You're a MySQL fan if you:
* can pronounce LINUX with authority
* prefer a command line to a GUI
* have a copy of ‘The Cathedral and the Bazaar’
* don’t read manuals
* are so productive that you can wear a t shirt at work
* hate Microsoft
You are not a MySQL fan if you actively choose to wear a suit and believe that bug counts are inversely proportional to price.
Note that this is Not very secure, and should only be used for a local development box where you don’t feel like setting up individual permissions, but still need to connect from other machines.
To configure this feature, you’ll need to update the mysql user table to allow access from any remote host, using the % wildcard.
Open the command-line mysql client on the server using the root account.