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] ben |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
[ben@vince wiki]$ mysql -u root -p | [ben@vince wiki]$ mysql -u root -p | ||
Enter password: | Enter password: | ||
Line 13: | Line 14: | ||
mysql> GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'localhost' IDENTIFIED BY '-----' WITH GRANT OPTION; | mysql> GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'localhost' IDENTIFIED BY '-----' WITH GRANT OPTION; | ||
Query OK, 0 rows affected (0.02 sec) | 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> | ||