Differences

This shows you the differences between two versions of the page.

--- setup_note_for_mysql [2009/03/13 04:48]
ben created
+++ setup_note_for_mysql [2009/12/08 03:38] (current)
ben
@@ Line 1: / Line 1: @@
+<code>
   [ben@vince wiki]$ mysql -u root -p
   Enter password:
@@ Line 13: / Line 14: @@
   mysql> GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'localhost' IDENTIFIED BY '-----' WITH GRANT OPTION;
   Query OK, 0 rows affected (0.02 sec)
+</code>
+From my MacPorts install on my local machine:
+<code>
+To start mysqld at boot time you have to copy
+support-files/mysql.server to the right place for your system
+PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
+To do so, start the server, then issue the following commands:
+/opt/local/lib/mysql5/bin/mysqladmin -u root password 'new-password'
+/opt/local/lib/mysql5/bin/mysqladmin -u root -h frieda.local password 'new-password'
+Alternatively you can run:
+/opt/local/lib/mysql5/bin/mysql_secure_installation
+which will also give you the option of removing the test
+databases and anonymous user created by default.  This is
+strongly recommended for production servers.
+See the manual for more instructions.
+You can start the MySQL daemon with:
+cd /opt/local ; /opt/local/lib/mysql5/bin/mysqld_safe &
+You can test the MySQL daemon with mysql-test-run.pl
+cd /opt/local/mysql-test ; perl mysql-test-run.pl
+Please report any problems with the /opt/local/lib/mysql5/bin/mysqlbug script!
+The latest information about MySQL is available at http://www.mysql.com/
+Support MySQL by buying support/licenses from http://shop.mysql.com/
+</code>

..., etc.

User Tools

Site Tools

Differences

Page Tools