Differences
This shows you the differences between the selected revision and the current version of the page.
| howto:1st_steps 2018/02/12 02:08 | howto:1st_steps 2018/02/12 02:17 current | ||
|---|---|---|---|
| Line 345: | 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 355: | 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 ) | ||
