Differences

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

howto:1st_steps 2018/02/12 01:54 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 308: Line 312:
</code> </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>+  * 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>    <code>   
    # The MySQL server     # The MySQL server
Line 314: Line 318:
    port = 3306     port = 3306
    socket = /ffp/var/run/mysql/mysql.sock     socket = /ffp/var/run/mysql/mysql.sock
-    datadir = /ffp/var/lib/mysql/+    datadir = /ffp/var/lib/mysql
    skip-external-locking     skip-external-locking
    key_buffer_size = 16K     key_buffer_size = 16K
Line 320: Line 324:
Create space for logs, then initialize the data directory. (**fun_plug** 0.7) <code> Create space for logs, then initialize the data directory. (**fun_plug** 0.7) <code>
-    # mkdir -p /srv/mysql/ +    # mkdir -p /srv/mysql 
-    # mysql_install_db --datadir=/ffp/var/lib/mysql/+    # mysql_install_db --datadir=/ffp/var/lib/mysql
</code> </code>
Line 328: Line 332:
    # 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 342: 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 352: 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
[Edit]
Personal Tools