Changes between Version 1 and Version 2 of MySQLremote


Ignore:
Timestamp:
Sep 21, 2007, 2:16:08 PM (14 years ago)
Author:
Fredrik Levander
Comment:

Fixes #271

Legend:

Unmodified
Added
Removed
Modified
  • MySQLremote

    v1 v2  
    1 == How to grant rights for remote access to a MySQL server ==
     1= How to grant rights for remote access to a MySQL server =
    22
    331. At the MySQL server run:
    44
    5 mysql -u root -p mysql
     5`   mysql -u root -p mysql`
    66
    772. Once logged in, create an account:
    88
    9 mysql> GRANT ALL PRIVILEGES ON *.* TO 'account_name'@'IP_address_of_Proteios_web_server' IDENTIFIED BY 'your_password' WITH GRANT OPTION;
     9`   mysql> GRANT ALL PRIVILEGES ON *.* TO 'account_name'@'IP_address_of_Proteios_web_server' IDENTIFIED BY 'your_password' WITH GRANT OPTION;`
    1010
    11113. log out
    1212
    13 mysql> exit;
     13`   mysql> exit;`
    1414
    15154. Check that it worked from the computer where you're going to install Proteios:
    1616
    17 mysql -h IP_address_of_mysql_server -u account_name -p mysql
     17`   mysql -h IP_address_of_mysql_server -u account_name -p mysql`
    1818
    19 5. If you're allowed to log in you can now proceed with the Proteios installation
     195. If you're allowed to log in with `your_password` you can now proceed with the Proteios installation
    2020