Differences
This shows you the differences between the selected revision and the current version of the page.
| howto:1st_steps 2018/02/12 01:44 | howto:1st_steps 2018/02/12 02:17 current | ||
|---|---|---|---|
| Line 251: | Line 251: | ||
| * Test PHP in webserver \\ Navigate browser to http://10.10.10.123:8080/a.php and read the page | * Test PHP in webserver \\ Navigate browser to http://10.10.10.123:8080/a.php and read the page | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| Line 277: | Line 282: | ||
| </code> | </code> | ||
| - | Comment extension dir line. This line is under the **Paths and Directories** heading, which is 42% of the way through the file.<code> | + | Comment extension dir line. This line is under the //Paths and Directories// heading, which is 42% of the way through the file.<code> |
| ;extension_dir = "./" | ;extension_dir = "./" | ||
| </code> | </code> | ||
| Line 295: | Line 300: | ||
| * Copy the my.cnf template. (**fun_plug** 0.7) <code> | * Copy the my.cnf template. (**fun_plug** 0.7) <code> | ||
| # cp /ffp/etc/examples/mysql/my-small.cnf /ffp/etc/my.cnf | # cp /ffp/etc/examples/mysql/my-small.cnf /ffp/etc/my.cnf | ||
| + | </code> | ||
| + | |||
| + | * Edit the my.cnf template. Here is how it looks before editing. (**fun_plug** 0.7) | ||
| + | <code> | ||
| + | # The MySQL server | ||
| + | [mysqld] | ||
| + | port = 3306 | ||
| + | socket = /ffp/var/run/mysql/mysql.sock | ||
| + | skip-locking | ||
| + | key_buffer_size = 16K | ||
| + | </code> | ||
| + | |||
| + | * This is what it should look like after editing. A //datadir// row has been added, and //skip-locking// has been changed to //skip-external-locking//. (**fun_plug** 0.7) | ||
| + | <code> | ||
| + | # The MySQL server | ||
| + | [mysqld] | ||
| + | port = 3306 | ||
| + | socket = /ffp/var/run/mysql/mysql.sock | ||
| + | datadir = /ffp/var/lib/mysql | ||
| + | skip-external-locking | ||
| + | key_buffer_size = 16K | ||
| + | </code> | ||
| + | |||
| + | Create space for logs, then initialize the data directory. (**fun_plug** 0.7) <code> | ||
| + | # mkdir -p /srv/mysql | ||
| + | # mysql_install_db --datadir=/ffp/var/lib/mysql | ||
| </code> | </code> | ||
| Prepare MySQL. Be careful, initial password setting is possible only at the first time | Prepare MySQL. Be careful, initial password setting is possible only at the first time | ||
| <code> | <code> | ||
| - | # mkdir -p /srv/mysql/ | ||
| # sh /ffp/start/mysqld.sh start | # sh /ffp/start/mysqld.sh start | ||
| # mysql_secure_installation | # mysql_secure_installation | ||
| - | # mysql_install_db | ||
| </code> | </code> | ||
| - | |||
| * Test MySQL local connection <code> | * Test MySQL local connection <code> | ||
| - | # /ffp/bin/mysql -uroot -ptoor | + | # /ffp/bin/mysql -uroot -p |
| mysql> show databases; | mysql> show databases; | ||
| mysql> use mysql; | mysql> use mysql; | ||
| Line 317: | Line 345: | ||
| # sh /ffp/start/lighttpd.sh restart | # sh /ffp/start/lighttpd.sh restart | ||
| </code> Navigate browser to http://10.10.10.123:8080/a.php and see mysql section at the page | </code> Navigate browser to http://10.10.10.123:8080/a.php and see mysql section at the page | ||
| + | |||
| Line 327: | Line 356: | ||
| * Allow user 'root' to connect remotely, for instance to administrate MySQL with graphical tools (SQLYog mysqladmin) <code> | * Allow user 'root' to connect remotely, for instance to administrate MySQL with graphical tools (SQLYog mysqladmin) <code> | ||
| - | # /ffp/bin/mysql -uroot -ptoor | + | # /ffp/bin/mysql -uroot -p |
| - | mysql> GRANT ALL ON *.* TO root@'10.10.10.150'IDENTIFIED BY 'toor' ; | + | mysql> GRANT ALL ON *.* TO root@'10.10.10.150'IDENTIFIED BY 'put-your-root-password-here' ; |
| mysql> FLUSH PRIVILEGES; | mysql> FLUSH PRIVILEGES; | ||
| </code> | </code> | ||
| * Add new user with strictly defined rights <code> | * Add new user with strictly defined rights <code> | ||
| - | # /ffp/bin/mysql -uroot -ptoor | + | # /ffp/bin/mysql -uroot -p |
| mysql> INSERT INTO mysql.user | mysql> INSERT INTO mysql.user | ||
| ( HOST, USER, PASSWORD, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv, reload_priv, shutdown_priv, process_priv, file_priv, grant_priv, references_priv, index_priv, alter_priv, show_db_priv, super_priv, create_tmp_table_priv, lock_tables_priv, execute_priv, repl_slave_priv, repl_client_priv, create_view_priv, show_view_priv, create_routine_priv, alter_routine_priv, create_user_priv, event_priv, trigger_priv ) | ( HOST, USER, PASSWORD, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv, reload_priv, shutdown_priv, process_priv, file_priv, grant_priv, references_priv, index_priv, alter_priv, show_db_priv, super_priv, create_tmp_table_priv, lock_tables_priv, execute_priv, repl_slave_priv, repl_client_priv, create_view_priv, show_view_priv, create_routine_priv, alter_routine_priv, create_user_priv, event_priv, trigger_priv ) | ||
