2,187
edits
(Added "MySQL") |
(→Install: Added steps to allow remote access) |
||
Line 198: | Line 198: | ||
# Run the following command to install MySQL | # Run the following command to install MySQL | ||
#* <code> apt-get install mysql-server </code> | #* <code> apt-get install mysql-server </code> | ||
To allow access from remote hosts... | |||
# Open MySQL service TCP/IP port by editing the <code> /etc/mysql/my.cnf </code> config file and restarting | |||
#* Change bind IP to server's IP, EG <code> bind-address = 192.168.1.123 </code> | |||
#* Restart service <code> /etc/init.d/mysql restart </code> | |||
# Allow remote access to a user account | |||
#* EG <code> GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'pass' WITH GRANT OPTION; </code> | |||