Differences

This shows you the differences between the selected revision and the current version of the page.

howto:1st_steps 2018/02/12 02:04 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 334: Line 335:
  * 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 344: 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 354: 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 )

Navigation

Personal Tools